Skip to Content
avatar image
Former Member

Fiori Query Browser showing no queries

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Dec 01, 2017 at 08:29 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 08, 2017 at 03:58 AM

    HI Vivek,

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

    Regards,

    DL

    Add comment
    10|10000 characters needed 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.

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

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 23 at 03:16 PM

    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.

    Add comment
    10|10000 characters needed 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.

  • Jun 26 at 10:35 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded