dbTalk Databases Forums  

Ordering calculations

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


Discuss Ordering calculations in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bob
 
Posts: n/a

Default Ordering calculations - 11-05-2003 , 08:27 AM






Hi,
I've got a Margin measure which is calculated from (Sales-COGS) and a "Total
Expenses" which sums 3 measures, and I've got a Scenario dimension with
Actual, Budget and 2 variances (% and numeric).
I'm having problems to ask MS AS to first calculate the Measures and then
the Scenario.
For some of my Measure the result is correct, for others It returns
"infinite".
Any idea ?
Thanks
Bob



Reply With Quote
  #2  
Old   
Tom Chester
 
Posts: n/a

Default Re: Ordering calculations - 11-05-2003 , 09:17 AM






Bob, check out Solve Order -- a calculated member property.

tom @ the domain below
www.tomchester.net


"Bob" <Bob (AT) nowhere (DOT) com> wrote

Quote:
Hi,
I've got a Margin measure which is calculated from (Sales-COGS) and a
"Total
Expenses" which sums 3 measures, and I've got a Scenario dimension with
Actual, Budget and 2 variances (% and numeric).
I'm having problems to ask MS AS to first calculate the Measures and then
the Scenario.
For some of my Measure the result is correct, for others It returns
"infinite".
Any idea ?
Thanks
Bob





Reply With Quote
  #3  
Old   
Bob
 
Posts: n/a

Default Re: Ordering calculations - 11-05-2003 , 11:24 AM



Tom,
I was already convince, after visiting your web site, that you are a MS AS
'Jedi'.
It works fine now.
Thanks
Bob
BobNO (AT) SPAMcore-consulting (DOT) fr

PS : I know it's not the subject of the forum but have you ever seen Temtec
"Executive Viewer" front end tool against MS AS ? If so what's your feed
back about the tool ?


"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> a écrit dans le message de news:
339qb.20$_37.10320 (AT) news (DOT) uswest.net...
Quote:
Bob, check out Solve Order -- a calculated member property.

tom @ the domain below
www.tomchester.net


"Bob" <Bob (AT) nowhere (DOT) com> wrote in message
news:up9zyj6oDHA.1096 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
Hi,
I've got a Margin measure which is calculated from (Sales-COGS) and a
"Total
Expenses" which sums 3 measures, and I've got a Scenario dimension with
Actual, Budget and 2 variances (% and numeric).
I'm having problems to ask MS AS to first calculate the Measures and
then
the Scenario.
For some of my Measure the result is correct, for others It returns
"infinite".
Any idea ?
Thanks
Bob







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.