Skip to Content
0
Former Member
May 11, 2016 at 07:23 PM

Analytic Privilege - no member data

19 Views

Hi,

I can't figure out an issue with an Analytical Privilege.

I have three Calculation Views:

  • 1st Performs logic on Actual Transactions
  • 2nd Performs logic on Targets
  • 3rd Unions Actual with Targets

I have created an Analytical Privilege to restrict data by department

(I'm using a Stored Repository Procedure to lookup distinct Departments for a session user and then filter my Department Field)

I have made sure to include all Views (AT,AN,&CV) from my Model within the "Secured Models" section.

Is there any specific logic I need to follow when adding "Associated Attributes"? For example I have included one attribute from each View

The Analytic Privilege is working correctly on my 1st and 2nd Calculation Views, but I cannot figure out why the 3rd doesn't and displays "no member data" in AOLAP. I believe I am missing a field or something in the "Associated Attribute Restrictions" section.

Thank you for any advice or documentation