Not seeing data in the query

[Former Member]

Hi gurus,

My Cube has data for FY 06 and FY 07. When I am executing query I am able to see only FY 06 data and for FY 07 it is saying No Application data found.

I debugged query in RSRT with FY 2007 as selection criteria it says

1. No Appropriate data records found

2. There are calculated elements. THese results are bracketed[].

3. Nos. recalculated locally: parenthesized in debug mode []

Pls revert back with ur suggestions...

[former_member188975]

Hi,

Are all the requests loaded to your cube available for reporting? Can you check if you get data for 2007 selection through LISTCUBE...

[Former Member]

I am seeing data for FY 2007 in the cube

[Former Member]

All the requests are available for reporting and I am able to see FY 2007 data in the cube but it is not displaying in the query..

Bhanu waiting for ur suggestions

[former_member188975]

Do you have any filters in the query, like if you have a filter for version...assuming that 2006 and 2007 data has different versions (just a guess...)

[Former Member]

No Bhanu... my selection criteria was 04/2007 for calendar month.

Apart from these I don't have filters.

[Former Member]

Hi,

If the aggregates are there on the cube ,Make sure that all requests are rolled up.

With rgds,

Anil Kumar Sharma .P