dbTalk Databases Forums  

2 calculated members: nonmeasure and measure dimensions

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


Discuss 2 calculated members: nonmeasure and measure dimensions in the microsoft.public.sqlserver.olap forum.



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

Default 2 calculated members: nonmeasure and measure dimensions - 05-17-2004 , 05:03 AM






Hello,

I've got 2 different calculated members in a cube:

- Calculated member A based on the "measure" dimension.
- Calculated member B based on another dimension.

When browsing the cube, the cells of calculated member B, for each
calculated member A, are not correct, although it is correct for measures.
Is there a way of correcting that?

I've tried both the cube browser and the Excel Add-in of Office 2003, same
problem.

Thanks

Philippe



Reply With Quote
  #2  
Old   
Pluto
 
Posts: n/a

Default Re: 2 calculated members: nonmeasure and measure dimensions - 05-17-2004 , 10:03 AM






My problem was corrected by using the "Solve order" parameter correctly.
Some expressions had to be evaluated before others in order to get coherent
results...

Thanks anyway!

"Pluto" <pluto (AT) mickeymouse (DOT) com> a écrit dans le message de
news:%23hYgzY$OEHA.268 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
Quote:
Hello,

I've got 2 different calculated members in a cube:

- Calculated member A based on the "measure" dimension.
- Calculated member B based on another dimension.

When browsing the cube, the cells of calculated member B, for each
calculated member A, are not correct, although it is correct for measures.
Is there a way of correcting that?

I've tried both the cube browser and the Excel Add-in of Office 2003, same
problem.

Thanks

Philippe





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.