Re: Problem securing measures in SSAS 2005

Hello Wim.

hmm... I'm not sure that you mentioned about cell data security. Where did you apply your MDX script at? I couldn't understand Deutsch so that not suggetion any useful things.

If you want to display dimenstion's name and not about cell data simultaneously, cell data security option will be good choice. cell data tab is in Role Designer.

+---------------------------------

Kenial.GhostOnNetwork.



wim wrote:
Hello,

I'm working with a SSAS 2005 OLAP Cube (1 fact table, 4 measures and about 9 dimensions) and want to set up dimension data based security.
Securing several items of a dimension works fine but when I want to secure a special measure I'm not able to view the cube with this role any more. The only thing I get is an error message like this: "MdxScript([Cubename]) (10, 24) Die [Measurename]-Dimension wurde beim Analysieren der Zeichenfolge '[Measurename]' nicht im Cube gefunden" where Measurename is the name of the measure that was secured.

Also, after setting up measure security for the first time I'm not able to remove or change these settings again until I delete the complete role and recreate it.

Can anybody help me or is there a known work around?

Wim
.