02-13-2024 08:57 AM
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.
02-13-2024 09:10 AM - edited 02-13-2024 09:10 AM
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
02-13-2024 09:12 AM
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.
02-13-2024 09:21 AM
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,
02-13-2024 03:48 PM
Sounds like a great thing to put on IdeaStream