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
OneStream Employee
2 years agoReading 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
- halbrooks100New 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.
Related Content
- 6 months ago
- 9 months ago
- 4 years ago