If I right click and Manage and view the contents of consignment stock in a cube I am seeing the correct number 3. Whereas if I run a query it shows me 5, it seems that it is not deducting the -2 figure for one of the records.
I have built a Cube in which one of the sources is the snapshot ODS it is for this extract that I am having the problem.
Could anyone advise? Thanks