Search code examples
mdxmondrian

MDX Calculated Members not recognised

I am using Mondrian.

When I use following query :

with MEMBER [Added_On].[2011].[4].[tot] AS
 '[Added_On].[2011].[4].[4]+[Added_On].[2011].[4].[5]'
  select
 {[Added_On].[2011].[4].[tot] } on columns, 
{([Measures].[Count])} on rows from Transactions

I get error which says :

Mondrian Error:MDX object '[Added_On].[2011].[4].[tot]' not found in cube 'Transactions'

Could someone please point out errors?

Added_On is a time dimension. I used schema workbench to make a schema for this. Rest has been working fine till now.

Solution

  • You should try to add the name of the level of the member 2011 in the expression of your calculated member:

    [Added_On].[name of the level of 2011].[2011].[4].[tot]