Versions Compared

Version Old Version 6 New Version Current
Changes made by

Nadica Gaber (Unlicensed)

Matija Lukic (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

From here, the administrator can set /change specification of the dimension settings defaults on the source system level.

View

When you choose to manage the Source system defaults, on the left side you can see the available source systems, the list of dimensions will be in the middle and Source System Settings on the right side.default setting for each dimension in the selected Source System.
Source System Defaults are used for the default configuration of reports (e.g. Point of View, Comments).
Only users with Report Admin permission can edit Source System defaults. 

View

Select 'Source System Defaults' from the menu under 'Settings' in the upper menu. In the panel which will appear:

  • the left side shows the available Source Systems and the selected one
  • the middle area lists the dimensions inside the selected Source System and shows their default settings when the Source System is set as Primary Source System in the report and when the Source System is used in a report but is not set as primary
  • the right side show default settings of the selected Source System concerning Point of Views, Comments and other settings

CONTENT

 

Table of Contents

 Image Added

Image Removed

Default Point of View Settings

Here, you can choose which dimensions will be used as filters. If you cick on the edit Button, the list of dimensions of the source systems will be displayed. After choosing the POV dimensions which can be done by clicking on the Edit Button, they will be grayed out (Dimension and Initial Value when Primary column) and will be shown on top of the list according to the POV order.

Image Removed

Edit dimension

On double click on any of the columns in the Default Point of View section, the edit popup will appear.  Here, you can choose the Dimension Hierarchy Setting and the Initial Value.

Image Removed

Comments

The

Set Initial Values

Initial Values determine the default member selected in the OLAP cube for each dimension, i.e. the dimension member for which to show data in the report. This setting applies even when the dimension is not used as filter in Point of View Bar.
Custom settings, valid for a particular report, can be set through the Settings Panel when editing the report.

  • Initial Value When Primary - determines the dimension member selected by default in reports using the current Source System as primary Source System.
  • Initial Value When NOT Primary -  determines the dimension member selected by default in reports using some list defined on the current Source System, but using a different Source System as primary.

To edit the Initial Value when Primary or the Initial Value when NOT primary, double click on the relative cell in the central grid.

Image Added

  • The default Initial Value is 'Central'. When this option is selected, the report will keep the selection as in the report the user was viewing before navigating to the current report.
    e.g. the user was viewing a report showing data for 2014, then moves to another report, this new report will automatically show data for 2014.
  • When the Source System is not Primary, the default Initial Value is 'Follow Primary'. When this option is selected, if the dimension exists also in the primary Source System, the system will consider the member selected in the Primary Source System and automatically select the matching member (if any) in the current Source System.  
  • When a dimension is selected as Default Point of View in the right panel, Initial Values can't be edited from the central grid but only from the right panel.

Default Point of View Settings

Expanding 'Default Point of View Settings' in the right panel you can configure how the Point of View Bar will appear by default when a report uses the current Source System as Primary Source System.
Custom settings, valid for a particular report, can be set through the Settings Panel when editing the report.

Image Added

Set the Dimensions to Appear in Point of View Bar

  • Click on 'Set Dimensions' inside the 'Default Point of View Settings' section of the right panel
  • A popup will appear allowing you to select the dimensions to appear as filters in the Point of View Bar

Adding a new dimension it will get default values both for Hierarchy and Initial Value. They will appear in light grey. View the following section on how to set them. 

Image Added

Set the Initial Value and Available Hierarchy

  • Double click on a dimension inside the 'Default Point of View Settings' section 
  • The popup to configure how the dimension's combo will work in the Point of View Bar will appear.

Image Added

Dimension Hierarchy determines the options to appear appear in dimension's dropdown inside the Point of View Bar: 

  • Full Hierarchy - all members of the dimension will be available
  • Descendants of - only the descendants of a selected member will be available. You can choose whether to show the member itself (Include Top) or only its descendants (Exclude Top)
  • Use List - a Shared List will be used. Only the list members will be available. Only List defined on the dimension can be selected.

If a dimension is flat, e.g. year, the 'Dimension Hierarchy' section will not appear.

Initial Value determines the member selected by default in the dimension's dropdown inside the Point of View Bar: 

  • Do not specify ('Central') - as the user navigates between reports the dimension member which was selected in the report he comes from will be kept, e.g. if the user was viewing October month in the previous report, moving to the report October will be pre-selected
  • Set to - it is possible to select a specific member or variable (e.g. Current). 

Comments

Expanding 'Comments' section in the right panel you can configure how the Commentary section will work for reports using the current Source System as primary Source System.
Custom settings, valid for a particular report, can be set through the Settings Panel when editing the report.

Set Dimensions to use as Narrative Keys

With this setting, the admin can specify the Dimension(s) used to store the POV comments. If a dimension is chosen, this means that comments will be associated to the dimension’s member selected in the Point of View. e.g. if Year dimension is Narrative Key, comments inserted when '2015' is selected in the Point of View Bar, will not be visible when '2016' is selected. At more general level the Narrative Key determines if the dimension is part of the key for the comments (narratives) created by a user for this report. In case the Dimension is added in the Comment section, these means that the comments are specific for this dimension. If RollUp is checked, the hierarchy of this dimension will be used to create a dependency tree for comments. On the report you will see the comment for the current member of that dimension but you can also see (and even consolidate) the comments of the children of that member. Only . 

When more dimension are set as Narrative Keys, the comments will be associated to the intersection of the selected dimension members.
e.g. Month, Year, Entity are all Narrative Keys. Inserting a comment for October 2015  for USA, the comment will not be visible when China is selected nor when September if selected.

To set the dimensions to use as narrative keys click on 'Set Dimensions' in Comments section of the right panel.

Image Added


Set Roll Up

If RollUp is checked, comments associated to a member of the dimension will be visible inside ‘Subsidiary Comments’ (and can even be consolidated) when a parent member are selected. Only one (hierarchical) dimension can (and should) have the RollUp selection.Image Removed.

Image Added

Annotations

Using the setting 'Show Annotations', the user can determine if annotations are visible in controls by default.
More information about the this setting's options can be found in the Commentary page, under section Annotations.

Other Default Settings

Apart from the PoV settings Point of View and Comments setting and the initial values of dimensions, the user can also maintain the values of a number of common settings that could vary between Source Systems.
Double click on any row to edit the current settings. 

Image RemovedImage Added