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
OSAdmin
OneStream Employee
OneStream EmployeeXFGetCell for multiple members
Originally posted by Brad Kotecki Is there a way, or a best practice recommended, to point an XFGetCell formula to one or multiple members of the same dimension without adding parent level members ...
Here is an Excel solution:
Have five data pull sheets:
The rows/columns of these sheets are filled with the parameters for the XFGetCell formulas found in the cell intersections. Each of these sheets is identical, except for the entity.
Have a summary sheet:
Put five Include/Exclude cells in the header of the summary sheet, one for each entity. Fill these cells with a one to include and a zero to exclude.
The rest of the summary sheet looks exactly like the data pull sheets. Except there are are no XFGetCell formulas, instead there is a formula in each of the data cells multiplying the Entity 1 value by the Include/Exclude 1 value plus the Entity 2 value by the Include/Exclude 2 value, and so on.
This would be simple to admin.
To add a new row or column, add it to all 6 sheets (data x5 + summary).
To add a new entity, add a new data sheet, add a Include/Exclude cell on the summary sheet and make a sweeping change to all of the identical formulas on the summary sheet.
OSAdminOneStream Employee
OneStream EmployeeHere is an Excel solution:
Have five data pull sheets:
The rows/columns of these sheets are filled with the parameters for the XFGetCell formulas found in the cell intersections. Each of these sheets is identical, except for the entity.
Have a summary sheet:
Put five Include/Exclude cells in the header of the summary sheet, one for each entity. Fill these cells with a one to include and a zero to exclude.
The rest of the summary sheet looks exactly like the data pull sheets. Except there are are no XFGetCell formulas, instead there is a formula in each of the data cells multiplying the Entity 1 value by the Include/Exclude 1 value plus the Entity 2 value by the Include/Exclude 2 value, and so on.
This would be simple to admin.
To add a new row or column, add it to all 6 sheets (data x5 + summary).
To add a new entity, add a new data sheet, add a Include/Exclude cell on the summary sheet and make a sweeping change to all of the identical formulas on the summary sheet.