mondrian - Snowflake schema with multiple levels -

one of dimension in schema modeled snowflake schema following table structure:

fact table -> criteria_value -> criteria -> domain 

mondrian schema:

<dimension type="standarddimension" foreignkey="id_value" highcardinality="false" name="researched value">   <hierarchy name="researched value" hasall="true" primarykey="id_va" primarykeytable="criteria_value">     <join leftalias="criteria_value" leftkey="id_va" rightalias="criteria" rightkey="id_c">       <table name="criteria_value">       </table>       <join leftalias="criteria" leftkey="id_c" rightalias="domain" rightkey="id_domain">         <table name="criteria" alias="">         </table>         <table name="domain" alias="">         </table>       </join>     </join>     <level name="domain" table="domain" column="desc_d_eng" type="string" uniquemembers="true" leveltype="regular" hidememberif="never">     </level>     <level name="criteria" table="criteria" column="desc_c_eng" uniquemembers="false">     </level>     <level name="value" table="criteria_value" column="desc_va_eng" uniquemembers="false">     </level>   </hierarchy> </dimension> 

the problem when trying mdx query in mondrian workbench :

{[researched value].[mobile services].operator} on rows 

i can see values corresponding ("mobile services" , "operator" first members of levels "domain" , " criteria" respectively

but when trying example:

{[researched value].[mobile services].internet} on rows 

i got:

mondrian error:mdx object '[researched value].[mobile services].[internet]' not found in cube 'recherche'

while "internet" member in "criteria" level (but it's not first one)

why can't see members of levels?

i think you're missing level's name in mdx identifier. correct syntax be:

[hierarchy name].[level name].[member name] (.[child member name]) 

try instead:

{[researched value].[criteria].[internet]}