In this blog, I would be talking about what happens in a relational schema when we create a Hyperion Planning application. This would lay the ground work for us since I will be covering things like how text values are stored in Hyperion Planning and how to update them manually and where the application metadata resides and so on in my later blogs…
The below snapshot shows me creating a data source for my planning application.
I now run a select query to see the list of all tables that are present in the HYP_PLAN_APP1 schema. The output of this query is as shown in the below snapshot.
Observe that there are no tables at the moment present in this schema.
The next couple of snapshots show me creating a Hyperion Planning application using HYP_PLAN_APP1 as a data source.
Once the application has been created successfully, I again run a query on the HYP_PLAN_APP1 schema to list out the count of the number of tables that are present in the schema. This is shown in the below snapshot.
There are some 142 tables that have been created when the Planning application was created.
The sample list of table names that has been created is as shown in the below snapshot.
As an anecdote, we once created two Planning applications that pointed to the same relational schema and things got interesting in that we manually had to delete the schemas and create the applications from start.
The entire list of tables that are created is as shown below: -
The below snapshot shows me creating a data source for my planning application.
I now run a select query to see the list of all tables that are present in the HYP_PLAN_APP1 schema. The output of this query is as shown in the below snapshot.
Observe that there are no tables at the moment present in this schema.
The next couple of snapshots show me creating a Hyperion Planning application using HYP_PLAN_APP1 as a data source.
The sample list of table names that has been created is as shown in the below snapshot.
The entire list of tables that are created is as shown below: -
- HSP_OBJECT
- HSP_UNIQUE_NAMES
- HSP_OBJECT_TYPE
- HSP_PLAN_TYPE
- HSP_PENDING_XACTS
- HSP_PENDING_DELS
- HSP_DIMENSION
- HSP_CURRENCY
- HSP_SYSTEMCFG
- HSP_ENUMERATION
- HSP_MEMBER
- HSP_ALIAS
- HSP_ATTRIBUTE_DIM
- HSP_ATTRIBUTE_MEMBER
- HSP_MEMBER_TO_ATTRIBUTE
- HSP_TIME_PERIOD
- HSP_CALENDAR
- HSP_USERS
- HSP_GROUP
- HSP_USERSINGROUP
- HSP_ACCESS_CONTROL
- HSP_USER_PREFS
- HSP_LOCK
- HSP_ACCOUNT
- HSP_ENTITY
- HSP_FX_TABLE
- HSP_FX_RATES
- HSP_FX_RATE_VALUES
- HSP_SCENARIO
- HSP_VERSION
- HSP_CUBES
- HSP_ACCOUNT_DESC
- HSP_STRINGS
- HSP_FORM
- HSP_FORM_LAYOUT
- HSP_FORMOBJ_DEF
- HSP_FORMOBJ_DEF_MBR
- HSP_FORM_CALCS
- HSP_PLANNING_UNIT
- HSP_PLANNING_UNIT_LOG
- HSP_ANNOTATION
- HSP_ACTION
- HSP_PM_STATES
- HSP_PM_ACTIONS
- HSP_PM_EFFECTS
- HSP_PM_RULE_LIST
- HSP_PM_RULES
- HSP_LINKS
- HSP_COLUMN_DETAIL
- HSP_COLUMN_DETAIL_ITEM
- HSP_MRU_MEMBERS
- HSP_PRINT_OPTS
- HSP_AUDIT_RECORDS
- HSP_AUDIT_OPTIONS
- HSP_CELL_NOTE
- HSP_CELL_NOTE_ITEM
- HSP_TASK
- HSP_USER_TASK
- HSP_CHECKOUTS
- HSP_WF_PREFS
- HSP_FORM_ATTRIBUTES
- HSP_USER_VARIABLE
- HSP_USER_VARIABLE_VALUE
- HSP_ACTIVITY_LEASE
- HSP_WF_SET_SCREEN
- HSP_ENUMERATION_ENTRY
- HSP_ENUM_EVALUATION
- HSP_MENU_ITEM
- HSP_FORM_MENUS
- HSP_FORM_VARIABLES
- HSP_UDA
- HSP_MEMBER_TO_UDA
- HSP_MEMBER_FORMULA
- HSP_DRIVER_MEMBER
- HSP_FX_VALUES
- HSP_SPREAD_PATTERN
- HSP_COMPOSITE_FORM
- HSP_COMPOSITE_BLOCK
- HSP_COMPOSITE_FORM_PANE
- HSP_COMPOSITE_PANE_DIM
- HSP_TEXT_CELL_VALUE
- HSP_JOB_STATUS
- HSP_PM_DIMENSION
- HSP_PM_PRIMARY_MEMBER
- HSP_PM_SECONDARY_MEMBER
- HSP_PM_MEMBER_OWNER
- HSP_PM_SVDIM_BINDING
- HSP_FORM_DV_RULE
- HSP_FORM_DV_CONDITION
- HSP_MBR_SELECTION
- HSP_MBR_SELECTION_ITEM
- HSP_ESSBASE_SERVER
- HSP_CUBE_LINK
- HSP_CUBE_LINK_DIMMAPS
- HSP_FORM_DV_PM_RULE
- HSP_FORM_DV_USER_IN_PM_RULE
- HSP_PM_MEMBER
- HSP_PM_OUT_OF_OFFICE
- HSP_USER_DIM_DISPLAY_PREFS
- HSP_LINE_ITEM_MEMBER
- HSP_ACTIVE_SERVERS
- HSP_ADHOC_OPTS
- HSP_FORM_CONTENT
- HSP_ESSBASE_CUBE
- HSP_DP_DIMENSION
- HSP_DP_MEMBER
- HSP_DP_TYPE_FORM
- HSP_DP_TYPE_QUERY
- HSP_DP_TYPE_QUERY_MEMBER
- HSP_DP_TYPE_QUESTION
- HSP_OBJECT_NOTE
- HSP_DP_SHARING_ENTITIES
- HSP_DP_REVIEWER
- HSP_DP_TYPE_MAPPING
- HSP_EXT_XACT
- HSP_EXT_XACT_DETAIL
- HSP_GRID_STATS
- HSP_DP_SVBR_BINDING
- HSP_APPLICATION_CONTENT
- HSP_MEMBER_ON_FLY_DETAIL
- HSP_MEMBER_ON_FLY_USAGE
- HSP_DP_ATTRIBUTE
- HSP_DP_TYPE_ATTRIBUTE
- HSP_DP_MEMBER_ATTRIBUTE
- HSP_HEALTHCHECK_STATUS
- HSP_HEALTHCHECK_CRITERIA
- HSP_OLU_STATUS
- HSP_OLU_STATUS_REC
- HSP_PARTITION
- HSP_PARTITION_AREA
- HSP_BUSINESS_METRICS
- HSP_CALC_MGR_RULES
- HSP_CALC_MGR_RULESETS
- HSP_CALC_MGR_VARIABLES
- HSP_CALC_MGR_USER_VAR_PPT
- HSP_FORM_FORMAT_OBJECTS
- HSP_ANNOUNCEMENTS
- HSP_OBJECT_MOBILE_ACCESS
- HSP_HISTORICAL_JOB_STATUS
- HSP_JOB
- HSP_REPORT_TEMPLATE_DEF
- HSP_REPORT_TEMPLATE
No comments:
Post a Comment