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.