Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

DATASTORE

Optional parameter in PARAM = optional in PARAM if DS (Datastore) is used as SOURCE in template  

Access Datastore Parameters from Template Design by selecting Parameters > Datastore > PARAMETERS > Populate procedure parameters.

DATASTORE

Below is a list of available parameters:

Parameter (col A in PARAM)

Value in col C (example)

Occurrence in PARAM sheet

Comment

~LEDGERSUM

TRUE/FALSE

1

Summarize the ledger amounts. Default = TRUE.

~REPORTCURR

CURR ID

i.e SEK

1

View the report in a specific currency. All values in the report will be recalculated in the selected currency.

~CONTRANS

TRUE/FALSE

1

Include consolidation transactions.

~ELIMINATE

TRUE/FALSE

1

Eliminate intercompany transactions. Default = FALSE. If TRUE, then all records marked as 1 (elimination records between legal entity and intercompany) will be removed from the temp-table before Bizview starts running the queries to populate the report.

~GETCHILD

<OBJECT>:<PARENT OBJECT ATTRIBUTE>

i.e LE:LEPC

1

Include child objects in the query. The procedure populating the report with data will summarize the amounts including all children, which will fasten the report processing time, since Bizview does not need to do the calculations.

A parent-child dimension structure needs to be defined in Bizview for the specific object. First, an attribute with type Parent object must be set up and connected to the particular object. Thereafter, the structure of parent-child within the same object must be defined in the object values GUI.

~SHOWCHILD

TRUE/FALSE

1

Show child objects in report. Should be used in combination with GETCHILD. If set to TRUE, each child object will be presented with values. If set to FALSE, then the values will be summarized for all children.

~DETAIL_LOG

TRUE/FALSE

1

Activate detailed logging.

~CURRPERIOD

PERIOD

i.e 201401

1

Period to use when calculating currency rates.

Applicable to, for example, balance sheets when all values should be calculated with currency rates for one specific period. Only applicable to currency rates connected to a currency type with calculation method "Specific period currency rates".

~EXEC_MODE

TRANS_DATA

1

Execution mode.

Ledgertrans will be used if EXEC_MODE=TRANS_DATA.

If EXEC_MODE = TRANS_DATA, then this will be run before ledgersum.

~FINPLANDATA

Available from Bizview 6.0

TRUE/FALSE

 

1

 

Include financial planning data from Bizview.

~ICFILTER

Available from Bizview 6.0

<object value>

1

 

Intercompany filter for elimination.

Published:

DATASTORE

Optional parameter in PARAM = optional in PARAM if DS (Datastore) is used as SOURCE in template  

Access Datastore Parameters from Template Design by selecting Parameters > Datastore > PARAMETERS > Populate procedure parameters.

DATASTORE

Below is a list of available parameters:

Parameter (col A in PARAM)

Value in col C (example)

Occurrence in PARAM sheet

Comment

~LEDGERSUM

TRUE/FALSE

1

Summarize the ledger amounts. Default = TRUE.

~REPORTCURR

CURR ID

i.e SEK

1

View the report in a specific currency. All values in the report will be recalculated in the selected currency.

~CONTRANS

TRUE/FALSE

1

Include consolidation transactions.

~ELIMINATE

TRUE/FALSE

1

Eliminate intercompany transactions. Default = FALSE. If TRUE, then all records marked as 1 (elimination records between legal entity and intercompany) will be removed from the temp-table before Bizview starts running the queries to populate the report.

~GETCHILD

<OBJECT>:<PARENT OBJECT ATTRIBUTE>

i.e LE:LEPC

1

Include child objects in the query. The procedure populating the report with data will summarize the amounts including all children, which will fasten the report processing time, since Bizview does not need to do the calculations.

A parent-child dimension structure needs to be defined in Bizview for the specific object. First, an attribute with type Parent object must be set up and connected to the particular object. Thereafter, the structure of parent-child within the same object must be defined in the object values GUI.

~SHOWCHILD

TRUE/FALSE

1

Show child objects in report. Should be used in combination with GETCHILD. If set to TRUE, each child object will be presented with values. If set to FALSE, then the values will be summarized for all children.

~DETAIL_LOG

TRUE/FALSE

1

Activate detailed logging.

~CURRPERIOD

PERIOD

i.e 201401

1

Period to use when calculating currency rates.

Applicable to, for example, balance sheets when all values should be calculated with currency rates for one specific period. Only applicable to currency rates connected to a currency type with calculation method "Specific period currency rates".

~EXEC_MODE

TRANS_DATA

1

Execution mode.

Ledgertrans will be used if EXEC_MODE=TRANS_DATA.

If EXEC_MODE = TRANS_DATA, then this will be run before ledgersum.

~FINPLANDATA

Available from Bizview 6.0

TRUE/FALSE

 

1

 

Include financial planning data from Bizview.

~ICFILTER

Available from Bizview 6.0

<object value>

1

 

Intercompany filter for elimination.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk