The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

DRider's avatar
DRider
Icon for OneStream Employee rankOneStream Employee
2 years ago
Solved

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.

     

     

     

     

1 Reply

  • 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.