Populate parameter's dropdown from another cube

13 views
Skip to first unread message

Q&A Bot

unread,
Mar 29, 2021, 6:19:42 AM3/29/21
to seektab...@googlegroups.com

Q:
Is it possible to use a cube as a dropdown in another report.  So if I had a cube of all of our products and wanted to use that as a drop-down as a conditional in another cube could I do that?

This is possible and even recommended as a more efficient way to populate the dropdown.

Let's assume that you have a "product_id" parameter in the 'cube1', and you want to use 'cube2' to populate a dropdown list.
For this purpose choose Editor="Dropdown (dynamic)" and specify "Cube ID" + appropriate dimensions for 'value' and 'text' of dropdown items: 

image.png

You can get cube ID value from the URL, for example:
image.png

Reply all
Reply to author
Forward
0 new messages