Skip to content

Oracle Communities

Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
Oracle Analytics Cloud May 2025 Update The Oracle Analytics Cloud (OAC) May 2025 update enhances how users generate insights, engage with data, and distribute content
Poll: Oracle Analytics Community Website Satisfaction Tell us about your satisfaction with our newly redesigned Oracle Analytics Community Website.

Oracle Analytics Trainings

Categories

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

User_FHP4K

User_FHP4K Rank 1 - Community Starter

Nov 21, 2024 4:40AM in Oracle Analytics Trainings

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.

1

Answers

Shiva Kumar Oleti-Oracle Mod

Nov 21, 2024 6:55PM
Create two parameters One P_Factory_Name and P_Factory_Country
Assign P_Factory_Name to the Column Factory_Name
Bind P_Factory_Name parameter Factory_Name Dashboard Filter
Create the P_Factory_Country parameter using the Logical SQL and match P_Factory_Name with the Factory_Name from Logical SQL
Add Parameter P_Factory_Country to the text box.
Save the Workbook.
The above steps should give you answer to your problem
2