| http://www.w3.org/ns/prov#value | - Here is an example of 2 queries on the underlying data that would yield different results - to illustrate the issue:SELECT SUM(DOLLARS_GOT) FROM FACT_MAIN MSELECT SUM(DOLLARS_GOT) FROM FACT_MAIN MINNER JOIN FACT_SUB S ON M.F_ID = S.M_IDI am thinkign that you can not reliably build a cube on this unless these numbers are the same for both queries here, especially if the plan is to allow users to draw
|