They are held within the database tables of your planning application.
For cell text the tables are >
HSP_CELL_NOTE & HSP_CELL_NOTE_ITEM
For supporting detail the tables are >
HSP_COLUMN_DETAIL, HSP_OBJECT & HSP_COLUMN_DETAIL_ITEM
Table name: HSP_COLUMN_DETAIL
Description: One row per line item detail will exist in this table. This table stores unique numbers which relate to the dimension names and also the detail_id which is a value to find the specific cell detail.
Table name: HSP_OBJECT
Description: This table is used to translate DIM1 – DIM22 ID’s into member names. Object_name is the member name. If the member has an alias the HSP_ALIAS table must be queried.
Table name: HSP_COLUMN_DETAIL_ITEM
Description: One row per line item detail will exist in this table. This table stores unique numbers which relate to the dimension names and also the detail_id which is a value to find the specific cell detail.
For cell text the tables are >
HSP_CELL_NOTE & HSP_CELL_NOTE_ITEM
For supporting detail the tables are >
HSP_COLUMN_DETAIL, HSP_OBJECT & HSP_COLUMN_DETAIL_ITEM
Table name: HSP_COLUMN_DETAIL
Description: One row per line item detail will exist in this table. This table stores unique numbers which relate to the dimension names and also the detail_id which is a value to find the specific cell detail.
Table name: HSP_OBJECT
Description: This table is used to translate DIM1 – DIM22 ID’s into member names. Object_name is the member name. If the member has an alias the HSP_ALIAS table must be queried.
Table name: HSP_COLUMN_DETAIL_ITEM
Description: One row per line item detail will exist in this table. This table stores unique numbers which relate to the dimension names and also the detail_id which is a value to find the specific cell detail.
No comments:
Post a Comment