i am new to MDX and olap4j. I face a problem for which I haven't found any help in the net yet. I use olap4hj version 1.1.0.
I have a cube with following dimension, hierarchies, levels and members
I try to execute an MDX query with following WHERE clause
Here the hierarchy is omitted. Full version could be:
The original query works in SQL Studio / SSAS directly. It uses the first hierarchy it can find in the dimension. Olap4j raises an error because it seems to be unable to resolve the default hierarchy. When building the metadata for the response, it fails because it compares the hierarchy information of the current response with the previously fetched hierarchy information:
org.olap4j.OlapException: Internal error: hierarchy '[time].[Day Name]' not found in cube 'xyz_cube'
Is there a way to get this query running as it is? I am unfortunately not in the position to change the query.
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.