Question:
I have a query which shows different result from what i have it in the cube.
I have a document number in rows and two key figures one amount and another which shows no. of days for clearance. In the cube, for the same selection criteria , it gives me three records for the same document no. but in query its is gving me one record with different values in KF.
sample.
In cube
Doc Amount No. Days for CLearance
59 100 31
59 400 14
59 500 38
In query the result shows as
59 1000 1
Any Ideas where it is doing wrong. No of days for clearance is calculated from the difference btw posting date and clearing date. I need No. of Days to further develop this query.Is it something to do with compression, or query cache..
Any Ideas!!1
Thanks in Advance..
Veeru
Answer:
Maybe it has something to do with the alpha conversion. Your query result doc # (59 1000) & cube doc #s (59 100) are not the same.
_________________
Keep smiling
Answer:
You may have confused i guess. Document is same 59
Doc is 59 , 1000 is the amount showing in the query
DOC ---- Amount ---- No.of Days to CLearing
59 ------- 1000 ---- 1
In CUbe
DOC ---- Amount ---- No.of Days to CLearing
59 ----- 100-------- 31
59 ---------500-------14
59-----------400-------18
Hope you understand clearly. the value of Days to Clearing is showing as 1.
Properties of that key figure are defined as follows..
KF as NUMBER
Aggregation :Summation
Exp.Aggregation : Counter All Values.
Ref Characteristic : cal day.
Is this something related to the display properties in BEX. Again, In cube the records are correct..
Thanks
Veeru
Answer:
Sorry for the misunderstanding!
The KFs are summed up correctly to 1000 for doc # 59. What do you expect for the # of days to clear? An average? Maximum? What are the references? If the CKFs have a formula for each row, then the overall result cell will try to use use the same formula - what posting date and clearing date will it use?
_________________
Keep smiling
Answer:
One Kf is summed up 1000 , that is fine. The other key figure is showing as 1 instead of summation. It is not a calculated key figure. it comes from the cube . I have written a routine to get no. of days (posting date- clearing date.) In cube, it is showing the no. of days but when it comes to query level, it is not picking up any value except 1.
The Properties i set up on that KF at query level are.
Scaling Factor: not defined
HIde: Always Show
Calculate Result as: Nothing Defined
Calculate Single Values as : Nothing Defined