I do the following which I think may fit you need:
Add the "Period" dimension to the Columns section.
Make the "Period" dimension the top most member of your column selections.
Hide that row.
Set the left most column to "Current Poinf of View for Period"
Select "Same As Col A" (for example) for the remaining report columns.
Add a column to the far right and use the &CurrentMonth substitution variable for the "Period" dimension. (The other dimensions in that column should be set, if possible, to retrieve as little data as possible.)
Hide the new column.
Change the function in the footer to <<MemberAlias(Grid1, A, "Period")>>
This should allow your user to select their desired period without impacting the hidden column value of &CurrentMonth which will be displayed in your footer.
Thank you for your detailed response. I did consider adding a separate column to the original grid as you suggested, but it ended up being more work than adding a new grid with only 1 dimension in each row and column and then hiding the column. Thank you so much again for your suggestion - it is definitely a great option for a simple report.
1 person found this helpful
If you need to restrict the POV selection for the period dimension so as the user couldn't select any member other than the subistitution variable, do as follows:
- In workspace, open File -> Preferences -> Financial Reporting -> User point of view -> setup members -> select the DB connection -> select the substitution variable for the Period dimension -> Apply -> Ok
- In FR studio, open the report -> put Period dimension in POV section in the dimension layout of the grid.
- Add text box in the footer -> write the function <<POVAlias("Grid name", period dimension name)>>
When the user run the report he has to select the substitution variable and it will be displayed in the text box in the footer. Also you can make the preview of user POV "off" to prevent the POV dialoge box for the user. So, he will have no choice.
Thank you for this helpful response. This feature limits the member selection for the Period dimension for all reports within that Database, which is not what I want. I'm trying to pull a substitution variable for Period and also allow users to select the period dimension they want to run the report on.
Your steps for limiting members in a POV dimension is helpful though. Thank you for your response!