Filtering dimesion in session cube -
08-09-2005
, 01:50 AM
Hi.
I`d like to create a session cube with filtered exist dimension.(foltered by
member properties)
i want to create somethink like this:
CREATE SESSION CUBE [Student DMM]
FROM [Children]
(
MEASURE [XXX].[Count],
DIMENSION Filter( except ( [YYY].Members, Head([YYY].Members,1) ) ,
[YYY].CurrentMember.Properties ("VersionId") =
"6F6D6515-26BB-4D04-B256-60602179DC7F" or [YYY].CurrentMember.Properties
("VersionId") = "964031CD-2BF5-4912-A31E-AE8EB1609E9F")
)
Can i do it,how to do it in MDX???? |