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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.