Pentaho

 View Only

MDX query with different behavior according to the user used to execute it

This thread has been viewed 3 times
  • 1.  MDX query with different behavior according to the user used to execute it

    Posted 25 days ago

    Hi all,

    I have a problem with the following MDX query because it has a different behavior according to the user used to execute it.


    WITH
    SET [~ROWS] AS except({[Carrera].Members},{[Carrera].[NE - No Especificado]})
    SELECT
    NON EMPTY {[Measures].[EstudiantesMatriculados]} ON COLUMNS,
    NON EMPTY [~ROWS] ON ROWS
    FROM [Matricula]
    WHERE [TiempoModalidad.Anio].[2014]:[TiempoModalidad.Anio].[2024]

    Output using admin user:

    Output using another user:

    The additional user (with the error) has full access to the cube used in the query.

    After some tests, I modified the query, and the output was the same for both users (the expected). The new query version is:

    SELECT
    NON EMPTY {[Measures].[EstudiantesMatriculados]} ON COLUMNS,
    NON EMPTY except({[Carrera].Members},{[Carrera].[NE - No Especificado]}) ON ROWS
    FROM [Matricula]
    WHERE [TiempoModalidad.Anio].[2014]:[TiempoModalidad.Anio].[2024]

    The Question is: Why the first query is working fine with admin user, but not with another users?

    Thanks in advance for help.



    ------------------------------

    Jason Serrano

    ITCR
    ------------------------------