[Home] [Help] [Dependency Information]
Object Name: | ZPB_OS_ATTRIBUTES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view returns a list of attributes for a particular dimension or all dimensions of a business area. Among the attribute information that returned is the olap dimension table for the attribute's domain dimension and the column name in that table that stores the attribute value of this attribute for each dimension member. Before executing this query the following two environment variables should be initialized:sys_context('ZPB_CONTEXT', 'business_area_id') and userenv('Lang').
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOMAIN_DIMENSION | VARCHAR2 | (240) | Dimension name of attribute's domain dimension | |
ATTRIBUTE_ID | NUMBER | Yes | Primary key of zpb_attributes | |
ATTRIBUTE_NAME | VARCHAR2 | (240) | Attribute name | |
ATTRIBUTE_TYPE | VARCHAR2 | (30) | Types include : 'DIMENSION_ATTRIBUTE', 'VALUE_NAME_ATTRIBUTE', and 'END_DATE_ATTRIBUTE' | |
ATTRIBUTE_LABEL | VARCHAR2 | (240) | Attribute Label | |
OLAP_DIM_TABLE_NAME | VARCHAR2 | (60) | Name of the olap dimension table of attribute's domain dimension | |
OLAP_DIM_TABLE_COLUMN_NAME | VARCHAR2 | (60) | Yes | Name of the column that holds the values of this attribute in the attribute's domain dimension's olap dimension table |
RANGE_DIMENSION | VARCHAR2 | (240) | Dimension name of attribute's range dimension |
Cut, paste (and edit) the following text to query this object:
SELECT DOMAIN_DIMENSION
, ATTRIBUTE_ID
, ATTRIBUTE_NAME
, ATTRIBUTE_TYPE
, ATTRIBUTE_LABEL
, OLAP_DIM_TABLE_NAME
, OLAP_DIM_TABLE_COLUMN_NAME
, RANGE_DIMENSION
FROM APPS.ZPB_OS_ATTRIBUTES_V;
APPS.ZPB_OS_ATTRIBUTES_V is not referenced by any database object
|
|
|