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