| T O P I C R E V I E W |
| n/a |
Posted - 09/30/2008 : 16:30:27
We have sales figures showing for each month (months are selected indiviudally as a filter to show the previous 13). However it means at the start of each new month that either, each of many reports has to be changed manually to add the new month or their MDX changed directly which is little faster. To makes matters worse, the next month can't be added in report portal until the data for that month exists so on the 2nd morning of a new month there are lots of staff who can't see any sales from the previous day until all the reports are changed. Has anyone any suggestion on how each month can be added to automatically (i.e adding MDX of some sort of date range) without using a YTD amount as this will not define it by month and is a pain? Thanks. |
| 2 L A T E S T R E P L I E S (Newest First) |
| MrSoly |
Posted - 10/07/2008 : 16:00:22
I've included the following WHERE clause in the MDX to automatically select the month of 10 days ago (because for the 1st 10 days of the month, people are only interested in the previous month). Your formula will depend on the Structure of your Date dimension - mine is Year/Quarter/Month/Day.
Where (StrToMember("[Date].[Year].&["+CStr(Year( DateAdd("d", -10, Now()) ))+"].&["+CStr(Datepart("q", DateAdd("d", -10, Now()) ))+"].&["+CStr(Month(DateAdd("d", -10, Now())))+"]"))
If used on Oct 8, 2008, the above evaluates to
StrToMember("[Date].[Year].&[2008].&[3].&[9]") |
| admin |
Posted - 10/01/2008 : 06:50:22
Why is it that the next month can't be added in report portal until the data for that month exists? Have you tried this setting: Options > None Empty tab > Show Filter empty items?
Have you tried to create a calculated member in Analysis Services that would aggregate the last 13 months? I would look something like: Aggregate(Tail(Time.Month.Members,13)). OLAP report will let you use the calculated member in the filter if you enable this setting: Options > General tab > Show Calculated Members.
|
|
|
Report Portal
