Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mrrana78
Starting Member
2 Posts |
 Posted - 2010-01-04 : 20:44:52
|
| Hi People,Data in our cube have two legal owner. Each own partial Data. The only Dimension\attribute that identifies the legal owner is Loan.LegalOwnerCode. I created two roles and than included relavant ADgroups as membership. Legal owners should have access to all cubes therefore enabled READ access in Cube Tab.In Cell data for each cube I have following code in Read-Permissions NOT Ancestor([Loan].[By Loan Legal Owner Code].CurrentMember,[Loan].[By Loan Legal Owner Code].[Loan Legal Owner Code]) IS ABC ( ABC legal owner code) have same code for other role using different code.Legal owners should have access to all Dimemsions therefore enabled READ access in Dimension Tab.In Dimension Data tab I simply have attribute scurity defined for Loan Dimension for Loan Legal Owner attribute as {[Loan].[Loan Legal Owner Code].&[ABC]}Issue I am facing is when I browse a cube, if any dimension other than Loan is used measure value is sum of both legal owners even though role for ABC is being used.and also if I use Loan dimension in my browsing I get measure sum until I use the granduler attribute ( Loan Number ) which than shows right value. How can I get the measure values to display sum of relavent data only. any advise , any thought , fire it throughrana |
|
|
|
|
|
Tricky Roles