Bex reporting on HANA Views based on Transient Providers

[Former Member]

Hello,

I am using Embedded BW to create my reports based on calculation views.

Thus, after modeling my calculation views in HANA Studio, I would like to use Query Designer to create Bex reports.

Then, 2 options:

1/ Usually, it is recommended to use transaction RSDD_HM_PUBLISH to generate a transient provider from a HANA view.

2/ When opening Bex Query Designer, I see directly my calculation views in package starting with 2H-.

It works fine but the list of values when creating restrictions, is empty...

Moreover, from Query Designer perspective in HANA Studio, the 2H Transient providers are not visible.

Have you already heard about the option 2 ?

Regards

Eric

[Former Member]

Hi Eric,

yes I have heard about option 2 and already used it.

Very easy: open query designer, log on onto the HANA system and select the hana live view and there you go.

I only used it with BEx Query Designer though, so I cannot speak about HANA Studio.

But in my case, the LOV for restrictions is not empty.

How did you create your view?  By using variables or parameters or ...?