Question:
Hi,
My problem concern result rows in a query:
In the report there are 3 KF and the another KF calculated from these three KF.
the result rows of the 3 KF are O.K, but the result row of the calculated KF is wrong: it is calculated from the results of the 3 KF and not the summation of the rows.
i found out that if i show only "material group" in the report the summation is wrong, but if i add "material", the summation is correct.
what could be the problem??
thanks,
mayz
Answer:
in the Query Designer, go to the properties of your CKF, and in the dropdownbox for "calculate result as", choose 'summation'. This will force him to calculate this reult 'vertically' and not 'horizontally'
Answer:
hi,
i have already changed to summation. the strange thing is that i need to show the "material" in the report in order to get a correct summation. that's my real problem.
any ideas?
thank, mayz
Answer:
Create a calculated KF, calculated before aggreggation (in the properties of the CKF).
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
hi,
i tried it and it doesn't work. it shows X in the report.
another ideas?
Answer:
I've had a very similar problem before!
the bad news is, it could not be fixed within the query.
one way you can fix it, is to create the calculation in the update rules, so the values actually get loaded into the cube.
Answer:
thanks.
but unfortantly i can't make the calculation in the update rules because i have rutines there..
mayz