Restricting a keyfigure with Calmonth ??

[Former Member]

Hi All

We are facing an issue in Query while restricting a keyfigure with 0calmonth , we are not getting the desired output ,as same as in cube while the filter and also the output result field is coming blank .This problem is occurs in the Test server after transporting the query to test server where as in the development server it is working fine .

When I did an analysis by creating a test query in the test server,

Problem Description with an Example

*********************************************

1. Example: If i restrict "Calmonth"(let's say 12.2008 or a variable calling "calmonth" as input) with the keyfigure; i am not getting the desired results compared to the Cube . In contrast, if I restrict the same keyfigure with "calday"(1.12.2008 - 31.12.2008) i am getting the desired output matching with the cube .

Well, the this sample query works like a charm in our DEV servers(same set of data).

Appreciate your help in this regard, also I would like to know how to trace or monitor a query during runtime or is this actually feasible ?

Thanks,

Sandhya.

[emjay]

Check the cube to see if the 0CALMONTH field is populated.

Check the transformation may be the transformation was not activated correctly. if thats the case then retransport the transformation again.

Use TCode RSRT to debug the query to see if something else is happening

I would also check the query to see if any other filters are present

[former_member206112]

Hi,

What kind of aggregation does this key figure have?

I believe the problem resides in that.

Tomer.

[Former Member]

Hi,

Key figure is a having exceptional aggregation based on 0calday lastvalue ,Aggregation is sum .

Thanks & Regards

Sandhya