Allocations in OS
Source: OneStream Champions Hi all! Do any of you run allocations in OS? Would you be able to share how you accomplish this? Currently we manually reallocate data that comes into our income statem...
Forum Discussion
Hi Nicole
I am assuming that the source data required for the allocation calculations are held in OneStream.
You can set up an “allocation” member on one of your dimensions and put a member formula for your calculations on that member.
Could be on any dimension, incl. UD2 if that works best for you. Example:
TopUD2
TopAdj
TotalAfterAllocations
Alloc
TotalDataSource
DataImport
DataAdj
DataEntry
You can take your source data to be allocated from the member “TotalDataSource”, split the data by your allocation key, and make data destination = “Alloc” (you can split this in “AllocIn”, “AllocOut”, etc. if required).
With a solution like this, you can keep source data and allocated data on same member on all dimensions, except the dimension where your “Alloc” member is, but you can of course also choose other members on any dimension.
This ensuring your source data are untouched, and that the allocation data are kept separately.
You can then also use the dimension to report both incl. and excl. allocations.
Best regards
Dennis