Skip to Content
0

How to union and report on two remote HANA Calc Views with parameters

Feb 25 at 12:50 PM

50

avatar image

Hi experts,

We have BW 7.5 (HANA 1 sp12) and two remote sorces ERP systems (HANA 1 sp12) connected with it. There are two equal calculation views from HANA Live package( sap.hba.ecc.NewGFFinancialStatementQuery) with parameters in the remote HANA's. There is also BI 4.2 server, with connections to BW and also to ERP's HANA DB.

The task is to create SAP Lumira Designer dashboard based on the data in these calc. views.

My questions are:

1) Is there way to create composite provider based on these views?

2) What is the best way this scenario can be achieved?

Thank you,

Ivaylo

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

2 Answers

Andrey Uryukin Feb 25 at 02:30 PM
0

Hi,

You can, in BW, create a source system ODP - HANA Information View for ECC system.

Then replicate your view as datasource and then create open ods view on data source and finally composite provider (if OODS view is not enough.

Other way is to create CDS view in ECC, cosuming calculation view, and then open ods view in BW over that CDS view.

I'm pretty sure that there is additional, may be much easier, solutions:)

BR,

Share
10 |10000 characters needed characters left characters exceeded
Ivaylo Ivanov Feb 26 at 07:00 AM
0

Hi Andrey,

Thank you for your answer.

I'm not sure I can create Open ODS on calc view with parameters - I'll try this.

Indeed my connections to HANA source systems are based on SDA, but of course I can define other types of source systems.

BR,

Ivaylo

Share
10 |10000 characters needed characters left characters exceeded