Apliqo UX changes MDX query upon updating from 2023.02 to 2023.10 without any warning

After updating UX from 2023.02 to 2023.10 for certain reports which use alternate hierarchies and complex MDX queries, when I open the view definition in edit mode, Apliqo decides to change the MDX query to the default one without any warning, which obviously breaks the report.

This is what I had before:

{"viewDef":{"notDefined":[],"fixes":[],"timeFilters":[],"filters":[],"internalFilters":[],"rows":[],"columns":[{"instance":"TBMS","dimension":"T Year-Month","hierarchy":"Group LTD Months","key":"TBMS.T Year-Month.Group LTD Months","dimensionType":"columns","attribute":"Caption","listType":"MDX","mdx":"{TM1SORT(Generate(FILTER({TM1SubsetToSet( [T Year-Month].[T Year-Month], \"All N Elements\" )}, [TBM Tender Month Usage].([TBM Revision].[$<<TBMS.TBM Revision.TBM Revision>>],[TBM Tender].[$<<TBMS.TBM Tender.TBM Tender>>], [TBM Tender Month Measure].[String]) = 'input'), {StrToMember(\"[T Year-Month].[Group LTD Months].[\" + [T Year-Month].[T Year-Month].CurrentMember.Name + \"_LTD]\")}), ASC)}","selectionType":"Multi","label":"Month","subsetSelection":[],"$$hashKey":"object:9359","undefinedDimKey":"TBMS.T Year-Month.T Year-Month"}]}}

This is what Apliqo did to the MDX:

{"viewDef":{"notDefined":[],"fixes":[],"timeFilters":[],"filters":[],"internalFilters":[],"rows":[{"instance":"TBMS","dimension":"TBM CBS","hierarchy":"TBM CBS","key":"TBMS.TBM CBS.TBM CBS","dimensionType":"rows","listType":"MDX","subset":"All C Elements","attribute":"Code and Description","mdx":"StrToSet(\"{HIERARCHIZE( {TM1DRILLDOWNMEMBER( {[TBM CBS].[\"+[TBM Tender Setup].([TBM Revision].[$<<TBMS.TBM Revision.TBM Revision>>], [TBM Tender].[$<<TBMS.TBM Tender.TBM Tender>>], [TBM Tender Setup Type].[Value], [TBM Tender Setup Measure].[Version CBS]) +\" TBM CBS].[Report3]},ALL, RECURSIVE )} )}\")","label":"CBS Codes","value":"Report3","showHierarchy":"1","suppressZeroDefault":"1","suppressZeroOption":"1"}],"columns":[{"instance":"TBMS","dimension":"T Year-Month","hierarchy":"Group LTD Months","key":"TBMS.T Year-Month.Group LTD Months","dimensionType":"columns","attribute":"Caption","listType":"MDX","mdx":"TM1SubsetAll([T Year-Month].[Group LTD Months])","selectionType":"Multi","label":"Month","subsetSelection":[],"disableHierarchy":"1"}],"upgraded":true}}

{"viewDef":{"notDefined":[],"fixes":[],"timeFilters":[],"filters":[],"internalFilters":[],"rows":[{"instance":"TBMS","dimension":"TBM CBS","hierarchy":"TBM CBS","key":"TBMS.TBM CBS.TBM CBS","dimensionType":"rows","listType":"MDX","subset":"All C Elements","attribute":"Code and Description","mdx":"StrToSet(\"{HIERARCHIZE( {TM1DRILLDOWNMEMBER( {[TBM CBS].[\"+[TBM Tender Setup].([TBM Revision].[$<<TBMS.TBM Revision.TBM Revision>>], [TBM Tender].[$<<TBMS.TBM Tender.TBM Tender>>], [TBM Tender Setup Type].[Value], [TBM Tender Setup Measure].[Version CBS]) +\" TBM CBS].[Report3]},ALL, RECURSIVE )} )}\")","label":"CBS Codes","value":"Report3","showHierarchy":"1","suppressZeroDefault":"1","suppressZeroOption":"1"}],"columns":[{"instance":"TBMS","dimension":"T Year-Month","hierarchy":"Group LTD Months","key":"TBMS.T Year-Month.Group LTD Months","dimensionType":"columns","attribute":"Caption","listType":"MDX","mdx":"TM1SubsetAll([T Year-Month].[Group LTD Months])","selectionType":"Multi","label":"Month","subsetSelection":[],"disableHierarchy":"1"}],"upgraded":true}}

Comments (3)