Skip to Content
avatar image
Former Member

Member Access Profile in BPC

Hi,

I have some doubts w.r.t Member access profile in BPC. We have Entity and Category as secured dimension. Entity is read only (All members). Category is R/W (All members).

1) If i add a third row, and deny only one base member of Entity, whether it will work fine? Which definition system will accept? Read or deny?

2) In the above scenario, if i run the report on summary node of hierarchy (which has a denied base member), whether i will be able to read the values at summary node level.

3) When i say Entity members are read only .. cant i do input using input schedules for those entities?

4) How we need to copy these BPC authorizations to BI in BPC 7.0 (NW). Do we need to recreate these authorization concept in BI or the authorizations i define in BPC 7.0 (NW) are valid for BI also. In this case, if i run a report on BPC cubes using query designer in BI, how authorizations are checked?

Please suggest.

Thanks/regards,

Lokesh Nandula

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 04, 2008 at 07:02 AM

    Hi Lokesh

    I will try to answer your questions:

    1+2) If you give read/write access to a "Parentmember" all these settings are applied to all childs of this member. So if you give Read Access to a Parent the User will be able to see everything under this Member.

    3) If you have Read Only on a Member, you cant send Data to the Database via Inputschedule.

    If you have Read Only on the whole Entity Dimension you cant do any posting in the whole cube, regardless of the settings in Category Dimension (but I think this is clear in Multidimensional Systems)

    4) Unfortunatly in Germany the RampUmp Version of BPC7NW is still not shipped, so I cant answer on this point

    Regards

    Jörg

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Go to SECURITY - MEMBER ACCESS PROFILE and give read/write access to the new application (it will appear as a separate TAB). Then click on your application set name on the left side in your BPC admin screen. On the right hand pane, set the availability status as AVAILABLE. Use CONNECTION WIZARD to login. You issue will be resolved.

      regards,

      Lokesh Nandula

  • avatar image
    Former Member
    Aug 30, 2011 at 04:40 PM

    Hello experts,

    Is there a way to full upload the member access profiles to BPC if you already have them in a Excel sheet for example??.

    Best regards.

    Add comment
    10|10000 characters needed characters exceeded