There are a couple of ways to automatically get the current month (or day or week or year) depending on several factors. Here is one of them:
1. Check the Member Unique Name (MUN) of your month members by right clicking a member and select Properties:
2. If your MUN is something logical like the one in the image above, then you are in luck!!! As you can see, the MUN of [2014/May] member (the current month as of this writing) consists of:
- Its dimension path: [Package].[Time Dim].[Time Dim].[Month]
- The expression ‘->:[PC@MEMBER].’
- Date code of the month starting day (20140501), a dash (‘-’), and date code of month ending day (20140531) enclosed in square brackets.
3. Create a data item, with a macro that will result to the MUN string:
The image below shows the data item named Current Month in a list (left) and the output when I ran the report:
No comments:
Post a Comment