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.
Displaying data tables according to dimension elements
-
- MVP
- Posts: 3113
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Displaying data tables according to dimension elements
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 ?
So how about creating a 3D cube... and a report on the cube with 2 stacked row dimensions ?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 47
- 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
Hello,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 ?
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.
-
- MVP
- Posts: 3113
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Displaying data tables according to dimension elements
That’s what we would call zero suppression on the outer row dimension...
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly