Quick View - Reference cell for parameter

New Contributor II

Is there a way to have the time POV reference a cell (A1) in a spreadsheet?  User wants to have multiple Quick Views and change time once in cell A1 and it update all Quick Views in the workbook.


New Contributor III

Hello CWin,

If they have multiple Quick Views in the workbook, are they changing or drilling down into the Quick Views?  I have seen clients that just have them structured the way want to and leave it that way.  In those situations, I find using XFGetCell easier so you can drive the dimension selections from a set cell in the Excel workbook.    

For example:  =XFGetCell(True, "Equipment Division", "EUS01", "", "Local", "BudgetWorking", A1, "Periodic", "41010", "None", "BeforeAdj", "None", "None", "USNE", "PRD110W", "CST1101", "None", "None", "None", "None")

Thank you,


New Contributor II

Thanks, Ben --- They want to use the dynamic function of the quick view so if a new account / entity is used it will show in their reports.  

Contributor III

Hi @CWin you would need to convert the Quick View or embedded Cube View to an XFGetCell() retrieve report.  Then you can do what @BenThompson noted and have a Cell Reference to the T#.  

You can't embed a Cell Reference into a Quick View.  At least not that I'm aware of.

Hope this helps,


Contributor III

Sounds like a great thing to put on IdeaStream