Hi,

i am getting following error while running MDX query.

Error - The property request is invalid in the current context - in the
"PROPERTIES" function

MDX Query is -

with member [Measures].[NewM] as
'case when [Channel].CurrentMember.properties("DesignationCode")="AG"
then 1
else 0
end'
SELECT
{ [Measures].[Channel_Profit], [Measures].[NewM] } ON COLUMNS
,
drilldownlevel({[Channel].[All Channel], [Channel].[All
Channel].Children }) ON ROWS
FROM
[ProfitabilityCubeNew]

can anybody know the solution for the above problem.

Thanks & Regards,
Pravin Viroje

pravin wrote:

hi

can anybody reply for the same, i am facing the same problem from last
2 days. Please if any one have idea about the above problem.


Thanks & Regards,