I have created "Users" cube with two dims only: App_Unit and User.
I want to base security in another cube on cube Users.
The only difference between Unit (used in another cube) and App_Unit (used
in "Users" cube) is App_Unit does not use rollups (no need to use datamember
then). All identifiers and properties are just the same in both dims.

The following MDX returns correct members in MDX Sample Application (as a
part of select query) and works ok as named set.
Unfortunatelly it gives error when pasted into dimension security advanced
mdx field ("Cannot evaluate expression")

filter([Jednostka].Members,(lookupcube("Users","([USER].&["+lCase(username)+"],[Measures].[Value],[App_Unit].&["+[Jednostka].CurrentMember.Properties("OriginalMember")+"])")=1
))

Any ideas?

Kuba

In AS 2000, LookupCube is not allowed in MDX for dimension security.

--
Dean Adam
Magenic Technologies


"Kuba" wrote: