Widget Connector | ||
---|---|---|
|
...
To re-create your profit & loss report in flex.bi you must follow these instructions.
...
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
...
Note |
---|
Important : In HansaWorld reports lines can not be defined by Object limitations - In Flex.bi can |
...
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:
...
Navigate to the financials cube in flex.bi and start creating a new report. Place the Account dimension in the Rows section and the Measures in the Columns section. You should see something similar to this.
If you have any questions about this part please read about Basic concepts of Flex.bi and Report Creating Manual.
...
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
...
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 |
...