Add Dimension into Text Box according to the Dashboard Filters

Question

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.

Shiva Kumar Oleti-Oracle · Answer

* 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