Skip to Content
0
Former Member
Dec 01, 2011 at 07:18 PM

Query 0CCA_C11_Q0002

31 Views

Hi Experts,

I've implemented BI standard content query 0CCA_C11_Q0002, and I have a issue on last KF

The KF of the report are the following:

- Actual Costs &0T_FPER&

- Planned Costs &0T_FPER&

- Variance &0T_FPER&

- Actual Costs &0T_FPERY& YTD

- Planned Costs &0T_FPERY& YTD

- Variance &0T_FPERY& YTD

- Projection &0T_FPERY&

- Planned Costs &0T_FPERY&

- Variance &0T_FPERY&

All KF are working correcly and pulling the correct description, except last one

Example

- Actual Costs 012.2011

- Planned Costs 012.2011

- Variance 012.2011 (A)

- Actual Costs 2011 YTD

- Planned Costs 2011 YTD

- Variance 2011 YTD (B)

- Projection 2011

- Planned Costs 2011

- Variance &0T_FPERY& (C)

Variance A and B are a formula of 2 restricted KF (Actual costs and Planned costs)

Variance C is a formula betwen planned costs and another formula: projection

Projection is a formula between restricted KF actual costs and current period of fiscal year (formula variable)

When I go to query designer, message displayed is the following:

Warning: Text variable 0T_FPERY in "Variance &0T_FERPY&" cannot be replaced - value not found

Has anyone implemented this query before? How did you solve this issue?

Many thanks

Joana