Analytic Privilege - no member data

[Former Member]

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

[SergioG_TX]

Taylor,

yes you need to have the stored procedure to read the valid conditions for your AP.

would this blog help?

[Former Member]

Hi Sergio,

Thanks for the reply. I did like your blog.

I am not sure I understand what you mean by "read the valid conditions for your AP."

Can you explain?

My thoughts are if I can log onto AOLAP as this user and view the data is coming through correctly restricted for the 1st and 2nd CV, then my AP and SP are working correctly.

I do not know why I can't view the data for the Final 3rd view?