Microsoft KB Archive/930654
Article ID: 930654
Article Last Modified on 2/22/2007
- ProClarity Desktop Professional 6.1
- ProClarity Desktop Professional 6.2
- ProClarity Web Professional 6.1
- ProClarity Web Professional 6.2
When you use a custom member in a query in ProClarity Desktop Professional or in ProClarity Web Professional, the WITH MEMBER clause is lost in the query after you change the current dimension to a different dimension. This problem occurs when you create the custom member by using the WITH MEMBER clause.
This issue occurs because you can only use the WITH MEMBER clause to create a custom member for a current query. After you locate a different dimension, the WITH MEMBER clause is lost in the Multidimensional Expressions (MDX) query.
To work around this issue, create a calculated member by using the WITH MEMBER clause, and then use the newly created calculated member in a query.
Keywords: kbtshoot kbprb KB930654