Accessing Deepsee plugin in MDX
Dear All,
From my web page, i am passing filter values to mdx query.
when mdx executes, i am getting Error #5001: Invalid member expression: empty name(2).
when i try the same in samples namespace (patient cube). I got the same error.
Below is my sample MDX from patients cube.
SELECT
NON EMPTY %KPI("PluginDemo","HighScoreCount",,"%CONTEXT")
ON 1
FROM [PATIENTS]
%FILTER %OR([HOMED].[H1].[ZIP].&[32000])
Result: 0 This works fine.
SELECT
NON EMPTY %KPI("PluginDemo","HighScoreCount",,"%CONTEXT")
ON 1
FROM [PATIENTS]
%FILTER %OR([HOMED].[H1].[ZIP].&[32006])
Result: 13 This works fine.
Now, when i try to access both 32000 and 32006. I got error.
SELECT
NON EMPTY %KPI("PluginDemo","HighScoreCount",,"%CONTEXT")
ON 1
FROM [PATIENTS]
%FILTER %OR({[HOMED].[H1].[ZIP].&[32000],[HOMED].[H1].[ZIP].&[32006]})
What should I do to get HighScoreCount as 13 while accessing both 32000 and 32006 zipcode?
Below is the screen shot from samples namespace(patient cube)
Any Idea on this?