on 2019 Feb 07 1:23 PM
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
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
52 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.