Forum Discussion

RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
2 years ago

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...
Data Integration
Data Sources
  • JackLacava's avatar
    JackLacava
    2 years ago

    This approach should work

    1. add a new Source Dimension for Time of type "Matrix DataKey Text".
    2. change that data type to "DataKey Text" and assign it to the Fiscal Year column
    3. modify the rule above to just return M1, M2, etc.

    The result should automatically concatenate year and period for the exploded records.

  • RobbSalzmann's avatar
    RobbSalzmann
    2 years ago

    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.

     

franciscoamores's avatar
franciscoamores
Contributor II
2 years ago

I'd need to do some testing but you could assign year column to attribute and then use it to concatenate in BR assigned to Time. To get Mx you can use replace expression in Time dim, similar to this:

 

 

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    2 years ago

    Francisco! 🙂
    We thought about using an attribute also, but are unable to figure out which object the attribute is hiding in in the BR, or if the BR even has access to it.  Maybe you will find it in your testing.

    Back in the days of Upstream, the record being operated on was one of the arguments of the parsing/transformation function.  Its odd how that design didn't follow here. It made things very easy having the entire record available while parsing, as it's common to apply logic using the contents of multiple columns.

    • JackLacava's avatar
      JackLacava
      Honored Contributor
      2 years ago

      It does work like that, just not with Matrix loads.

      • RobbSalzmann's avatar
        RobbSalzmann
        Valued Contributor II
        2 years ago

        JackLacava  any suggestion on how to get a value from another column in a matrix rule?