Hi all wise people!
I have this setup: cube -> Informationmap -> Report
I have a time dimension with a hierarcy like year->month, which I want to show as expanded in web report studio. So when I click "expand all" for that dimension in the report, all is fine...
BUT, when a new year is added in the dimensiontable, the new year is not expanded in the report. Is this possible to fix?
/Daniel
Noo need! I found the solution! ![]()
By putting the following expression in the time dimension in infomap studio I surpase the top level in the hierarky (all-members level) and always get expanded levels in the report for the dimension:
Descendants(<<Time.Time>>,1 , SELF_AND_AFTER)
/Daniel
Noo need! I found the solution! ![]()
By putting the following expression in the time dimension in infomap studio I surpase the top level in the hierarky (all-members level) and always get expanded levels in the report for the dimension:
Descendants(<<Time.Time>>,1 , SELF_AND_AFTER)
/Daniel
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.