cancel
Showing results for 
Search instead for 
Did you mean: 

Composite Provider doesn't show Data of ODS View depending on Filter/Navigation

LukasFinke
Newcomer
0 Kudos
1,143

Hello,

this is my Scenario:

Composite Provider with three subproviders, 2x ADSO (for planning) and 1 Open ODS View based on a HANA calculation view.
When i use the datapreview of the ODS View, there's all data just as i expect (e.g. a certain quantity for date 07.02.2019) .

But when i check the data at composite provider level:
*no filter: All data of all subproviders available.

*filtering on date 07.02.2019: no data of the ODS View anymore

*filtering to e.g. 06.02.-09.02.: data of the ODS View is available again.
* data on some other (older) dates is always available.

Has anyone else encountered this phenomenon or found a solution?

Any hints are much appreciated because as you can imagine consistent data is needed for our application.


-->Clearing the database caches/ OLAP cache did not fix the issue.

Similar behavior occurs at other composite providers, always with a subprovider of type Open ODS View.

Thanks in advance,

Lukas Finke

Accepted Solutions (0)

Answers (1)

Answers (1)

nora_roch
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Lukas,

does the filter already work when querying the OpenODS View directly?

In many cases, data type conversion issues cause this, use the RSRT - Execute&Debug: Display SQL/TREX or the ST05 trace to see how the filter looks like that is send to the datasource. Are there format differences between the single value filter and the range?

Some of the explicit and implicit conversion are explained in SAP Note: 2417404-Open ODS View - Data Type Handling Explained

Maybe this helps to narrow down the issue a bit...

Cheers,

Nora