Skip to Content
0
Former Member
Dec 13, 2007 at 07:48 AM

Query , Filters and Variables

37 Views

Hi All

There is a query on a inventory cube and this query is not able to retrieve data for a particular plant and material selections.Infact,its not able to retrieve data for that particular plant for any material.But I could see the data for this plant in the cube.

Could anyone suggest reasons for this?

This query has a filter on the characteristics - plant country and plant controlling area.Inthe query there is a condition for the key fig as stock value not equal to 0.The data thats not getting retrieved in the query has a stocl value other than 0.

Please,can anyone brief me on how filters work in a query and how to we apply them .Also if we use variables in queries how do we see what are the values these variables hold and so on.