| 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
|