dbTalk Databases Forums  

Formula error in a not leaf level

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


Discuss Formula error in a not leaf level in the microsoft.public.sqlserver.olap forum.



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

Default Formula error in a not leaf level - 08-24-2004 , 08:12 AM






I have a dimension Prod (Star Schema struture) that has the struture
bellow:

Total Prod
Prod A
Prod B

and I have another dimension, Schedule, wich is flat. My fact table
has the values:

Prod A Prod B
Schedule X 100
Schedule Y 10
Schedule Z

I created a Custom Member formula in Schedule Z that calcs X/Y for all
levels of Prod dimension, I mean, it's just X/Y, so when I slice the
cube in Total Prod member, the value of Z should be 10, but I've got
NULL, as in the example bellow.

Total Prod
Schedule X 100
Schedule Y 10
Schedule Z

It seems like the formula is working in the leaf level, because If I
change it to X+Y, I get the correct value, but it's strange because if
I put a 1 hardcoded in the formula, I get 1 in Total Prod instead of 2
wich is the value that would be returned if the formula was in the
leaf level.

My Prod dimension has the Unary Operator "+" in members A and B, I
don't have any other formula that use Schedule Z, I've also tried to
use a Cell Calculated formula, but the same strange behaviour occurs
with that.

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.