Quick View - Reference cell for parameter

Forum|Forum|2 years ago
February 13, 2024
3 replies
0 views

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.

Excel Add In

B

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

C

CWinAuthor

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.

M

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,

A

aricgresko

Sounds like a great thing to put on IdeaStream

R

rkrull

Someone posted this on ideastream awhile ago, needs some votes! I agree it would be really helpful to be able to reference a cell in a QV.
Quickview member filter to reference excel cell + excel function expans with Quickview expansion | OneStream Community