Dynamic list/ Alternate hierarchy for Period dimension
SummaryPeriod dimension list
I'm facing an issue with the clients request for Period display in certain reports. The request is f.e. If April is chosen in the prompt when running the report, the reports should display values within the range January - April, if October is chosen then the reports should display January - October, and so on...Does anyone have any idea or some hint or anything ? I have tried with relative function (Current point of view for Period -1, -2 , -3,...and i used conditional suppress but it didn't work, i always get all the months for which there was some entry). Is there an option to create an alternate hierarchy for Period dimension in FCCS, and then maybe I can use "Start Period" and "End Period" option, but I didn't manage to create alt hierarchy. Thanks in advance !