AnsweredAssumed Answered

CDA Mondrian Error and cache

Question asked by Michele Cilfone on Sep 17, 2018
Latest reply on Sep 17, 2018 by Michele Cilfone

Hi all,

I've two problems in setting up a CDA connection to build report and dashboards.

I suspect that both are related to some cache behaviours.

 

The first problem is that I'm finding a Mondrian Error while executing a MDX query.

My MDX query is as follows:

WITH

SET [~ROWS] AS

    {[POD_PDR.supplier].[POD_PDR].Members}

SELECT

NON EMPTY {[Measures].[energy]} ON COLUMNS,

NON EMPTY [~ROWS] ON ROWS

FROM [energy_consumption_1_2]

and it works well from schema workbench. The problem is that, in the schema workbench, I changed the schema name from energy_consumption to energy_consumption_1_2, and it seems that Mondrian doesn't recognize this change.

 

The second problem is that, in schema workbench, I assigned a wrong foreign key to a dimension, so I found a wrong MDX query.

I fixed the error in the schema workbench, but I wasn't able to put this modification in Mondrian.

This is the reason why I made a new schema, that leaded me to the problem #1

 

Any help will be appreciated.

Thanks

 

Michele Cilfone

Outcomes