Skip to Content
0
Former Member
Feb 14, 2009 at 03:49 AM

Restricting a keyfigure with Calmonth ??

9 Views

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.