I am trying to extract data out of a inventory cubes/Multiproviders using APD. And when I execute the APD, it gives an error message - "Filter for time reference char. '0CALDAY' in node 'DS_INFOPROV1' is not there or invalid"...
In the detailed explanation of the error I see - "A non-cumulative key figure was selected in an InfoProvider data source. The downstream filter required in this case for the reference characteristic of time aggregation (0CALDAY) is missing or contains errors. Either one interval or a list of single values must be specified in the filter.
For compound characteristics, each higher-level characteristic must be restricted to exactly one single value.
It is not possible to execute the analysis process. The data for the InfoProvider data source can only be displayed on the downstream filter."
Can you pls help me troubleshooting this error?