Write back functionality from a tablulate embedded table in a dashboard to Snowflake Data wareshouse

Question

Hi All,

I'm a newbie to JMP, I created a dashboard in JMP which has some charts in it and also a Tabulate underneath. I would like to click on any of the data points in the charts which would drill down the records in the Tabulate and then should be able to edit any of the cells/columns within it and saving that row should update the changes back in the snowflake data warehouse. This is possible with Power BI and Power ON(Power BI integration tool) today, wanted to implement similar functionality as Power On in JMP. Can any one please help?

Thanks

Varun

Varun · Answer

Hi @danschikore ,

Thanks very much for looking in to this, I'm mainly looking for updating/write back to the Snowflake data wareshouse directly from the dashboard interface.

Please find the video link(http://poweronbi.com/powerbi-visual-planning-demo/) of "Power On" tool which is doing that using "Power BI" dashboards, trying to figure out if something similar is possible with JMP <-> Snowflake(may be possible with any integrations tools?).

danschikore · Answer

I think the drill-down capability that you want is referred to as a selection filter in JMP.  If you are using Combine Windows to create the Dashboard, there is a toggle button to filter by one of the reports.  Within the Dashboard Builder, there is a predefined template for creating a selection filter, or can you work with any initial layout and then right-click on a report to designate it as a selection filter.

In the resulting Dashboard, a funnel icon indicates that the selection in the Graph Builder report will filter the data that is seen in the Tabulate:

Hope that helps!