Subview zero suppresion issue after upgrade to PA

One of our UK clients, Chubb, is testing an upgrade from 10.2.2 to planning analytics on a tm1 model that uses apliqo. They have found a problem where consolidated elements are being suppressed in a subview, however this issue is not present when viewing the same set of data in the architect cube viewer (ie not under feeding).

The view setup is 2 subviews side by side, using cubes 'FIN expense planning drivers' and 'FIN expense planning' (see picture 1 attached). 'FIN expense planning drivers' is the left side and 'FIN expense planning' is on the right, the sparklines column is the first column of the 'FIN expense planning' subview.

If you compare picture 1 to picture 2 (same view but from the 10.2.2 model) you'll see that the PA model is missing elements in the 'FIN expense planning' subview, the missing elements are consolidated elements.

Picture 3 is a the same set of data in the PA model in cube viewer with zero suppression turned on and the consols still showing data.

Picture 4 shows the account dimension setup of the 'FIN expense planning drivers' subview, I have tested the MDX in the PA model and it is correct, this MDX is also the same as the account dimension setup of the 'FIN expense planning' subview.

No changes have been made to the apliqo view definitions, the only change was upgrading to PA.

They are on PA 2.0.6, not sure which Apliqo version but I do know that it is a very early build, I believe Tomer was involved in the project.

Have put the priorty as high because this issue stops Chubb from proceeding with their upgrade plan.

Sender : Michael Wood

Sender Email : mwood@cubewise.com

Comments (2)