dbTalk Databases Forums  

cube calculation when rows are duplicated in fact table?

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


Discuss cube calculation when rows are duplicated in fact table? in the microsoft.public.sqlserver.olap forum.



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

Default cube calculation when rows are duplicated in fact table? - 07-09-2004 , 03:04 PM






I have a facttable and a dimension table. I would like to show as a measurement the subtraction of to members of the dimension table. How can i do this?

I first tried to put the results of the calculation in the facttable but this did not work very well cause the row appears in the fact table more than once, so that when the cube aggregates the numbers are added more than once and are inaccurate.

I cannot put the results of the calculation in the dimension table because they are added multiple times and should only be one.



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

Default RE: cube calculation when rows are duplicated in fact table? - 07-10-2004 , 07:11 PM






sorry about the multiple posts... the forum gave me errors like it did not post so i tried again.

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.