03-15-2024 06:26 PM
Hello,
I'm hoping someone can help me with a syntax issue where I have data in a spreadsheet that is organized with accounts on the rows and 12 periodic months in the columns. I want to be able to tell OneStream that there are multiple amount columns and columns represent different time periods. I can label the amount in the 1st column "Jan" and make T#:[2024M1] using XFD named range the data will load but I want to be able to load all twelve columns at once. Does anyone know how to do this? Does it require a business rule?
Thanks,
Scott
Solved! Go to Solution.
03-18-2024 05:15 AM
You have to use the Matrix load to achieve what you are wanting to do. So if you change the Column tag from T#:[2024M1] to instead say T#:[]:[]:[2024M1] then the next one T#:[]:[]:[2024M2] and so on, it should work.
Joakim
03-16-2024 01:41 PM
Hi Scott,
I haven't tried this but I think it should work. First, maybe you can set up a workflow so that you have one input per year so you can import all the data per month at once. Then I think in the data source, you'd have to add 12 amount sources (to check).
Another way of doing it is to massage the source data so that you have the regular format of one line per cell data.
Please tell us what kind of method works for this.
Best regards,
Carlos
03-18-2024 05:15 AM
You have to use the Matrix load to achieve what you are wanting to do. So if you change the Column tag from T#:[2024M1] to instead say T#:[]:[]:[2024M1] then the next one T#:[]:[]:[2024M2] and so on, it should work.
Joakim
03-18-2024 07:11 AM
Thanks JoakimK, I tried your suggestion and it worked! For other users wanting to use this method you also need to specify AMT#:[] in your dimensions as OneStream will require that as well.