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 " - "

      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.

Image Removed

 Image Added

...

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

                 Image Added

                Option 2 :  Include object filter in Calculated member f account Group

This example will show you how to only return the data of accounts that are connected to a certain object. In this example the values of the 3 Random Accounts created in the previous example will be filtered and aggregated into a single member AUDIO - Accounts. This member will return the account values that are connected to the object AUDIO - Audio Products.

...

You should see the following result:

...

...