composite mapping rule by period
Hello, I am new to Onestream and trying to solve something that seemed easy but it doesn't work:(
We need to map an account by the entity and by the time. I used composite mapping. to be exact;
A...
Forum Discussion
Pick out a dimension that is not being used for mapping ie the current maps have a Mask map * goes to None. Let's call it UD7.
Write a Business Rule that gets the Time POV and save that to UD7. Steps: on the Data Source for UD7 add a Logical Operator which is a Business Rule which returns the current Time POV. This saves the current Time member to the Stage data against every record. The source values in UD7 are ignored because everything maps to None.
Add a composite map that looks at UD7 instead of the Time dimension.
It worked. I ddin't have to use another dimension but your replies made me realize that in our source data we set Time as Current DataKey and that's why my inital mapping didn't work. However we have column in the data file that already refers to the time so I used business rule to convert it to the time and period and changed Data Type from Current to DataKey and then after reloading my original Composite mapping worked! Thank you!
MarcusH,
This looks like a great solution. I'm in the same boat, except I don't have any dimensions that are not being mapped. Any suggestions?
