Order set in prolog tab in a view created with MDX is no the order running in datatab
Posted: Wed Nov 30, 2022 9:33 pm
Hi everybody,
I created a view in the prolog tab using a MDX to filter and order a dimension from the source cube
and when I test the MDX in subset editor the elements are shown in the expected order even in the view created by the TI Process elements appears in the expected order but when process go to data tab elements are processed in ASC order...and not as the MDX.
1) the order that subset editor return and the order: (26,28,29,27,25...)
2) the order that view created by TI return: (26,28,29,27,25...)
3) the order processed in datatab: (23,24,25,26)
Thank you veru much for any help!
I created a view in the prolog tab using a MDX to filter and order a dimension from the source cube
and when I test the MDX in subset editor the elements are shown in the expected order even in the view created by the TI Process elements appears in the expected order but when process go to data tab elements are processed in ASC order...and not as the MDX.
In pictures attached you can seesMDXGrua= '{ORDER( {Filter( { TM1FilterByLevel ( { TM1DrillDownMember ( { [Grua].[Gruas Muelle] },ALL,Recursive) } ,0 ) }
, [R.Operacion.Grua].([R_Version].[ ' | pVersion | ' ], [Periodo.E].[ ' | pPeriodo | ' ], [GPC.Empresa].[ ' | pEmpresa | ' ] ,[Acuerdo].[ ' | pAcuerdo | ' ] , [Grua].CurrentMember, [UVI].[ Total UVIs ],[Medida.Grua].[% Utilizacion Equipo] ) >0 )}
, [R.Operacion.Grua].([R_Version].[ ' | pVersion | ' ], [Periodo.E].[ ' | pPeriodo | ' ], [GPC.Empresa].[ ' | pEmpresa | ' ] ,[Acuerdo].[ ' | pAcuerdo | ' ] , [Grua].CurrentMember, [UVI].[ Total UVIs ],[Medida.Grua].[% Utilizacion Equipo] ),BDESC )}' ;
1) the order that subset editor return and the order: (26,28,29,27,25...)
2) the order that view created by TI return: (26,28,29,27,25...)
3) the order processed in datatab: (23,24,25,26)
Thank you veru much for any help!