Versions Compared

Version Old Version 1 New Version Current
Changes made by

Migration (Unlicensed)

Nadica Gaber (Unlicensed)

Saved on

Key

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

Introduction

A reference pick list is a a list building block that  that can be used to select reference categories. Reference categories are used for variance analysis with the main category of a report. Most reports have a reference pick list. Most reference pick lists contain dimensions like:

  • Year
  • Period
  • Category

CONTENT

Table of Contents

And contain values like:
  • End of Last Year
  • Budget
  • Previous month
  • Previous year
    • Last Month

    etc.

    List Attributes

    Basic

    Example:

    Image Added

    List Attributes

    List Attribute

    Default
    Description

    Available

    Description

    Values

    Empty

    Default

    No

    Empty lines will not be visible, if you set this attribute to yes.

    Custom Description

    Empty

    The custom description overrides the default generated name. You can use either a fixed text or a Dynamic Label Expression

    Order

    Max + 1

    Use the order attribute to reorder the members in the picklist.

    Advanced Attributes

    List Attribute

    Default

    Description

    Reverse Valuation

    No

    OrderUse the order attribute to reorder the rows.1, 2, 3...Max + 1
    Item LabelThe default name of the item is displayed.n/an/a
    Dimension1 ...Dimension nA column for each of the dimension on which the list is created. A member or a variable can be selectedMember or a Variablen/a
    DrillBy assigning a drill list to a row, a drill icon will appear in front of the line in the report. This drill list allows the end-user to drill to that list. If a dimension member of an item is a parent in the dimension hierarchy then the end user can also assign a dynamic drill to an item instead of another list.Empty, PopulatedEmpty
    FormulaBy specifying a formula this line will be calculated.Empty, PopulatedEmpty
    Parent ItemOnly relevant for Lists used in POV and in Value Tree List.Empty, PopulatedEmpty

    Format

    The format attribute will specify the look and feel of the row. This format is not applied to the header of the row, but only to its values.

    		Default, Default_bold, Default_left, ...Default

    Header

    The header format, defines how the row header should be formatted. The available values are identical with the ones used by the "Format" attribute, but applied only on the row header.

    		Default, Default_bold, Default Highlighted Header, ...Default Format
    Insert Data LabelUse this filed to determine whether the item value will be displayed.Relevant for chart reports only.Yes/No No
    WidthDetermines the width of a cloumnEmpty, PopulatedEmpty
    Item TypeDisplayes the Type of the ItemLabel Only, Data, CommantData

    Reverse Sign

    When this attribute is set to yes, the

    Valuation

    sign will be

    reversed. This means negative becomes positive and the other way around. Changing the valuation will influence the variance coloring.

    Reverse Sign

    No

    When this attribute is set to yes, all the reference data will be sign flipped.

    CONTENT

    toc

    flipped.

    		No, YesNo
    VisibleThis value determines whether a item will be visible in the report.Yes/NoYes

    Suppress Value

    This value sets automatic row suppressing, click on the type to see the suppressing options.

    None, SuppressNoData, SuppressZeros,

    SuppressNoDataAndZeros

    		None

    Suppress Variance

    Allows you to set the conditions for not suppressing the Variance, by using a pick list

    SuppressNoBaseOrReference,

    Suppress, NoSuppress, SuppressNoBase,

    SuppressNoReference

    		SuppressNoBaseOrReference
    Redirect ReportUse this field to select an existing report that will be available through a hyperlink.Empty, PopulatedEmpty