As you all know, we can't add additional member like "No Year" in Year Dimension. We can add number of years but not "No Year", as it is system defined.
But there is trick which Oracle published to add "No Year" in Year Dimension.
Steps are simple:
- Export Year Dimension
- Edit csv file, and add below line in bottom of the page.
- "No Year",Years,,store,false,,<none>,<none>,,,unspecified,false,true,,,"No Year",<none>,
- Save in zip format
- Import back in to Planning application.
Some times we may face issue with Data Management while loading SmartList data for BegBalance, like "No Year" member not found.
Thanks,
Mady