How SAC process story?

[SayedZubair]

Hi All,

Like we have in Webi, a SQL gets generated for all the dimensions and measures selected along with the filter conditions and then that query hits the DB and populates the data.

How does it work in SAC? We have different graphs plotted against different dimensions and measures. Each time we open a story does a query gets generated for all the graphs separately?

And then we have Explorer Mode, this brings in all the data irrespective of what values were passed in Prompts. So a separate query is generated again for Explorer mode?

Can someone please share some more knowledge on this. That will be helpful.

[mfoeken]

Hi Sayed,

I believe that indeed for each widget a query is generated which is sent to your data source for processing (if using the live connection). When you open developer tools in Chrome you can see all the requests via the network tab.

Kind regards,

Martijn van Foeken | Interdobs

[SayedZubair]

Hi Martin,

Thanks for the quick response.

So, this means when we start the explorer mode a new query is executed?

Is there a possibility to check the sql?