Skip to Content
avatar image
Former Member

Analytical Privileges and Available Views in SAP Lumira

Hi

I have created an analytic privilege for a calculation view. The calculation view is based on a BW multiprovider. When I set up the analytical privilege I had to also include the 2 analytical views of the infocubes in the multiprovider that were created automatically when I imported the BW infomodel. So I have a calculation view and 2 analytical views as the reference models for my analytical privilege. When I try to acquire a dataset in Lumira, only the calculation view and both analytical views are available as I would expect. However, when I set up an associated attribute to restrict in the views further e.g. region, in both the analytical views and the calculation view, the only view available in Lumira is the analytical view the calculation view is no longer available. Does anyone have any idea why?

Thanks

Gen 

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 29, 2015 at 09:38 AM

    Hi Gen,

    have you tried to include in the Analytic Privilege also an attribute from the Calculation View without any restriction on it?

    AFAIK with Analytic Privileges if you specify one or more attribute restrictions then you have to include at least one attribute per model (with or without restrictions).

    Alessandro

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Alessandro

      Thanks for your reply. I've tried that as well and the calculation view is not available in Lumira. I think it is related to the automatically generated analytical views when the info model from BW was imported as the roles and privileges in the user profile appear to be OK. I have tried many different ways of creating the analytical view without success.

      Thanks

      Gen

  • Sep 29, 2015 at 12:35 PM

    hello Gen,

    This could be due to a missing dependency in the Analytic Privilege (maybe a view missing there) or a sql privilege from your user. Difficult to point out from your text only.

    Have you tried going through the trouble shooting process already? Usually that will show you what the user can access and from there you can add/remove privileges or change your analytic privilege accordingly.

    Additionally, all the views available to be accessed by a user can be queried on view ACCESSIBLE_VIEWS. So if you're wondering what views your user can 'see' just run "select * from accessible_views where user_name = '<your user name>' ".

    Another possibility (probably the best one by now) is to use the Authorization Dependency Viewer (available as of SP09). There's a neat article explaining how to use it: Authorization Dependency Viewer

    If you still can't see what's wrong, then increasing authorization trace is also an option. The steps to perform those are in SAP Note 1809199 - SAP HANA DB: Debugging user authorization errors.

    I hope that helps you get this to work.

    BRs,

    Lucas de Oliveira

    Add comment
    10|10000 characters needed characters exceeded