Error in result of query

[Former Member]

Hi,

I have got a peculiar senario while executing a query.

The query result is not matching with the line items sum.

i have checked the definition of result, which is as nothing defined.

When I check for the same values in another query, and correlate this with the current one, there is always a difference in the result, where as the line items match in both the cases.

The second query is giving out a correct values.

However this query is giving out correct sum sometimes and mostly it is giving the wrong value in the result column.

Regards,

[Former Member · Accepted solution]

Hi,

Are you using any restriction on that KF. If so , Make the calculation as 'Summation' from 'Nothing'.

With rgds,

Anil Kumar Shharma .P

[Former Member · Accepted solution]

Hi Anil,

The keyfigure I am using in the query is a direct keyfigure, picked up from the cube, so it doesnot have any restrictions.

Regards,

Naveen.A

[Former Member · Accepted solution]

Hi,

Is that Kf has any units.(like 0currency)?

Are you geeting any differnt currencies in the rows of the query?

With rgds,

Anil Kumar Sharma .P

[Former Member · Accepted solution]

Hi Anil,

That keyfigure is quantity with peices as base unit of measure.

[former_member188325 · Accepted solution]

Hi Naveen,

Use NODIM function for that keyfigure...i.e. create a formula NODIM(KF).

regards

[Former Member]

Naveen, did you get the above issue resolved? I have a similar problem at hand. Could you please post your inputs here? Thanks in anticipation.

[Former Member]

Hi,

Also check if you have somewhere 'Constant selection'.

Best regards,

Eugene