Pentaho

 View Only

Error in mdx query when there are no items to count

This thread has been viewed 2 times
  • 1.  Error in mdx query when there are no items to count

    Posted 10-03-2022 10:00
    Hi
    I have a dashboard that has a table that uses this "mdx over mondrianJndi" query:

    WITH
    SET [~COLUMNS] AS
    {[Classe].[Classe].Members}
    SET [~ROWS] AS
    {[Allievo.Tipo Studente].[Tipo Studente].Members}
    SELECT
    NON EMPTY CrossJoin([~COLUMNS], {[Measures].[Count allievi]}) ON COLUMNS,
    NON EMPTY [~ROWS] ON ROWS
    FROM [Allievi]
    WHERE (
    ${FilterAnnoAccademicoParameter},
    ${FilterDecadenzaParameter}
    )

    When I open the dashboard and I change the parameter "FilterAnnoAccademicoParameter" so that some cells of the table have no data I have this error:

    "DataTables warning: table id=RiassuntoAllieviCellTable - Requested unknown parameter '2' for row 0, column 2. For more information about this error, please see http://datatables.net/tn/4"


    I think the error is raised because the table has the "Classes" for columns and "Tipi" for rows and depending on the parameter the cell value can be 0.
    But in this case an error is raised instead of showing the 0 value.

    How can I solve this problem?

    Thank you very much.

    Claudio

    ------------------------------
    Claudio Battaglino
    IT Support Manager
    cbc
    ------------------------------