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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.