Planning Analytics

 View Only

 MDX View Converted to Universal Report

  • IBMChampion
Ryan Clapp's profile image
Ryan Clapp posted Mon April 07, 2025 03:56 PM

When a user converts an MDX View to a universal report the axis definition is converted from an MDX set expression, to a named subset. Why does this happen? Is there a way to force universal reports to take the MDX as written? The conversion obsfucates the query and its relationship to the view. 

Ardian Alikaj's profile image
Ardian Alikaj IBM Champion

I have noticed that too, it actually creates a pseudo named subset (you cannot see those subsets in the backend), and then it uses TM1SubetToSet to convert it back to an MDX expression. 

But I have tried to create Universal Reports from scratch (its not the easiest process and we are still learning:) but the good news is that you dont have to populate all the cells in the hidden area, so the issue is more with the conversion tool of PAfE