DATASTORE
- DATASTORE
- EXCLUDE_COLUMNS_DS - Exclude columns in #findata
Feature available from Bizview version - Bizview 5.2
= 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.
Below is a list of available parameters:
Parameter (col A in PARAM) | Value in col C (example) | Occurrence in PARAM sheet | Comment |
---|---|---|---|
TRUE/FALSE | 1 | Summarize the ledger amounts. Default = TRUE. | |
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. | |
TRUE/FALSE | 1 | Include consolidation transactions. | |
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. | |
<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. | |
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. | |
TRUE/FALSE | 1 | Activate detailed logging. | |
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". | |
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. |