TM1 Forum

Hi there,

I am stuck with one problem.
I have a cube which has four dimension: Version, Organization, Class and Measure. In the web form, Version is a title dimension, Organization is displayed in rows, Class is displayed in columns. Both Organization and Class have a subset 'DailyUpdate' that are used in the web form.
After TI updates the subsets, I can see the changes through the cube view. I managed to change TM1ROW() to retrieve the updated subest values for Ograniztion, but I cannot find any place that allows me to do the same thing so I can have the updated sebset for Class.
Can you help please. Thank you.

nayitian wrote:Both Organization and Class have a subset 'DailyUpdate' that are used in the web form.

How exactly are you using the subset for the columns? You realize that web forms are not dynamic column-wise? The only way you can make them semi-dynamic for columns would be to use a SUBNM formula on the columns, referencing your DailyUpdate and then incrementing the index by one each column as you go to the right. Of course, you have to hard code the maximum number of columns and then make them invisible by conditional formatting when the SUBNM formula goes blank (it will when your index number exceeds the last member in the subset).

What I meant is that the subsets are used when defining the cube.
Thanks.

nayitian wrote:What I meant is that the subsets are used when defining the cube.
Thanks.

I don't think you know what you mean.

As Tomok said active forms only have dynamic row sets not dynamic columns. If you want to update the columns in the report then you need to use SUBNM formulas with index references to return the members for your column headers. SUBNM with an index reference greater than the number of elements in the subset returns an empty string so you would also need some conditional formatting to hide unused columns.