Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 25 at 02:30 PM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 26 at 07:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded