WITH MEMBER [Promotion].[Campaign].[Program].[All Others] AS
[Promotion].[Campaign].[Program].&[Acquisition]+[Promotion].[Campaign].[Program].&[Publications]
SELECT
[Measures].[Revenue] ON 0,
[Promotion].[Campaign].[Program].ALLMEMBERS ON 1
FROM
MyCube
In the MDX above "Promotion" is the dimension. "Campaign" is a user hierarchy. "Program" is a level/attribute.
I keep getting:
Query (2, 2) The member '[Program]' was not found in the cube when the string, [Promotion].[Campaign].[Program].[All Others], was parsed.
What am I doing wrong here?
View Complete Post