Datamanagement load two accounts in columns and periods in rows
Hello experts,
I'm using EPM Cloud Enterprise
I have a file to load via DataExchange (DataManagement)
This file doesn't have the account because I have to create from two additional columns of this file, this works with LOOKUP dimension.
My problem is that I have Period in rows of this file and I have two columns of DATA (Tones and Amount(€))
this is an example:
Entity | Day | Bank | Country | Transport | Tn | EuroAmount |
|---|---|---|---|---|---|---|
E1 | 20260422 | 0001 | National | Maritim | 10 | 10000 |
E1 | 20260423 | 0002 | Foreign | Maritim | 14 | 15000 |
E1 | 20260424 | 0003 | National | No Maritim | 18 | 20000 |
How can I load this file? How can I config my Import Format?
I have created a Period Row and it works for Periods in Rows and Country and Transport are my lookups for create my Account Member, but I have problems to load both accounts.
Tagged:
0