Good morning. We have the tool conected to MS Analysis services. We are having an issue where data is not showing correctly. We reviewed the query that is sent from the front end (angular)
Select NON EMPTY {[Measures].[Cantidad Total Bultos]} DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON COLUMNS , NON EMPTY ROWS_TOKEN_START_Crossjoin({[GE-Empresas].[Desc Empresa].&[ALEJANDRO NEGRO]}, {[GE-Personal Comercial].[Desc Vendedor].&[ANALIA CASTANARES]}, {[CL-Canales].[Desc Canal].&[Autoservicios]}, {Hierarchize({DrilldownLevel({[CL-Clientes].[Cod Cliente].[All]})})}, {[CL-Clientes].[Desc Cliente].[All]})_ROWS_TOKEN_END DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON ROWS FROM [Cubo_Comercial_Cia] CELL PROPERTIES VALUE
The tokens seem to be replaced in the backend (we use Accelerator)
For something like this
Select NON EMPTY {[Measures].[Cantidad Total Bultos]} DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME,
MEMBER_TYPE ON COLUMNS , NON EMPTY Subset(Crossjoin({[GE-Empresas].[Desc Empresa].&[ALEJANDRO NEGRO]},
{[GE-Personal Comercial].[Desc Vendedor].&[ANALIA CASTANARES]}, {[CL-Canales].[Desc Canal].&[Autoservicios]},
{Hierarchize({DrilldownLevel({[CL-Clientes].[Cod Cliente].[All]})})}, {[CL-Clientes].[Desc Cliente].[All]}), 0, 500)
DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON ROWS FROM [Cubo_Comercial_Cia] CELL
PROPERTIES VALUE
This is showing incorrect data in the frontend- if we replace the "500" for "5000" in MSASS the query returns correct data.
Is this harcoded? Can it be modified? is our diagnostic correct?
Thanks!!!