Skip to Content
0

Fiori Query Browser showing no queries

Dec 19, 2016 at 09:07 AM

497

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Jocelyn Dart
Dec 01, 2017 at 08:29 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 08, 2017 at 03:58 AM
0

HI Vivek,

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

Regards,

DL

Show 1 Share
10 |10000 characters needed characters left characters exceeded
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.

0
avatar image
Former Member Nov 30, 2017 at 10:16 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 23 at 03:16 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0
UI5 Developer Jun 26 at 10:35 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded