Dimension Extract

image_pdfimage_print

A dimension can be extracted from a Jedox OLAP database using the Dimension extract. The extract creates a tree.

Dimensions can be filtered for the following items:

  • Elements
  • Consolidations (i.e., hierarchical relations between elements)
  • Consolidation factors
  • Element types (numeric/string)
  • Attributes

Read attributes

None No attributes are extracted
Default Language Attributes are extracted. If several languages are defined in the database only values of the default language are extracted.
All Languages Attributes are extracted for all languages of the database. The attribute names in the Dimension extract are in the form “<attributeName>@<languageName>” (e.g. “Description@de_DE”)

Query filter on dimensions

A query filter on the dimension allows filtering according to the name of elements and the hierarchy. 

Filter type options

accept

All nodes that fulfill the filter criteria are included in the selection.

deny

All nodes that fulfill the filter criteria are excluded from the selection.

Operator options

equal

Filtering occurs according to the element specified. Example: Austria

inAlphaRange

Alphanumerical values in a particular range are filtered. Example: “[A100,A200]”

inRange

Numerical values in a particular range are filtered. Example: “[1000,2000]”

like

Filters the dimension elements according to regular expressions. Example: “Apr|Feb|Mar” 

subset

Filters the dimension elements according to a global subset for the dimension. If the subset contains variables, values for these variables have to be defined in the filter.

Examples:

  • Elements on level 3()
  • Element level defined by Variable(LevelEnd=2,LevelStart=3)
 
Mode options

Defines a hierarchical filter for the dimension. If not set the default mode “onlyNodes” is applied which returns only the filtered elements independently of the hierarchy. In case of a global subset filter a mode is in general not reasonable.

Mode Example (with selected value “Austria”) Tree view
rootToBases Based on the selected element, this element and the elements above and below are filtered out.
rootToNodes (to top element and the nodes above) Only consolidated elements above the selected elements in the hierarchy are filtered out.
rootToConsolidates Only consolidated elements above the selected element are filtered out.
nodesToBases All bases under this value are filtered, including the parent element.
onlyBases Only the bases are filtered based on the element selected.
onlyNodes Only the selected element is filtered out (nodal point).
onlyRoots Only the element from the highest level of the hierarchy is filtered out based on the selected element.
Example of Query filter on dimensions:

Filter Type

Operator

Value

Mode

accept

equal

Austria

onlyBases

image_pdfimage_print
Was this post helpful?
NoYes (0 rating, 8 votes)
Loading...