Oracle Analytics Trainings

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Add Dimension into Text Box according to the Dashboard Filters

Received Response
47
Views
1
Comments

Hi,

In DV Mode, Is it any way that to create Text Box and calling the Dimension into the Text Box according to dashboard filters ?

eg.

Dashboard Filter selected "Factory_Name" eg. Factory A

In the text box, would like to call the "Factory_Country" dimension and present it into the text box field eg. Thailand.

Answers

    1. Create two parameters One P_Factory_Name and P_Factory_Country
    2. Assign P_Factory_Name to the Column Factory_Name
    3. Bind P_Factory_Name parameter Factory_Name Dashboard Filter
    4. Create the P_Factory_Country parameter using the Logical SQL and match P_Factory_Name with the Factory_Name from Logical SQL
    5. Add Parameter P_Factory_Country to the text box.
    6. Save the Workbook.

    The above steps should give you answer to your problem

Welcome!

It looks like you're new here. Sign in or register to get started.