Skip to Content
avatar image
Former Member

LISTCUBE problem

Hi Gurus,

After switching the system the user is unable to execute LISTCUBE, system trace shows that user is missing 0BI_ALL?

Please help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Mar 14, 2008 at 10:38 PM

    I think the new authorization concept requires S_RS_AUTH with authorization 0BI_ALL to overcome this.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 15, 2008 at 10:59 AM

    Hi Asghar,

    use the Transaction RSU01 give the user name>>>click on changed in the Name(Tech) give 0BI_ALL

    click on insert and save

    hope this helps

    thanks

    kishore

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 15, 2008 at 06:55 PM

    Hi Gurus,

    Actually that is the problem users had 0BI_ALL and we want to take it away from the users, plus as far as I understand listcube should not have problem from not having 0BI_ALL. Listcube is a standard transaction and 0BI_ALL is just about analysis authorizations and is not used for anything other than query execution. So looking at this listcube should not be failing for 0BI_ALL as user has other analysis authorizatiosn assigned.

    your help will be greatly appreciated <removed_by_moderator>

    Edited by: Julius Bussche on Mar 19, 2008 7:05 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hi

      the name of the infoproviders is given in the infoobject which is shown in the window below the created authorization using resecadmin transaction, by default you can find the value to be *.

      regards

      vishal

  • avatar image
    Former Member
    Mar 19, 2008 at 06:34 PM

    Hi Gurus,

    Thanks for your suggestions , I understand that 0BI_ALL msg in SU53 and trace doesn't mean much and then I have tried giving the cube name in 0TCAIPROV but it doesn't work. The log still shows that user is missing restricted key figs although 0TCAIPROV = * and 0TCAKYFNM = restricted key fig is already in the user profile.

    Please advice , <removed_by_moderator>

    Edited by: Julius Bussche on Mar 19, 2008 7:06 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      First you should check about the three special characteristics:

      0TCAACTVT -


      03

      0TCAIPROV --- *

      0TCAVALID --- *

      Now you can try to take authorization trace st01 and can see what is not ok while you run the query.

      May be you can request for one test user on the system and then can try to run the query and trace and then kindly analyze

      what is not ok in your case .

      You can look in system log also for some activity which you did ( just another try to see if it also gives something to you which might be helpful to guess what authorizations are missing).

      Imp. Please see if the created authorization is assigned to the role (having object S_RS_AUTH) and that role is assigned to the user ( who is running the query).

      regards

      Vishal