dbTalk Databases Forums  

Price variance

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


Discuss Price variance in the microsoft.public.sqlserver.olap forum.



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

Default Price variance - 09-16-2003 , 03:58 AM






Small interesting problem.

Form a facttabel with Time, Product, Sales, Volume and
Price I want to make a price variance from month to month
and year to year.

What is the best option because the calculated
measure/member: Volume this month * Price this month -
Volume this month * Price last month

Did not work because it gives very large numbers in the
total by dimension.

Regards,

Christiaan

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.