🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Expired OLAP cube sessionID

Michael Jiambalvo asked 5 days ago

We have an Angular app using the Flexmonster accelerator to connect to SSAS OLAP cubes.
So when a user is working with a pivot grid, then leaves for lunch, returns and refreshes the grid, they get a blank grid and an unauthorized user message.
Using the browser debugger and examining the response shows {“data”:null,”error”:{“message”:”ERROR_SESSION_EXPIRED”}}
This is may be due to the SSAS default MinIdleSessionTimeout being set to 2700 seconds.
We are unable to make changes to the SSAS config. Does Flexmonster provide a way to keep a session alive? If so, how?
If not is there a way to capture the sessionID and signature after a cube has been connected to using the Flexmonster accelerator? This way we could make calls at some interval to keep the session alive.
Mike Jiambalvo

1 answer

Illia Yatsyshyn Illia Yatsyshyn Flexmonster 2 days ago

Hello, Mike,
Thank you for reaching out to us.
Currently, we do not have a mechanism that would allow retrieving the sessionID. However, we came up with a workaround that you may find helpful for your case. The idea is to update the data preserving all the configured settings once in a while. It is achievable using the updateData method, which updates the data without cleaning the report. For example, you can subscribe to the reportchange and reportcomplete events and use them to start a timeout (e.g., 2600 seconds). If one of the events is triggered within this span, reset the timeout. Otherwise, call the updateData method passing the currently applied dataSource object as an argument:


It will reload the data from the server and refresh the timeout.
Please let us know if it works for you.
Looking forward to your feedback.
Kind regards,

Please login or Register to Submit Answer