Documentation for CXO-Cockpit Reporting Suite 5.0, click for CXO-Cockpit Reporting Suite 4.3 Documentation or check the CXO-Cockpit Website.

List in POV

From CXO Cockpit Reporting Suite Documentation
Jump to: navigation, search

Lists in the Point of View


A POV list is a regular list that

1. Can be used instead of the full or filtered dimensions in the dimension settings of a report

2. Can be multi-dimensional

3. Overrides the initialization or the POV selection of dimensions

4. Uses the Parent Child attributes to show as a hierarchy in the POV ( usually used in Value Tree settings)

5. Can have non-default attributes like Reverse Sign, format with specific scaling, etc.

6. Is filtered by Security when used in the POV

List Selection

All lists that contain the current dimension (listed in column 1 of the report dimension dialog) will be available for selection in the report or template parameters. 
Report Dimensions.png

These can be

a. One dimensional lists

          i. Fixed

          ii. Dynamic

          iii. MDX

       b. Multi-dimensional lists

When a List is multi-dimensional, the list can be used for any of the dimensions that are part of the List definition. However a list can only be used once in the Dimension Settings. In the case of multi-dimensional lists the (Initialization) parameter acts on either the member of the dimension for which the list is entered or the Custom Description of the list item. In both cases if the same member or description occurs multiple times, the first occurrence will be used.
If a POV list is used on a Generic Template with objects that can change the POV, then it will only respond to the dimension to which the list is attached.

The selection from a POV list overrides the Initial Dimension setting and the selection from the POV. This latter makes sense in case of multi-dimensional lists: If a list comprises dimension A and B and this list is attached to dimension A, then the Initial setting or POV selection of dimension B is overridden by the value of dimension B in the list (unless that member is set to @@CUR).

Selections of POV lists in turn are overridden by item-selectors and row / column specifications.

Because a POV list replaces the normal POV selection, @@CUR is not allowed in the POV list for the members of the dimension to which the POV list is attached. For example, we have a list with dimensions A and B. If this list is attached to dimension A (i.e., put in the List column of the Report Dimensions grid), then it is forbidden to have @@CUR for dimension A in any of the items. For dimension B it is permitted, In which case it takes the Initial setting for dimension B and / or the POV selection for dimension B.

Parent Item1.png

Create a Hierarchy

 To make POV lists appear as a custom built hierarchy in the POV, select the  Parent Item attribute in the list definition.

Parent Item.png

Add the List to the Report Definition

 List in POV.png

The new hierarchy for the account is available in the POV bar

POV List.png

List item attributes that will be taken into account for selections from POV lists are:

a. Custom Description

b. Reverse Sign

c. Reverse Valuation (Accounts only)

d. Scale and Precision (from the Format)

Special Considerations

a. POV lists are subject to the same Security Filters as normal dimensional POV hierarchies. Security filtering is applied to all dimensions in the case of multi-dimensional lists.

b. Formula-items are not allowed 

c. Drills are ignored

d. No support for the InitialTop or CentralTop dimension initialization in combination with the specified List

e. Each dimension can only be used in one POV list per report

f. Dependent dimensions are not displayed in the POV

g. The selected item from POV list overrides the central cache for every included dimension

h. Default selected item in the list can be selected in parameter field of the report dimensions

j. The @@CUR is not supported either in primary or dependent lists