Skip to Content
0
Former Member
Jun 01, 2011 at 01:20 PM

multiprovider -query error

22 Views

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 -


sales Current Day Sales Previous Day --SalesChange(formula)

2000--


Direct
1000

900
--


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


Sales Current Day -Sales Previous Day ---SalesChange(formula)

1000--


Direct -
(empty)--


1000 -


(-1000)

1000--


Indirect--


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.