Fiori Query Browser showing no queries

[former_member195748]

Hello All,

I have activated the query browser app in Fiori on S4 hana, but I cannot see any queries. Its shpws 0 views.

I have already checked from HANA studio that the Analytical CDS views are present.

I can see the query browser app on launchpad, activated the viewbrowser1 in SICF and also assigned myself the employee role.

What else am i missing.

Regards ,

Vivek

[Former Member]

You need to assign the following back-end authorization objects to the Role.

S_RS_COMP

S_RS_COMP1

Try wildcards just for testing.

Cheers.

[former_member193585]

Hi,

I can see Queries in my 'Query Browser' fiori app if I assign wildcard(*) S_RS_COMP & S_RS_COMP1.

But we can not use wildcard in production, so how can we get actual values of RSINFOAREA and RSINFOCUBE.

Thanks.

[Jocelyn_Dart]

Hi Vivek

Every Fiori app requires:

1. Activation of ICF node(s) - the entry point to the app

2. Activation of OData Services - which communicate data and actions from/to the backend

3. Authorizations

From your explanation you have done 1 and 3 but may have missed step 2.

You can find the OData Services needed in the Configuration section of the Query Browser App Details in the Fiori Apps Library

https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('F1068')/S9OP

I can see the OData service VDM_CDSVIEW_BROWSER needs to be activated.

It is best to do this following the mass activation process described in the SAP Best Practices guide for Fiori Apps Deployment (MAD) .

This uses transaction STC01 and worklist type SAP_GATEWAY_ACTIVATE_ODATA_SERV

This then gives you a log of what you have activated.

For the Query Browser you also need to activate the ICF nodes for the Design Studio as explained in the SAP Best Practices Guide for Embedded Analytics. You can also activate these using txn STC01 and worklist

• /sap/bw/ina
• /sap/bw/Mime

And also OData Service RSAO_ODATA_SRV

You'll find lots more help and links on our Fiori for S/4HANA wiki https://wiki.scn.sap.com/wiki/display/Fiori/SAP+Fiori+for+S4HANA

Good luck!

Rgds,

Jocelyn

[former_member193585]

Hi,

I can see Queries in my 'Query Browser' fiori app if I assign wildcard(*) S_RS_COMP & S_RS_COMP1.

But we can not use wildcard in production, so how can we get actual values of RSINFOAREA and RSINFOCUBE.

Thanks.

[Former Member]

Hi Vivek,

I am also faced the same issue. I did below Steps to resolve.

1) Added role SAP_BR_EMPLOYEE to user -> this role will enable the APP on FIORI Launchpad .i.e we can see now Query Browser

2) Activated the Service /sap/bc/ui5_ui5/sap/viewbrowsers1 in SICF .

3) You can do analysis by pressing F12 and see where it is failing or share the screenshot.

Thanks,

Dileep Kosana.

[former_member486944]

HI Vivek,

Did you manage to resolve this. Request you to share the steps.

Regards,

DL

[Former Member]

I am also faced the same issue. I did below Steps to resolve.

1) Added role SAP_BR_EMPLOYEE to user -> this role will enable the APP on FIORI Launchpad .i.e we can see now Query Browser

2) Activated the Service /sap/bc/ui5_ui5/sap/viewbrowsers1 in SICF .

3) You can do analysis by pressing F12 and see where it is failing or share the screenshot.

Thanks,

Dileep Kosana.