Hi,
I have a simple query set up to explain my problem.
Rows: Account number
Columns: Balance key figure
Characteristic Restrictions: Fiscal Year/ Period and Account number are specified and both of them have restrictions on them.
When I run the query, I get a simple result
<column headers> Accnt # & Balance
<row values> 101000 & $1,800
I then edit the query to change the Balance column header. I place my cursor after the word "balance" in the description field and press the drop down arrow next to the variable icon which is next to the description. In the drop down, I select "Entry of Variables". I select my variable (0T_CYEAR) Calendar year, click OK, save and run the query.
Instead of getting column headings like this
<column headers> Accnt # & Balance 002/2010
I get this
<column headers> Accnt # & Balance &0T_CYEAR&
Is there a switch somewhere that needs to be set to cause the variable name to actually get resolved to the value?
The variable is defined as follows:
Genaral tab:
Tech name: 0T_CYEAR
Type: Text
Processing By: Replacement path
Ref Char: 0CALYEAR
Replacement Path tab:
Replace var with: InfoObject
Replace With: Key
User Interval: From Value
Offsets: 0 & 0
Other tabs:
Everything is greyed out/empty.
Further more, if I make any change at all to the query (like add profit center to the rows) and hit the check query button, it tells me "Errors: Variable 0T_CYEAR cannnot be used in InfoProvider ZFIGL_M01". However, if I delete the KF, add it back and incorporate the variable into the description again and press check query again, the error goes away only to come back as soon as I make another change.
Your help in this matter is greatly appreciated.
Thanks!