Is It possible to change table data model dynamically in SAC Analytics Application Designer?

[former_member535495]

Hi,

We have one project requirement - where we need to change table data from one query (model) to another query (model) in SAC Analytics Application based on a drop-down list.

Is there any possibility using the script we can change the table data model dynamically? (We know we can achieve this using multiple tables based on different models and setvisible() method, but we need to try this using only one table).

Thanks,

Girish Lakhani

[Susanne_Helbig · Accepted solution]

Dear girish1052,

it's possible to change the model of a table using the API setModel.

Table_1.setModel("<modelID as string>");

Does this help?

Best regards

Susanne

[former_member535495 · Accepted solution]

Hi Susanne,

Thanks for your reply!!

Yes, It works!!

Thanks,

Girish Lakhani

[rafal_skorupa1 · Accepted solution]

Hi Susanne

I would have another question regarding setModel API: when I use it against bex query based model it brings up variable screen immediately - while I would like to set variables via script (right after replacing the model in a table). Is there any way to change this behaviour?

Regards

Rafal

[Susanne_Helbig · Accepted solution]

Hi bob.meincke,

may I kindly ask for your support in answering this question?

Thanks and best regard
Susanne

[rafal_skorupa1 · Accepted solution]

HI susannehelbig and bob.meincke

I would like to kindly ask if you have any idea how to avoid displaying variable screen after using setModel method in live connection model. I would like to set variables via script... Do you think it is achievable?

Regards

Rafal

[Susanne_Helbig · Accepted solution]

Dear rafal.skorupa,

I'm not an expert regarding Application Designer, I'm also 'just' a user.

bob.meincke kindly ask for your support.

Thanks
Susanne

[Josef_Obrist · Accepted solution]

@rafal, I think turn on/off the prompt is now available along with setmodel in Q2_2025 release