Forum Discussion

DDrider's avatar
DDrider
New Contributor III
10 months ago

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.

     

     

     

     

  • halbrooks100's avatar
    halbrooks100
    New Contributor III

    when you are in the formula edit bar, click on the FX to the left of it

     

    it will bring up this interface.