cancel
Showing results for 
Search instead for 
Did you mean: 

Not able to see all the packages in BEX Query Designer

kgaurav2k14
Participant
0 Kudos

Hi Friends,

I am trying to create a BEX Query on top of HANA Live views. As they are already exposed in SAP BW system as transient providers once HANA Live is deployed and activated. I am not able to see HBA package under ECC package. I also created my own custom package, this is also not visible.

Please help me to figure out if any authorizations/privilege missing in HANA Studio/BW System.

SAP HANA 1.0 SP10

SAP BW 7.4 SP13

Thanks,

Gaurav

Accepted Solutions (0)

Answers (1)

Answers (1)

anindya_bose
Active Contributor
0 Kudos

I think first you need to publish your HANA model as Analytic Index via  transaction code RSDD_HM_PUBLISH.

If your model is ZTEST then published model will have a name "@3ZTEST" ..  In BEx, you would see this ( @3TEST) , not the HANA model itself.

Cheers

Anindya

kgaurav2k14
Participant
0 Kudos

Hi Anindya,

Thanks for your reply. Let me give you a bit more explanation on my issue. I have ECC sytem on HANA(BOX1) and BW on HANA(BOX2). I have installed HANA Live views(ERP Package) in ECC system. I want to create a BEX query on top of HANA live view so that I can leverage the master data hierarchy.

I am following one SAP document:

http://a248.g.akamai.net/n/248/420835/266161eb68317417de25e0b696a45f800d44f7e34496ac4395a770d6bfbfdf...

It is clearly written that "All HANA Live Views automatically exposed as InfoProvider in BEx Query Designer" and it is also written that "For query execution same user in BW and HANA database is required".

Since, my ECC and BW systems are residing on two different HANA DB. My HANA Live views are installed in ECC System(BOX1), Following are my issues:

1. How can I see those views in BW BEX query designer as my BW system is residing in different HANA DB(BOX2).

2. I created same user in BW as well as in HANA DB but still I cannot see the HBA Package when I try to create a new query on top any HANA Live view as attached in my main thread.

3. Since all the views are automatically exposed, I guess I don't need to again manually publish through the TCODE.

4. Do I need to create BEX query on top of Embedded BW in ECC System.

Please suggest.

Thanks,

Gaurav

anindya_bose
Active Contributor
0 Kudos

Hi Gaurav

I did not try this as I dont have this kind of installation.  However, I see the document says below..

I would assume HANA Live models would be available for embedded BW in ECC system and unless we do something special, it would not come to BW ( separate box) and that is logical. Please share result.

Regards

Anindya