Skip to Content
0

consume bex query in hana

May 09, 2017 at 09:18 AM

409

avatar image
Former Member

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.

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

2 Answers

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

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

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

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

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

Share
10 |10000 characters needed characters left characters exceeded