Query in a role via MENU

[Former Member]

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

[Former Member]

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

[Bernhard_SAP]

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

[Former Member]

Dear Bernhard,

Thanks for your prompt reply.

I have selected in other objects --> SAP BW Query URL..

then I get options:

Text

Object description

Continuation

what does it mean.

As I said in my previous post.I have checked few roles for the same and found below 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

how to get this URL.

Another Question is:

I am trying publish query in a role via query designer.

but I am not seeing any roles to publish. is there any setting for this. Please advise.

Thanks,

Raj

[Former Member]

>

> Another Question is:

> I am trying publish query in a role via query designer.

> but I am not seeing any roles to publish. is there any setting for this. Please advise.

>

Hi Raj,

Just check settings of your table SSM_CUST.

It should have following entries:

CONDENSE_MENU=YES

DELETE_DOUBLE_TCODES=NO

If the above is not present, please maintain & test it

You may refer the link below:

[mvoros]

Hi,

the field Text is what will be displayed in menu. Other two are for URL. There is a technical limit that maximal length for input field in dynpro is 132 characters. So they split 255 chars into two junks. So if your URL fits into first field than leave the second one blank. Otherwise use it for part which does not fit into first input element. I guess you can test your query from some transaction in SAP. This will give you a proper URL.

Cheers

[Former Member]

Hi Raj,

You already are on the right track. The query name appears as a parameter in both the URL formats that you specified. The <bsp_protcl>://<bsp_server>/sap/bw/BEx? is by believe for BW 3.5 queries while the other is for BI 7.0 queries.

However, adding these to your role will make the queries appear as web links in user menu. Not sure if you are really trying for that as your next question is about query designer.

To add queries/workbooks to roles through BEX or query designer, the role which you are trying to access should have at least one transsaction assigned to it. It doesn't matter what is the one transaction (normally I just use RRMX) as long as its already added to the role.

Also when using query designer/bex to add queries, your user should have change access to the role through S_USER_AGR.

[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??