Skip to Content
avatar image
Former Member

Query in a role via MENU

Dear Gurus,

I want to include SAP BW Query in a SAP BI 7.0 role. How to add it via MENU.

I have checked in couple of roles I found below URLs. How to get those URLs.

<bsp_protcl>://<bsp_server>/sap/bw/BEx?sap-language=<language>&bsplanguage=EN&cmd=ldoc&INFOCUBE=P03_MC110&QUERY=P03_BCS_VAL_850076_Q

<prt_protcl>://<prt_server>/<bi_launcher>?QUERY=NAP_NTMMKTDR_MKTDR_M_001&TEMPLATE=NVIMM_WEBTEMPLATE_V01

Please help.

Thanks,

Raj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 07, 2010 at 09:22 AM

    Hello Raj,

    in pfcg on the menu tab: choose the button 'Add other object'. In the next popup decide what you want to add (for instance BSP-app.). Then use the drop down to select the appropriate application/URL, etc.

    b.rgds,

    Bernhard

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Two Ways

      1. Add URL by Go to Role(pfcg) - > Change mode -> Click on "Other" in Menu Tab - > Select SAP BW Query URL - > Enter URL and description -> Save

      2. To add a query -> run RRMX or BEx Analyzer -> Open dialog to Select Query -> Search Query -> Select Query -> You will have a button in the dialog box "Enter in Role". Click -> another dialog appears with Roles. -> Select Desired role

      For point2 prerequisite is that you should have access to edit role via object S_USR_AGR in any role and The role where you want to assign query should be assigned to you in Su01.

      Does it help??

  • avatar image
    Former Member
    Sep 07, 2010 at 08:40 AM

    Hi Raj,

    In the BI 7 role: goto PFCG & in change mode. Goto Menu tab & in that you will see Copy Menus - From other role.

    There you need to select the role of which menus have to be copied into BI 7 role

    Add comment
    10|10000 characters needed characters exceeded