Grid not rendered at all when query is too complex

Grid isn’t rendered when query is very complex.

See the example below for the query on the rows:

StrToSet("TM1SubsetToSet( [TBM CBS].["+[TBM Tender Setup].([TBM Revision].[$<<ABB_TBMS.TBM Revision.TBM Revision>>], [TBM Tender].[$<<ABB_TBMS.TBM Tender.TBM Tender>>], [TBM Tender Setup Type].[Value], [TBM Tender Setup Measure].[Version CBS]) +" TBM CBS], 'Full Cost Model')")

‌

mdx: SELECT {StrToSet("TM1SubsetToSet( [TBM CBS].["+[TBM Tender Setup].([TBM Revision].[Current Revision], [TBM Tender].[6], [TBM Tender Setup Type].[Value], [TBM Tender Setup Measure].[Version CBS]) +" TBM CBS], 'Full Cost Model')")} ON ROWS,
{{TM1SubsetToSet( [Currency].[Currency], "}UX Column Reporting" )}} ON COLUMNS
FROM [TBM Report CBS Entity]
WHERE ([TBM Version].[TBM Version].[Current Version],[TBM Tender].[TBM Tender].[6],[TBM Tender Entity Line].[TBM Tender Entity Line].[1],[TBM Input Type].[TBM Input Type].[Cost Profile],[TBM Tender Category 1].[TBM Tender Category 1].[Total Tender Category 1],[TBM ABB Content].[TBM ABB Content].[Total],[T Year-Month].[T Year-Month].[Tender Summary],[Scale].[Scale].[BASE],[TBM Report CBS Measure].[TBM Report CBS Measure].[Draft Value])

‌

Result on UX

Result in Arc

‌

Comments (5)