we have two DSO into an Multiprovider and based on that we built the queries. now one of our Query is facing some problem.In this Query we have the Keyfigures coming from a DSO1(availble only in the DSO1) and the characteristics coming from both the DSO(DSO1 and DSO2). and also we have a calculated keyfigures based on the above keyfigures.
The Problem is that the calculated keyfigures are showing a wrong value, even i restricted the Query to only oneDSO(DSO1) but still again the calculated keyfigure became a constant value.
But when i created this query upon the DSO1 , it is giving a correct value.
Do i want to change anything in my multiprovider assignement for the query. My assignment is below.
all characteristics - DSO1 & DSO2
Keyfigures - DSO1.
Note : one of the keyfigure(which gives problem) is coming from both the DSO , but i asigned to only DSO1 and that keyfigure is a date field.