Traditional web-based reporting with SAS BI tools

Shy contracting time dimension

Accepted Solution Solved
Reply
Contributor
Posts: 28
Accepted Solution

Shy contracting time dimension

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


Accepted Solutions
Solution
‎01-23-2014 06:13 AM
Contributor
Posts: 28

Re: Shy contracting time dimension

Noo need! I found the solution! Smiley Happy

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

View solution in original post


All Replies
Solution
‎01-23-2014 06:13 AM
Contributor
Posts: 28

Re: Shy contracting time dimension

Noo need! I found the solution! Smiley Happy

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 733 views
  • 0 likes
  • 1 in conversation