TM1 Forum

Hello All,

I have a scenario like, I need to display a table of 2 rows ad 5 columns for each element in a dimension. If a dimension has 2 elements i need to display 2 tables, it depends on the number of elements in a dimension.

1. How to display the tables according to the number of elements in a dimension. Is it possible to show only the number of tables that are equal to the number of elements in a dimension.
2. Is their any way to hide the tables according to the dimension size, as i a using the sheets in web. I guess VBA code does not work.

So you have a 2D table and another dimension. If my maths is still correct, 2 and 1 makes 3.
So how about creating a 3D cube... and a report on the cube with 2 stacked row dimensions ?

Wim Gielis wrote: ↑Wed Sep 11, 2019 7:21 pm So you have a 2D table and another dimension. If my maths is still correct, 2 and 1 makes 3.
So how about creating a 3D cube... and a report on the cube with 2 stacked row dimensions ?

Hello,
So cant we show only the number of tables according to the number of elements of a dimensions, like if my dimension has 5 elements i need to show 5 tables,
I am thinking to create 15 tables, and display all tables according to number of dimension elements, remaining has to hide. Because if a dimension has only one element if the tables were not hidden all 15 tables are displaying with no values.

That’s what we would call zero suppression on the outer row dimension...