I'm hoping to use web report studio (WRS) as part of an application. However, during use of this application, the measures in the
cube (not the dimensions) will change.
I can update the cube while a report is open by running proc OLAP/update-in-place, however, when I hit "Refresh data" in WRS the
report still shows the old data. I have to log off WRS and log back on again to get it to reload the cube.
Is there any way to force WRS to reload a cube? (Other than logging on & off!)
I've just had a call from SAS Support indicating that this is not possible - the cube is accessed only once per workspace session. Starting a new workspace session is the only way to see the new data.
I've just had a call from SAS Support indicating that this is not possible - the cube is accessed only once per workspace session. Starting a new workspace session is the only way to see the new data.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.