Hi there,
I am using the following MDX to default to the current month.
tail(filter([FiscalYear].[Month].members, not
isempty([FiscalYear].currentmember)),1).item(0)
The issue i have however, is if there is an incorrect transaction in the system for a date in the future, or of there is budget data, this MDX will not work. How can I use MDX to somehow point to the Current month from the System date?
Is there a way to do this?
e.g. Where system month = dimension time period
I am using the following MDX to default to the current month.
tail(filter([FiscalYear].[Month].members, not
isempty([FiscalYear].currentmember)),1).item(0)
The issue i have however, is if there is an incorrect transaction in the system for a date in the future, or of there is budget data, this MDX will not work. How can I use MDX to somehow point to the Current month from the System date?
Is there a way to do this?
e.g. Where system month = dimension time period