Zero Suppression in TM1Web
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Zero Suppression in TM1Web
Hello,
because I had a Problem with national language-support in 10.2.1 I upgraded to 10.2.2. My Problem with the national language Support is gone. But now I have an issue with Zero Suppression (or Active form in General). I have an active form with Zero Suppression on one column. This works in Excel exactly how I expected. But in TM1Web the Suppression does not work and the rows are not deleted after I Change the selection. Is there anything new in 10.2.2 wich I have to respect?
Regards
because I had a Problem with national language-support in 10.2.1 I upgraded to 10.2.2. My Problem with the national language Support is gone. But now I have an issue with Zero Suppression (or Active form in General). I have an active form with Zero Suppression on one column. This works in Excel exactly how I expected. But in TM1Web the Suppression does not work and the rows are not deleted after I Change the selection. Is there anything new in 10.2.2 wich I have to respect?
Regards
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Zero Suppression in TM1Web
Did you republish all your active forms after the upgrade?
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Zero Suppression in TM1Web
Yes. It's a fairly new model and I republished the one I just tested. I called no other since the upgrade.
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Zero Suppression in TM1Web
I narrowed it a bit down. If I Change the selection in a SUBNM so that the Zero Suppression results in no rows to Display the Active form is not rebuild. If at least one row is to Display it works.
-
- Posts: 4
- Joined: Tue Jun 08, 2010 7:30 am
- OLAP Product: Cognos TM1
- Version: 9.4 9.5
- Excel Version: 2003 2007
Re: Zero Suppression in TM1Web
Hi,
i have the same problem with TM1 10.2.2 - my active forms got a zerosuppression option. When it is on, then it works fine as long there are some rows to show. However when no rows should be shown (after new selection in Subsets), last elements in rows from previous selection will be shown with zeros. Rebuild or Recalc don't help. In Perspectives it works as i expect it and in 9.5.2 the same active form works as i am used to have it - when no rows can be shown due to zerosuppression, the active form will stay empty. Did you have a chance to clarify it with IBM?
Otherwise we will open a PMR...
i have the same problem with TM1 10.2.2 - my active forms got a zerosuppression option. When it is on, then it works fine as long there are some rows to show. However when no rows should be shown (after new selection in Subsets), last elements in rows from previous selection will be shown with zeros. Rebuild or Recalc don't help. In Perspectives it works as i expect it and in 9.5.2 the same active form works as i am used to have it - when no rows can be shown due to zerosuppression, the active form will stay empty. Did you have a chance to clarify it with IBM?
Otherwise we will open a PMR...
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Zero Suppression in TM1Web
Hi,
no, I had no Chance to clarify this. I needed to finish this very fast and used a very nasty Workaround. I used a line wich is always existent and made it invisible with White characters on White Background.
no, I had no Chance to clarify this. I needed to finish this very fast and used a very nasty Workaround. I used a line wich is always existent and made it invisible with White characters on White Background.
-
- Posts: 4
- Joined: Tue Jun 08, 2010 7:30 am
- OLAP Product: Cognos TM1
- Version: 9.4 9.5
- Excel Version: 2003 2007
Re: Zero Suppression in TM1Web
Ok, then a PMR it is.
The other way would be to write an MDX Statement for rows and try if this works, but i don't have time for that. I let you know, if i hear something.
The other way would be to write an MDX Statement for rows and try if this works, but i don't have time for that. I let you know, if i hear something.
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Zero Suppression in TM1Web
Thx, I appreciate!
-
- Posts: 7
- Joined: Wed Jun 29, 2011 8:40 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Zero Suppression in TM1Web
Tatiana, did you get any action on your PMR? We are experiencing this same issue in 10.2.2.
-
- MVP
- Posts: 264
- Joined: Mon Nov 03, 2014 8:23 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2 PA2
- Excel Version: 2016
Re: Zero Suppression in TM1Web
I can't answer about the PMR, but I believe the issue is fixed in 10.2.2 FP1.gstager wrote:Tatiana, did you get any action on your PMR? We are experiencing this same issue in 10.2.2.
-
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: Zero Suppression in TM1Web
We logged this issue for 10.2.2 and I can confirm at least for us this is fixed with FP1
-
- Posts: 7
- Joined: Wed Jun 29, 2011 8:40 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Zero Suppression in TM1Web
Appreciate the feedback, thx.