cglowe
03-22-2024Cloud Apps
Return members from dashboard script
My goal is to have a dashboard filter be dynamically hidden based on number of values in an elasticube table that a user has access to.
Specifically, if [Tenant].[Tenant Name] returns more than one value, the dashboard filter should be visible. Less than two and it should be hidden.
I'm able to hide/unhide the dashboard filter via dashboard script, but am not sure how to retrieve number of Tenant Names without creating a new widget and also making it hidden. Is it possible to return table.column members in a dashboard script?