Reading an XFGetCell
Hi,
I have a large Excel report built on XFGetCells. I am trying to understand the dimensions that each XFGetCell is grabbing, but it takes a long time to parse through an XFGetCell manually and make notes of each relevant dimension. Is there a method or tool to read XFGetCells and translate the dimensionality in a format that identifies which dimension each member is related to?
An example of one of my XFGetCells is:
=XFGetCell(TRUE, "Cube1", "Entity1", "", "USD", $G$4, H$18, $I$4, $C$24, "Top", "Top", "Top", $C$15, "Top", $C26, "Top", "Top", "None", "Top", "None")-XFGetCell(TRUE, "Cube1", "Entity1", "", "USD", $G$4, H$18, $I$4, $D$24, "Top", "Top", "Top", $C$15, "Top", $C26, "Top", "Top", "None", "Top", "None")-XFGetCell(TRUE, "Cube1", "Entity1", "", "USD", $G$4, H$18, $I$4, $E$24, "Top", "Top", "Top", $C$15, "Top", $C26, "Top", "Top", "None", "Top", "None")
I would like to understand that
Cube= Cube1
Entity= Entity1
Parent=
Cons= USD
Actual= $G$4
Etc.
Thank you
when you are in the formula edit bar, click on the FX to the left of it
it will bring up this interface.