Hi
I have one query which runs on a multiprovider.Multiprovider has two objects...'Current Sales' cube and 'History Sales' DSO.
The query is like below:(example)
Customer----
-TransactionType -
2000--
100
Sales change formula = Sales Current Day(SELECTION) - Sales Previous Day(SELECTION)
Both selections are based on keyfigure SALESAMT(Sales Amount).It picks Sales amount for current day from 'Current Sales' cube and Sales amount for previous day from 'History Sales' DSO.(Selections are created on SALESAMT keyfigure with the help of 0INFOPROV and 0CALDAY )
I am getting problem whenever for some reason user is changing Transaction type between two days for business reasons ...Actually,there is no change in Sales for that customer between those two days.Its only change in transaction type.But its showing as Sales Change.
when I run the query on second day,the result is like below:(I am getting two records and its showing sales change,even though there was no sales change to that customer between those two days.User changed 'Transaction type' only)
Customer----
-TransactionType
1000--
1000 -
(-1000)
1000--
1000 -
(empty) -
1000
It should actually show Sales Change as '0' as there was no actual change in Sales to that Customer.Only the Transaction type is changed.why is it showing two records and how can I fix this?
It should show like below:
1000--
Indirect
--
1000
1000
---0
Thanks alot.