Search found 3 matches

by Silverik
Fri Sep 11, 2020 7:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form hell
Replies: 29
Views: 16675

Re: Active form hell

This is actually one of the drawbacks of using separate year and month dimensions in TM1, that rolling 13 month presentations like this don't zero suppress in the manner you would probably like. I can understand this for months and periods, but the problem goes much further. Just think about Scenar...
by Silverik
Thu Sep 10, 2020 1:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form hell
Replies: 29
Views: 16675

Re: Active form hell

Yes I've seen it. In your second example all the data are on the same line (5999 Cost of sales) and you display all the combinations of column... So this will work... In your original issue 3 lines "seems" to be empty (product 1, product 2, product 3) but you don't display half of the colu...
by Silverik
Thu Sep 10, 2020 1:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form hell
Replies: 29
Views: 16675

Re: Active form hell

Isn't just that your Active Form is defined to display the data for: - 2 Years (2019 and 2020) - 12 Months (03, 04,05, 06, 07, 08, 09, 10, 11, 12, 01,03) The Active form will display the data for the 24 combinations even though you don't query them. For this product you probably have data on one of ...