not getting 'actual data' in the planning query

[Former Member]

Hi all,

I am debug other's query. This cube stores 'actual' and 'plan' data and I loaded 'actual' and can see it in the cube. But I cannot see 'actual data' when I run the planning query.

I checked all restrictions in the KFs and CHARs and fliters in the query. There are only 'value type 10', 'fiscal year variant Z1', and 'currency CAD' restricted and actual data does contain those values in all line items.

Can someone point it out what it could be the issue? Thank you.

R.

[lucimar_moresco]

Hi,

if you enter some data (plan data) you cannot see it again. Is that correct?

are you using the same query to enter and to see plan data?

Because if you are entering data in an aggregate level and you are executing your query over the infocube you will not see the data from the yellow request. If you execute query over the aggregate you should be able to see all data in the cube (yellow and green requests).

Also check if your query is defined as per note 1136163.

I hope this helps.

Lucimar