Skip to Content
0
May 12, 2010 at 12:05 AM

Bex Query returns &variable name& instead of the value

186 Views

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!