Widget Connector | ||
---|---|---|
|
To re-create your profit & loss report in flex.bi you must follow these instructions.
1. Finding out what your HansaWorld Profit & Loss report contains
To first thing you need to do is find out what your Profit & Loss report is made out of. To do that you have to look at the Report Settings in HansaWorld. To do that:
...
The symbol ":" between two account numbers Interval of Accounts or Account Groups
The example shown in the image above :Info Accounts (100:199) means that it is interval of the accounts from 100 to 199
(100, 101, 102, 103, ... , 198, 199) are included in this group
- but the " + " defines Sum of Accounts or Account Groups , but it can be also " - "
Info |
---|
Account group (10 + 20) means the Sum of Account Groups created before, means that lines 10 + 20 are included in this group). |
...
- As well as these can be Sum of Accounts
Important : In Hansaworld HansaWorld reports lines can not be defined by Object limitations - In Flex.bi can
2. Re-creating the account groups in flex.bi
To recreate your account groups in flex.bi you will need to create Calculated members that aggregate the accounts you need into groups. First you have to pick a group you want to re-create, always try to work with one group at a time to make this task easier. By default you will have the groups Asset, Liability, Equity, Income and Expense created for you already. This example will contain several methods of aggregating accounts into groups:
...
Now you will have to create a calculated member, calculated members are explained in detail here.
Create the following calculated member by entering the accounts by clicking on the bookmarks and connecting them with the ":" to create an interval.
Info |
---|
|
...
You should see the following result.
2. Defining SUM of Accounts or Account Groups
...
Option 3 : Formula : member+member+member
3. Limiting results by Object
Option 1 : Object dimension in pages
...
You should see the following result:
...
Info |
---|
You can also include those in Aggregations or SUM. You can limit also by any other dimension existing - dividing by "," . For example : Account 211 , Object Audio , Object Other etc |
...