dbTalk Databases Forums  

Web Report Studio Using OLAP Year over Year calculation

comp.databases.olap comp.databases.olap


Discuss Web Report Studio Using OLAP Year over Year calculation in the comp.databases.olap forum.



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

Default Web Report Studio Using OLAP Year over Year calculation - 03-22-2010 , 02:16 PM






I currently have a calculated member in an OLAP cube to calculate Year
over Year differences (code below).

(([CUBE].[Revenue],[Fiscal_Year].CurrentMember) -
([CUBE].[Revenue],[Fiscal_Year].CurrentMember.PrevMember)),
FORMAT_STRING="DOLLAR15."

When I display this calculated member in WRS, I get unexpected
results. I would expect that the calculated member for the first time
period would be NULL or zero. Instead, it just displays the revenue
from the first time period. Example:

Year Revenue Calculated Member Expected Results
1 800 800 -
2 1000 200 200
3 1500 500 500

Is there a way to adjust my code or WRS settings to zero out or not
show the calculated member for the first time period?

Thanks,
Carrie

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.