Data Source with two numeric values
Hello everyone, I am trying to create a data source with two numeric values, one being amount and the other one being volume. But I am not sure if this is possible. Objective would be to be able to...
Forum Discussion
Nirod95, it is possible to have a data source with two numeric values. You will need to set the 'Data Structure Type' field of your OneStream data source to 'Matrix Data'.
You then need to create two Source Dimensions in your data source for the two fields, make the 'Data Type' field 'Matrix Text', and add a Static Value to the Dimension member you would import to for each field.
I would map Amount and Volumen to 2 different Flow members, which will allow you to toggle back and forth to look at the P&L at the two different amounts.
Lol, yeah, I totally blanked out on the Matrix approach - probably because I find them a bit messier and occasionally surprising in how they work. But it's a great suggestion.