Scribd
Upload
610 views34 pages

Publish HANA Models as Transient Providers

The document discusses publishing HANA analytic views as transient providers in BW/4HANA. It explains that transient providers generate metadata for BW from the source system metadata rather than being modeled traditionally in BW. The steps shown include creating tables and analytic views in HANA studio, publishing the view as a transient provider using transaction RSDD_HM_PUBLISH, and then accessing the published data via BW Business Explorer.

Uploaded by

Subhadip Das Sarma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
610 views34 pages

Publish HANA Models as Transient Providers

The document discusses publishing HANA analytic views as transient providers in BW/4HANA. It explains that transient providers generate metadata for BW from the source system metadata rather than being modeled traditionally in BW. The steps shown include creating tables and analytic views in HANA studio, publishing the view as a transient provider using transaction RSDD_HM_PUBLISH, and then accessing the published data via BW Business Explorer.

Uploaded by

Subhadip Das Sarma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 34

Transient provider

We have SAP HANA System. On top of HANA we have ABAP Application layer. On top of
Application Server We have a front end called BEX Analyzer.

The Data Models we have in SAP HANA.

BEX which is plug-in to Excel .It can’t communicate directly to HANA.

Transient Provider is an InfoProvider in BW that is not modeled in the classic sense in BW,
but generates its BW InfoProvider metadata (including the infoobjects) out of the metadata of the
source.

It is possible to “publish” HANA models (Analytic or Calculation Views, not Attribute Views)
as a Transient Provider. To publish a HANA model in BW, you simply execute the transaction
RSDD_HM_PUBLISH.

Open HANA studio.

Expand H20 (BEST) systemExpand BEST schema


In BEST schemaselect tableright click on itclick on New Table.
Enter table name which you want.

Enter column names with specified data type.


Click on Execute.
Select tableright click on itclick on filters

Enter table nameclick on ok.


Now insert values into tables.

Right click on this tableclick on generateclick on insert statement.


Click on Execute.

Here we see statement is executed successfully and values are inserted into tables.
Enter another record.

Click on Execute.

Another record also executed successfully.


For table data preview

Select tableright click on itclick on open data preview.


Here we see data preview of the table.

Now we create another analytic view.

Select analytic viewRight click on itclick on new.


Enter analytic view nameclick on finish.
Click on data foundationclick on “+” icon.
Enter your newly created table name.

Select tableclick on ok.


Select and right click on itclick on add all output.

Now we see all columns in the output panel.


Give any one key.

Click on validate.
Click on save and activate.

Click on data preview.


Click on raw data.

Now logon to BW75ONAHANA .Double click on it


Enter user name and password.

Press Enter
Click on continue with this logon without ending any other logons in the system.

Click on continue.
Enter RSDD_HM_PUBLISH Tcode.

Press Enter

Click on below showing symbol for selecting package.


Select our package.
Click on below showing symbol.
Select view.
Click on create.

This is Analytic Index.

Click on continue.
Click on save.
This is our analytic Index name.

When we click on save Analytic Index is saved.


This is InfoProvider.
Now click on startclick on Business Explorerclick on Analyzer

Click on Add_INS
Click on open Query.

Click on BW75ONHANAclick on ok.


Enter Passwordclick on ok.

Click on find.
Copy the InfoProvider name.

Paste it on searchclick on find.


Select our view.

Here we see output.


Click on filter.

If you want to see BUKRS then double click on it. Now we can see BUKRS with NETWR.
IF you want to see VBELN then Double click on it then at right side we see VBELN data.

IF you want to see VKORG then Double click on it then at right side we see VKORG data.

You might also like