Perspective Business Object

The Perspective Business Object is the result of the mapping of the Perspective integration table to the Business Object integration table. The Perspective Business Object integration table is used only by Financial Reporting.

This table shows the properties of the Perspective Business Object integration table and uses these abbreviations:

  • BP: Budgeting & Planning
  • CO: Financial Consolidation
  • FR: Financial Reporting
  • WB: Workforce Budgeting
  • R: Required
  • U: Used but optional
Field Description Type BP CO FR WB
PerspectiveID Related record to the perspective.

The related table is the Perspective table. The related field is the ID field.

 nvarchar R
BusinessObjec tName Name of the business object.

It must correspond to one of the available business objects.

The related table is the BusinessObjectConfiguration table. The related field is the DefaultNameUsage field.

For Financial Reporting, you must use one of these business object names:

  • Analysis 1-5
  • Analysis 7-11
  • Segments 1-3
  • Organizations
 nvarchar R
Exclude Determines whether the dimension of a business object is part of the perspective.

These values are valid:

  • True: The business object is not part of the perspective and its values are read from the FilterRecord field. In the case of a summary record, the aggregated value is retrieved.
  • False: A default value. The business object is part of the perspective. The DefaultRecord field indicates the default record override.
 boolean R
FilterRecordID External ID of a record of the business object that is used when the dimension is excluded.

References the external ID of a record of the referenced business object.

 nvarchar U
DefaultRecordID External ID of a record of the business object that is used as a default element of the corresponding dimension when the dimension is not excluded.

References the external ID of a record of the referenced business object.

 nvarchar U