☝️Small business or a startup? See if you qualify for our special offer.
+

Problem with incorrect data from Analysis Services

Open
Jesica asked 20 hours ago

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!!!

Please login or Register to Submit Answer