Hi All, Data Extract from Planning using Data Management already documented with steps. You can check that with below link.
Data Extract from Planning using DM
Here, I am updating few steps, which may confuse for someone.
- Source is our Planning application.
- Target we need to create as Data Export in Applications in Data Exchange page.
- File format which you will update must be with Period dimension.
- Amount or data - no need to mention, as system will automatically will take. If you mention in file it will show up in application details as member or dimension, which may show up double in Import Format.
- Period - select as Period not to be as generic like other dimensions in dimensions list.
- While creating data load rule, you can select filters, if you want to extract particular data.
- To pull alias of particular member, you select as below:
- Account -- map with Account member
- Account -- map with Account Alias member
- If you don't select Period as Period, and if it is generic in dimensions list, you will get amount in Period in Workbench.
- Some Alias may have names with comma, which will mess up exported csv file. Better to use Pipe symbol.
- You can use .txt format also to get data in correct format.