on 02-02-2016 11:55 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
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
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
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.