Framework:Checks on Client Side

"Checks on the client side" offers the possibility to uncover inconsistencies of the model and data.

Configuration parameters

Coplanner.exe.config

Visibility of "Transport" and "Checks on the client side" in developer mode on the client is configured by ShowTransportEntries.

Open

To open "Checks on the client side" it is necessary to be logged in as Manufacturer, PowerUser or Partner-Mode. You can find the transport in the developer mode accessible via CoPlanner.

Framework, Open Transport

Using this button the following dialog is opened:

Framework, Transport dialog

Model rigidity

These things are checked with the Model rigidity:

Object	Checks
Tables	exist LookUp-Tables Dimensions
Dimensions	exist LookUp-Tables Dimensions MakroOnSave
Subsets	exist base dimension LookUp-Tables Dimensions MakroOnSave
Macros	check exist parameters which where specified in the macro all parameters are specified Syntax SessionKeys of continuation condition
Imports	exist target tables target fields SessionKeys of filters
Row View	exist data object Macros which are used in the mask Skin which is used in the mask info masks detail masks SessionKeys of filters
Input masks	exist data object Macros which are used in the mask Skin which is used in the mask info masks detail masks SessionKeys of filters
CoPlanner Cubes	exist data source warning if no measure is set for "RelevantNullsuppression" for calculated measures

To start a rigidity check select Model rigidity and click 'Start assistent'. A list of all objects is shown. This list is separated in Object Administration and BI-Center. Appropriate objects for the check are selectable and unselectable here. The context menu on the left column offers the possibility to select or unselect all objects. In the below section a search field is available. A click on the number of search results will activate all search results for the export.

Framework, Object list for checks

"Next" will execute the checks on the selected objects.

The result is a list with all inconsistencies. "Finish" will close the assistant.

Data rigidity

Object	Checks
Tables	Check if plan related Tables have invalid IDs Check if plan related Tables have a Plan-ID -2 or -1 Check if quoted LookUp-Tables contain appropriate elements Check if sources from formula generated data rows exist(Only formulas with type Row(Single)) Check if all referred formulas exist Check if source- and target data row belong to the same plan(if plan related) Check if all fields contain their Default-Value as value
Dimensions	Check if dimensions contain recursion and if complications can occur caused by their Parent-ID Check if dimensions contain NULL values where it is prohibited Check if LookUp-Dimensions contain the appropriate values Check if each dimension has the required elements 1 and 2 Check if element name of a dimension is unique(+vs_key if available) Check if dimensions have only one Root-Element and 0 is not used as Element-ID
Subsets	Check if origin elements exist for Subset-Elements
Checks for User Administration	Check if a column contains a NULL value where it is prohibited Check if duplicate objects exist with the same Copsys_id Check if references to removed objects exist

To start a Data rigidity select 'Data rigidity' and click 'Start assistent'.

Framework, Data rigidity

To start a Data rigidity select 'Data rigidity' and click 'Start assistent' Checks are performed by selecting appropriate checks on the left side and click 'Error search' on the right bottom. The check requires - depending on model size - some time. Checks which were unsuccessful get a red representation. A click on a check shows a more detailed result of this check.