Forum Discussion

MHL's avatar
MHL
New Contributor
3 years ago

Avoid changing members manually through Member Filter - Quick View

Hi everyone,  Is it possible to call the Rebuild function in VBA ? The goal is to update a Quick View by typing in a new period to avoid going into Member Filter and change the period manually (work...
Time
db_pdx's avatar
db_pdx
Valued Contributor
3 years ago

"I know that Time Functions can be used so users can update through Cube View but the client insists on building a macro."

I'd push back on this.  Show them how they can put multiple, linked cube views into a single excel workbook.  Put a well formed member filter selection parameter into all of them.  Hit Refresh Workbook and show them how it will prompt once, and refresh everywhere.

Cube Views + Common Parameters = Report Refresh Magic