How to display dynamic Data Filter in JMP Live?

[#1]

We are currently using a custom UI for local setup, but now we want to have a similar setup on JMP Live.

I realized that JMP Live doesn’t work with custom UIs. What options do I have to achieve the same or a similar result?

The current UI filters and creates subsets in a specific format for the end user.

Is it possible, through Data Filter or some other method, to achieve the same functionality on JMP Live? I tested this with Big Class.jmp, but it only uploads and displays the data table on JMP Live, without applying the filtering.

dt = Open("$SAMPLE_DATA/Big Class.jmp");

dt << Data Filter(
Add Filter(columns(:sex, :age))
);

[#2]

Hey, @OddsDeer284888 ,

For ODBC to work in JMP Live, the ODBC connection needs to use a DSN-less connection. If you publish a data table from JMP that has a source script that uses ODBC, that script will automatically be modified during the publish process to use a DSN-less connection (so it will have driver/server in it rather than a DSN). That's step one.  Then, when you make a refresh script for that data table, if you start from the source script, you'll be most of the way there. You will probably have to attach credentials to it.

Step two is to make sure that the ODBC driver that the script uses is installed on the computer that is running the JMP Pool. You may need to talk to your JMP Live administrator about making that happen.

If you run into further problems getting this to work, start a case with JMP Tech Support and we'll make sure to help you get it working.

Good luck,

Eric Hill

[#3]

Hello,

You need to ensure that the server where JMP Live resides has the same exact DSN and Driver installed on it that you have setup on your machine. You'll need to work with your internal JMP Live support team to have them install the driver.

HTH,

Bobby