Skip to Content
avatar image
Former Member

consume bex query in hana

Hello Gurus,

based on multiple BEx queries, I need to make a join and then publish the query result. How can I expose/consume the BEx query into HANA views? Any pointers would be helpful.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 09, 2017 at 09:39 AM

    Hello,

    Here are below steps to consume BEx query into HANA views:

    1. Run transaction RSDDB. Enter SAP BW query name and click on : Release query as infoprovider.

    2. Index maintenence screen is launched. Click on activate and fill index.

    3. Log on to HANA Studio. Click on File---> Import.

    4. On the Import screen, click the SAP HANA Content folder, and choose the Import SAP NetWeaver BW Models option.

    5. Select the connection and provide a Username and Password to login to the SAP NetWeaver BW system to import an SAP NetWeaver BW model> Click Next.

    6. Select the Target folder where you want to import SAP NetWeaver BW models by entering the Target Package on the screen.

    7. Import BW Query and click “Next”. Note that imported models will be created as an SAP HANA model (analytic or calculation view) under the Target package.

    Also please refer the link for your reference: https://blogs.sap.com/2015/11/23/publishing-sap-bw-bex-queries-to-sap-hana-views/

    Regards

    Neha

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      thanks Neha for your inputs... in the meantime I went through these steps..this way is not possible for me since in RSDDB, it throws an error. "query has input-ready variables"

      My query has variables(time based) in the key figure definition. Hence this way is not possible.

      the other way, I was trying was to allow the infoprovider behind this query with "External SAP HANA view" option. Unfortunately, the query is built on Multiprovider and hence this way is also not possible. this is only valid with DSO/Infocubes/etc.

  • avatar image
    Former Member
    May 10, 2017 at 09:40 AM

    Found the latest information in the following note: 2317197 - External SAP HANA View: Frequently asked questions, feature availability

    Add comment
    10|10000 characters needed characters exceeded