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
Solved
Unable to get value from another column in Parser BR
OneStream V7.0.1 We have a Data Source that takes data file that has 12 data columns Oct ... Sep. The year for the data in the 12 data columns is a field "Fiscal Year", the first column of the data...
This approach should work
- add a new Source Dimension for Time of type "Matrix DataKey Text".
- change that data type to "DataKey Text" and assign it to the Fiscal Year column
- modify the rule above to just return M1, M2, etc.
The result should automatically concatenate year and period for the exploded records.
This and the following code in a BR called by each of the month columns solved for this requirement. Thanks JackLacava ckattookaran and franciscoamores for all the considerations.
JackLacava
OneStream Employee
OneStream EmployeeThis approach should work
- add a new Source Dimension for Time of type "Matrix DataKey Text".
- change that data type to "DataKey Text" and assign it to the Fiscal Year column
- modify the rule above to just return M1, M2, etc.
The result should automatically concatenate year and period for the exploded records.
This and the following code in a BR called by each of the month columns solved for this requirement. Thanks JackLacava ckattookaran and franciscoamores for all the considerations.