Unable to view Bex query text variable in Design Studio Cross tab header

[madireddy_rahulreddy]

Hello Design Studio experts,

We have a requirement where we need to show the Bex query text variable in the Design studio crosstab header. We have currency field as a prompt variable and when the user selects the currency on start up, as lets say SGD, we need to display this selected value in the crosstab header. we are currently on Design Studio 1.6 sp3. Attached is also an image of the crosstab but the variable doesn't show. it just shows the technical name of my currency variable. Can this be achieved? I want the header to read as "Approved Budget SGD"

[former_member265529 · Accepted solution]

Hi Madireddy,

You can access the text variable with setVariableValueExt() Funtion.

It will not be available in setVariableValue() Funtion.

If it is still not accessible check the variable properties in BEx whether the "Variable Is Ready" for input option is enables in Details tab.

Thanks,

Poovarasan

[madireddy_rahulreddy · Accepted solution]

Thanks Boopalan. This works.i used the set variable value function to set the text variable and it shows in header

[former_member812934 · Accepted solution]

Hi. Where exactly did you maintain this function? On Variable Initialization / On Startup...

I tried the following: APPLICATION.setVariableValueExt(variable, value) but when opening the help to select my bex text variable, i do not see it in the list of available variables.

Any help would be very much appreciated!

[TammyPowlas]

This is interesting, as my currency comes over without my doing anything to the BEx query (7.x too)

Is your key figure info object data type defined as a currency as shown below?

[madireddy_rahulreddy]

Hi Tammy,

Thanks for your prompt reply. The currency appears beside the value. This isnt an issue. The problem is that I need to display the currency in the header of the table. For example, in the screenshot attached, I need to display the currency in the header i.e Approved Budget (SGD). In the same screen, user has the option to switch currency and the header should change as per user selection. We used bx query text variables but they don't work in crosstab header.