Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Dynamic list/ Alternate hierarchy for Period dimension — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Dynamic list/ Alternate hierarchy for Period dimension

Received Response
23
Views
3
Comments
edited Dec 6, 2019 10:37AM in Financial Consolidation and Close 3 comments

Summary

Period dimension list

Content

Hello everybody,

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 !

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!