Register Login

Differences between Data Foundation LoV and Business Layer LoV

Updated May 18, 2018

Data Foundation LoV vs Business Layer LoV

Data Foundation LoV(List of Values)

The data foundation LoV can be based on:

  • Static values
  • Custom SQL

The table below describes which objects support Data FoundationLoV:

  List of Values Based on Bussiness Layer Object Static List of Value Objects List of Values Based on Custom SQL Object
Data Foundation N/A Supported Supported
  • Join
N/A Supported Supported
  • Calculated column
N/A Supported Supported
  • Derived table
N/A Supported Supported
  • Parameter
N/A Supported Supported

Business Layer LoV(List of Values)

The business layer LoV can be based on:

  • Static values
  • Custom SQL
  • Business Objects

The table below describes which objects support Rational Business LoV:

  List of Values Based on Bussiness Layer Object Static List of Value Objects List of Values Based on Custom SQL Object
Rational Business Layer Supported Supported Supported
  • Dimension
Supported Supported Supported
  • Attribute
Supported Supported Supported
  • Measure
Supported Supported Supported
  • Parameter
Supported Supported Supported
  • Filter
Supported Supported Supported
  • List of Values
N/A N/A N/A

The table below describes which objects support Rational Business LoV:

  List of Values Based on Bussiness Layer Object Static List of Value Objects List of Values Based on Custom SQL Object
Multidimensional Business Layer Supported Supported N/A
  • Dimension
Supported Supported N/A
  • Attribute
Supported Supported N/A
  • Measure
Supported Supported N/A
  • Named set
N/A N/A N/A
  • Calculated Member
N/A N/A N/A
  • Analysis Dimension
N/A N/A N/A
  • Hierarchy
Supported Supported N/A
  • Level
Supported Supported N/A


×