Re: Problem securing measures in SSAS 2005

Hello Kenial,

Thank you for your reply.

I found the reason of my first problem on my own.
If you start securing measure items you should be cautious in using these
measure items in the NonEmptyBehaviour property of calculated members. Doing
so results in the mentioned error message if a user who isn't allowed to see
the measure item queries the cube. In this case Analysis Server isn't able to
resolve the NonEmptyBehaviour property of the calculated member and throws
the exception.

But still I have the problem after setting up security of specific measure
items for the first time. Any subsequent changes to these specific measure
items won't be adopted by Analysis Services. After reopening the dimension
data security pane there are still the old settings.

"Kenial" wrote:

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

.

Relevant Pages

  • Re: Problem securing measures in SSAS 2005
    ... May the security be with you:) ... Doing so results in the mentioned error message if a user who isn't allowed to see the measure item queries the cube. ... After reopening the dimension data security pane there are still the old settings. ... If you want to display dimenstion's name and not about cell data simultaneously, cell data security option will be good choice. ...
    (microsoft.public.sqlserver.olap)
  • Re: Problem securing measures in SSAS 2005
    ... I'm well experienced in setting up security in AS 2005. ... the measure item queries the cube. ... I'm not sure that you mentioned about cell data security. ... dimensions) and want to set up dimension data based security. ...
    (microsoft.public.sqlserver.olap)
  • Re: Help Needed with Dynamic Dimension Security
    ... business application for securing members. ... and the point in the hierarchy where the security ... > of using Dimension Security with a Virtual Cube. ...
    (microsoft.public.sqlserver.olap)
  • Dimension Data Security issue - help needed
    ... I'm having a problem with our enterprise data warehouse that I hope someone can assist me with. ... In the Dimension Data tab, if you expand the list and view the cube dimensions, some select dimensions have attribute security defined. ... We have applied the following MDX expression to that dimension to filter the data to the keys of that dimension that meet the MDX filter: ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Dimension Security advice needed
    ... > All my cubes use the shared dimension Location which has the levels ... > I need to set up security in my cubes to allow a user to view only ... > am at a total loss of how to go about it. ... it looks like dynamic dimension security using the ...
    (microsoft.public.sqlserver.olap)