Forum Discussion
Solved
User Input Values for Quick Views
Has anyone come across a simple way to incorporate user input values with a Quick View? Our users very much prefer the Excel Add-In with Quick Views and tend not to like the predefined nature of cub...
Hello!
We use formulas to load too as they give us the most flexibility (as you said, change things on one "set up" tab and that carries to the other tabs. The one thing you can do if you're hooked on QVs is to set the time filter as POVTime and then it'll be based on the POV tab for all QVs. Same idea, change it in one place and it updates everything in the file. Hope that helps - let me know if you'd like screenshot samples!
XFGetCell formulas are your best bet to achieve something similar to what you used to do in Hyperion Smart View. You could use excel cell references and build a report. See screenshot below for a sample. You could set up the time and other dims on an input sheet as global references based on your needs.