H
Hood
My task is to construct a data cube using OLAP for colleagues without Excel
2007. If I use a Pivot Table in Excel 2007 it will sum up the quantities
correctly so 1.5 + 1.5 = 3. However, in the cube it will round down so that
the answer is 2.
The odd thing is that another field, price, which typically is not a whole
number,is summed up correctly in the cube, even though the two fields are
both formatted as "general" in the original .csv file.
2007. If I use a Pivot Table in Excel 2007 it will sum up the quantities
correctly so 1.5 + 1.5 = 3. However, in the cube it will round down so that
the answer is 2.
The odd thing is that another field, price, which typically is not a whole
number,is summed up correctly in the cube, even though the two fields are
both formatted as "general" in the original .csv file.