SOLVE_ORDER question

#1

Hi,

What are the effects of settings SOLVE_ORDER of a calculated member to a
negative value ?
Is there any reserved values ?

Thanks for your help

Michel CARADEC

#2

Thanks for your reply.
I'm using solve order values such as -1, -2, etc. and got no problems.
I just wanted to be sure what was involded behing this.

Michel CARADEC

"Chris Webb" <OnlyForPostingToNewsgroups (AT) hotmail (DOT) com> wrote

Quote:

From the BOL topic 'Solve Order':

"Solve order values can range from -8181 to 65535. It is highly
recommended that you use only positive integers when setting solve order

values. Certain calculations reside at specific solve orders, as listed in
the following table. The solve order for a pass can become unpredictable if
these values are used by other calculations.

Quote:

Calculation
Solve order
Calculated cell formula
-6143
Custom rollup formulas (if not otherwise
-5119
Virtual dimensions created with earlier versions of Analysis
Services -4097
Visual totals
-4096
All other calculations (if not otherwise specified)
0

For example, changing the solve order for a calculated cells definition
below the default custom rollup formula value of -5119 causes the calculated

cells definition to be calculated before the custom rollup formulas; this
can produce incorrect results."

Quote:

For what it's worth, I've occasionally used negative solve orders and not
encountered any problems.

HTH,

Chris

----- Michel CARADEC wrote: -----

Hi,

What are the effects of settings SOLVE_ORDER of a calculated member
to a
negative value ?
Is there any reserved values ?

Thanks for your help

Michel CARADEC

#3

Michel,

be aware that assigning a negative number to a caclulated member can produce undesired behaviour when using timerelated functions like YTD and ParallelPeriod.

Q

"Michel CARADEC" wrote:

Quote:

Thanks for your reply.
I'm using solve order values such as -1, -2, etc. and got no problems.
I just wanted to be sure what was involded behing this.

Michel CARADEC

"Chris Webb" <OnlyForPostingToNewsgroups (AT) hotmail (DOT) com> wrote in message
news:26F460E7-DC59-4390-9688-38115E34C5EB (AT) microsoft (DOT) com...
From the BOL topic 'Solve Order':

"Solve order values can range from -8181 to 65535. It is highly
recommended that you use only positive integers when setting solve order
values. Certain calculations reside at specific solve orders, as listed in
the following table. The solve order for a pass can become unpredictable if
these values are used by other calculations.

Calculation
Solve order
Calculated cell formula
-6143
Custom rollup formulas (if not otherwise
-5119
Virtual dimensions created with earlier versions of Analysis
Services -4097
Visual totals
-4096
All other calculations (if not otherwise specified)
0

For example, changing the solve order for a calculated cells definition
below the default custom rollup formula value of -5119 causes the calculated
cells definition to be calculated before the custom rollup formulas; this
can produce incorrect results."

For what it's worth, I've occasionally used negative solve orders and not
encountered any problems.

HTH,

Chris

----- Michel CARADEC wrote: -----

Hi,

What are the effects of settings SOLVE_ORDER of a calculated member
to a
negative value ?
Is there any reserved values ?

Thanks for your help

Michel CARADEC

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SOLVE_ORDER question

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

SOLVE_ORDER question - 05-25-2004 , 06:32 AM

Re: SOLVE_ORDER question - 05-25-2004 , 09:45 AM

Re: SOLVE_ORDER question - 07-20-2004 , 06:20 AM