Displaying data tables according to dimension elements

Post Reply
spartan
Posts: 46
Joined: Thu Jun 21, 2018 8:33 am
OLAP Product: IBM cognos
Version: 10.2.2
Excel Version: 2013

Displaying data tables according to dimension elements

Post by spartan » Wed Sep 11, 2019 7:09 pm

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.

Wim Gielis
MVP
Posts: 2152
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.7
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Displaying data tables according to dimension elements

Post by Wim Gielis » 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 ?
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 service with AutoHotKey

spartan
Posts: 46
Joined: Thu Jun 21, 2018 8:33 am
OLAP Product: IBM cognos
Version: 10.2.2
Excel Version: 2013

Re: Displaying data tables according to dimension elements

Post by spartan » Thu Sep 12, 2019 3:38 am

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.

Wim Gielis
MVP
Posts: 2152
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.7
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Displaying data tables according to dimension elements

Post by Wim Gielis » Thu Sep 12, 2019 3:42 am

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

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 service with AutoHotKey

Post Reply