ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Compare qtr1 of 2005 to qtr1 of 2004 etc

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
rcdba Posted - 05/26/2005 : 15:33:01
Hi

How do we compare the qtr to qtr, month to month comparisons between 2004 and 2005 in reportportal?

We have one time dimension to support this but I am not sure how to create a report?
2   L A T E S T    R E P L I E S    (Newest First)
james.sacra Posted - 06/03/2005 : 13:40:22
rcdba: Another useful little MDX function for calculated members is PeriodsToDate(). This let's you get Month/Quarter/Year to date, even if you have a "custom" time dimension that isn't really a time dimension. (For example, a budgetted month may be much different than the calendar month).

Databasejournal.com is definitely a great source for all MDX questions.

http://www.databasejournal.com/features/mssql/article.php/10894_2238011_2
admin Posted - 05/28/2005 : 07:54:22
You would need to create a calculated member, which requires little knowledge of MDX. Below are some useful links:

http://www.databasejournal.com/features/mssql/article.php/2232111
http://www.databasejournal.com/features/mssql/article.php/2245791

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page