Skip to Content
author's profile photo Former Member
Former Member

Restricting BW Data through security profiles

We have a requirement to restrict Cost Center access...

We use a Cost Center hierarchy and have created 2 ODS objects that create a Profile against a User ID to limit Cost Center results to a hierarchy NODE.

ie. LEVEL 3

LEVEL 1

LEVEL 2

LEVEL 3

LEVEL 4

When a query runs it restricts data to LEVEL 3. However when we try and use a USER ENTRY variable to select a single cost center (123) within the hiearchy (below LEVEL 4) the reports do not filter properly, and everything is still shown, except for 123!!

Any help is appreciated....

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 02, 2004 at 04:26 PM

    Note 502574 describes how you can generate authorization profiles in BW according to the settings in the R/3 costcenter hierarchy.

    The generated profiles can also be used for a personalization of the queries according to the responsibility area of the user.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 20, 2005 at 07:54 PM

    Did you ever get your security profiles to work?

    We also need need to restrict queries on cost center.

    Want to know if this method would be considered the "best practice" method for such a situation? Or does another method exist that delivers better query performance?

    Trying to understand options when wanting to restrict BW Data by cost center.

    Thanks in advance,

    Cynthia

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 13, 2005 at 08:09 AM

    Hi,

    I am basically into SAP R/3 BASIS, i want to move to BW security, if you have any Doc's related to BW security can you please send me to this Id ; praveenkumar.bv@gmail.com...

    Thanks in Advance,

    Praveen Kumar.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.