We have a real time query built on top of a aggregation level. The query contains 6 characteristics restriction of which 1 is input variable, 2 variable are customer exit variable and remaining 3 variable are restricted with value (#). The query will display the percentage value for month April to December. The percentage value can be changed using WAD report..
When we execute the query, the query displays the actual value from the cube. But when we execute the WAD which contains the query as data provider, displays 0 as percentage value for the month which have value in the cube.
Please let me know what could be the reason for this behaviour.
Note: WAD contains another data provider based on another aggregation level.