To create a consolidation account you must first make sure you have the flex.bi business plan enabled on your account, if you do not then contact flex.bi support to receive information on how to acquire it.
This plan parameter is available only for private flex.bi users. Cloud users have to inform us at support@flex.bi of your wish to create consolidation accounts and send us the company codes.
If you have the business plan parameter enabled on your account then you can begin work on creating and using the consolidation account.
...
The TRVc register must be exported for each company that you would like to consolidate. That means you must log into an account associated with the company you want to consolidate in HansaWorld and perform the TRVc register export. When you are saving the register make sure to name it accordingly - "*company_code*_*register_name*.txt" examples:
1_TRVc.txt
...
,
1_TRVc-March.txt
1_2016-TRVc.txt
where 1 is the company code.
You must make sure the company code is at the beginning of the file and the number is the same as the company code you wish to import the data for. Make sure the number is seperated from the register name by an underscore symbol "_".
When you have all of the required registers you can then upload them into the flex.bi source files and import them. If everything is done correctly you should be able to see the Companies dimension in the Financials cube. If everything has been done correctly then the end result should look similar to this :
...