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

Problem with incorrect data from Analysis Services

Answered
Jesica asked 4 days 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!!!

1 answer

Public
Maksym Diachenko Maksym Diachenko Flexmonster 3 days ago

Hello, Jesica!

Thank you for the details.
Our team has provided the answer via email. Please check your inbox.

Kind Regards,
Maksym

Please login or Register to Submit Answer