| T O P I C R E V I E W |
| n/a |
Posted - 03/15/2005 : 21:12:59
HI Igor and fellow RP guru's
What is the MDX to create a named set for a time dimesion to always show the current month based on system date??
This would allow users to create a report once that always shows the current month results. Therefore preventing the need to change the time filter on numerous reports each month.
TIA
Ryan
|
| 3 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 03/21/2005 : 18:08:32
Ryan,
You can create a member property called Is_Current_Date_Flag. The MDX would be:
Tail(Filter([MyDate].[Day].members, [MyDate].Properties("Is_Current_Date_Flag") ="yes" ),1).item(0)
|
| n/a |
Posted - 03/20/2005 : 19:07:15
Igor,
This would be a good solution if the time dimension does not extend beyond today!! For most of our customers they have budgets or forecasts that extend beyond the current day.
Can you advise the formula that uses system date to determine what the current day is in the time dimension??
thanks
Ryan
Cheers
Ryan |
| admin |
Posted - 03/17/2005 : 20:22:33
tail(filter([MyDate].[Day].members, not isempty([MyDate].currentmember)),1).item(0) |
Report Portal
