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
42
Views
1
Comments
User_FHP4K
User_FHP4K Rank 1 - Community Starter

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