So I have a few questions about a dual storage mode table.
I have an aggregate ( composite) model setup with a few dimensions in dual storage mode.
We embedded our report and on the website give the user ability to change some aspects of a dimensions (group things together ect.). They expect to see the changes instantly. Since the dual table stores a version of the table in memory, we dont see the changes take effect instantly. When refreshing the model they will come through.
Is this performing as designed?Is there a way to get the table to act as direct query? Through the api can i force a refresh of one table? xmla endpoint may be able to refresh one table but i dont think its out yet?