Pentaho

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