Analytics Software

I have found much information on this forum and through Google, however I am short on a few tables.
To Start I'd like to see if we can get a description on the Metadata tables.
Then I would like to work on the Columns, defining the columns and the values

ie:
EUL5_ACCESS_PRIVS.AP_ELEMENT_STATE - What does this column do, what do the values mean?
EUL5_EUL_USERS.EU_SECURITY_MODEL - What does this column do, what do the values mean?



So here is what I have identified (to the best of my knowledge), please feel free to adjust them as you see fit.


EUL User and privilege information

* EUL5_EUL_USERS Master Table for EUL Users,
* EUL5_ACCESS_PRIVS Handles the User Privileges for Documents, Business Areas, Administration, Desktop Plus


EUL metadata tables (Business Areas, Folders, Folder Joins, Conditions, Summaries, ........)

* EUL5_BA_OBJ_LINKS Contains joins between Business Areas and Folders (objects), sort order
* EUL5_BAS Master Table for Business Areas, Names, Descriptions, Keys, etc
* EUL5_OBJ_DEPS
* EUL5_OBJ_JOIN_USGS Contains joins between Folders (objects) within the Business Areas ?
* EUL5_OBJS Master Table for Folders contained in the Business Areas
* EUL5_EXPRESSIONS Field (item) information related to Folders (objects) ?
* EUL5_EXP_DEPS
* EUL5_KEY_CONS Contains information on Folder (objects) Joins ?
* EUL5_VERSIONS Contains EUL Version information


Tables containing information in regard to Custom Functions added to the EUL

* EUL5_FUNCTIONS
* EUL5_FUN_ARGUMENTS
* EUL5_FUN_CTGS
* EUL5_FUN_FC_LINKS


Tables that contain information related to Scheduled Reports

* EUL5_BATCH_PARAMS
* EUL5_BATCH_QUERIES
* EUL5_BATCH_REPORTS
* EUL5_BATCH_SHEETS
* EUL5_BR_RUNS Run Information about Batch Reports ?
* EUL5_BQ_DEPS
* EUL5_BQ_TABLES


Summary Information

* EUL5_SUMMARY_OBJS
* EUL5_SUMO_EXP_USGS
* EUL5_SUM_BITMAPS
* EUL5_SUM_RFSH_SETS


Workbook Information

* EUL5_DOCUMENTS Master Table for Documents, names, descriptions, etc. (no worksheet names)
* EUL5_DOC_FOLDERS ?
* EUL5_QPP_STATS Contains Report statistics on run times and users at the worksheet level
* EUL5_ELEM_XREFS ? Parameters ?
* EUL5_PLAN_TABLE Used by Desktop/Plus for explain plan ?
* EUL5_WORKSHEET_SQL SQL used by open workbooks?


LOV's - Item Classes

* EUL5_DOMAINS Contains Item Class'
* EUL5_BA_OBJ_LINKS Contains joins between Business Areas and Folders (objects), sort order
* EUL5_BAS Master Table for Business Areas, Names, Descriptions, Keys, etc
* EUL5_OBJS Master Table for Folders contained in the Business Areas
* EUL5_EXPRESSIONS Field (item) information related to Folders (objects) ?

SELECT bas.ba_name "Business Area",
obj.obj_name "Folder that Uses Item Class",
ex.it_heading "Item that uses LOV",
dm.dom_name "Item LOV"
FROM eul5_expressions ex,
eul5_domains dm,
eul5_objs obj,
eul5_ba_obj_links bal,
eul5_bas bas
WHERE ex.it_dom_id = dm.dom_id
AND obj.obj_id = ex.it_obj_id
AND bal.bol_obj_id = obj.obj_id
AND bas.ba_id = bal.bol_ba_id


Tables relating to Hierarchies?

* EUL5_HIERARCHIES
* EUL5_DBH_NODES
* EUL5_HI_NODES
* EUL5_HI_SEGMENTS
* EUL5_IHS_FK_LINKS


Tables ?

* EUL5_ASMP_CONS ?
* EUL5_ASMP_LOGS ?
* EUL5_ASM_POLICIES ?
* EUL5_IG_EXP_LINKS
* EUL5_APP_PARAMS ?
* EUL5_FREQ_UNITS
* EUL5_GATEWAYS
* EUL5_SEGMENTS ? Folder queries, summary queries ?
* EUL5_SEQUENCES Sequence used for ?
* EUL5_SQ_CRRLTNS
* EUL5_SUB_QUERIES Sub Queries for WorkBooks?

Edited by: Michael Nicholas on Jun 4, 2010 12:13 PM