Analysis Services Calculations

Is it possible to group/ arrange Analysis Services Calculations in cubes into separate Folders? In other words similart to measures which can be grouped in to folders I would want to know if we can group these calculated meassures into folders.

Thanks

In the calculations tab you can see a very small properties button, called calculation properties, that you can click on.

This is in BI-Dev Studio.

HTH

Thomas Ivarsson

|||

Great, thanks..

Now how can I control the security of these calculated members. meaning, I do not want the calculated field to be available to a pariculat role?

I can control it at the Measure level that makes this calculated field. in other words I do not want one of the calculated field not visible to a particular Role Member..

|||

Now how can I control the security of these calculated members. meaning, I do not want the calculated field to be available to a pariculat role?

This is not possible in AS2005.

|||

Thanks Mosha, Is there any other work around with which I can make the caluclated fields available/ visible only to a set of users.

I have a calculated field of $'s which I do not want to be visible to all the memebers. It should be visible only to Managers who are members of Managers Role.

|||You should define it as a real member of the dimension then. Since the fact table won't have keys related to that member - after processing it will be empty - so you are not paying anything in the space. Then inside MDX Script you can overwrite it with any MDX expression you want, just like you do with the calculated members. But now since it is a real member, you can secure it in a role.|||

Another option is to add Cell Data security to the measure. The following article shows details of how to add security to only allow users to use a specific measure.

http://msdn2.microsoft.com/en-us/library/aa933600(SQL.80).aspx

This works for calculated members as well.

In the Cell Data tab of the Role editor, tick 'Enable read permissions', and add a statement referring to the measures the user IS allowed to use. This will then disallow access to any other measures.

e.g.

If we have 3 measures:

MemberCount
SalesCount
MemberPay

And want to diallow access to the MemberPay measure for a specific role, we could use the following statement in the Cell Data page:

Measures.CurrentMember.Name = "MemberCount" or Measures.CurrentMember.Name = "SalesCount"