topic Shy contracting time dimension in SAS Web Report Studio https://communities.sas.com/t5/SAS-Web-Report-Studio/Shy-contracting-time-dimension/m-p/150059#M1871 <HTML><HEAD></HEAD><BODY><P>Hi all wise people!</P><P></P><P>I have this setup: cube -&gt; Informationmap -&gt; Report</P><P></P><P>I have a time dimension with a hierarcy like year-&gt;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...</P><P></P><P>BUT, when a new year is added in the dimensiontable, the new year is not expanded in the report. Is this possible to fix?</P><P></P><P>/Daniel</P></BODY></HTML> Thu, 23 Jan 2014 08:07:28 GMT DannyDizzy 2014-01-23T08:07:28Z Shy contracting time dimension https://communities.sas.com/t5/SAS-Web-Report-Studio/Shy-contracting-time-dimension/m-p/150059#M1871 <HTML><HEAD></HEAD><BODY><P>Hi all wise people!</P><P></P><P>I have this setup: cube -&gt; Informationmap -&gt; Report</P><P></P><P>I have a time dimension with a hierarcy like year-&gt;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...</P><P></P><P>BUT, when a new year is added in the dimensiontable, the new year is not expanded in the report. Is this possible to fix?</P><P></P><P>/Daniel</P></BODY></HTML> Thu, 23 Jan 2014 08:07:28 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/Shy-contracting-time-dimension/m-p/150059#M1871 DannyDizzy 2014-01-23T08:07:28Z Re: Shy contracting time dimension https://communities.sas.com/t5/SAS-Web-Report-Studio/Shy-contracting-time-dimension/m-p/150060#M1872 <HTML><HEAD></HEAD><BODY><P>Noo need! I found the solution! <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P><P></P><P>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:</P><P>Descendants(&lt;&lt;Time.Time&gt;&gt;,1 , SELF_AND_AFTER)</P><P></P><P>/Daniel</P></BODY></HTML> Thu, 23 Jan 2014 11:13:42 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/Shy-contracting-time-dimension/m-p/150060#M1872 DannyDizzy 2014-01-23T11:13:42Z