Quick View - Reference cell for parameter

[CWin]

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.

[BenThompson]

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,

Ben

[CWin]

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.  

[MikeG]

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,

[aricgresko]

Sounds like a great thing to put on IdeaStream