Skip to Content

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

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"

scnpost.png (11.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 08, 2016 at 12:15 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 08, 2016 at 12:17 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

      capture.png (11.7 kB)