interrogation référentiel BO

[marion782]

Bonjour,

Quelqu'un connait il bien les tables du référentiel BO?
Je souhaiterais, pour un univers, avoir la liste des indicateurs, leur description, la clause select, la clause where... mais j'ai un peu de mal à trouver les bonnes tables dans le ref alors si quelqu'un peut m'aider...
Merci d'avance

[bastoonet]

Salut !

Voici une astuce qui va te permettre d'éviter d'interroger les tables BO !

Tu peux enregistrer toutes les information relatives à l'univers dans un PDF. Ensuite libre à toi de faire ce que tu veux des informations récupérées.

Donc
1- tu ouvres ton univers BO
2- tu vas dans outils -> options
3- Dans l'onglet impression tu coches les éléments que tu veux (objets, contextes, jointures, tables)
4-tu vas dans Fichier -> imprimer
5-puis tu imprimes en choisisant comme imprimante un générateur de PDF (si tu n'en a pas installe en un)

Voila tu obtiens alors un pdf dans lequel tu peux copier les informations que tu veux.....ce qui est très pratique pour faire des spécification techniques par exemple... ;-)

[marion782]

merci, pour ton astuce, je connaissais déjà. Je cherche plutôt à interroger directement les tables pour un traitement plus facile par la suite.

[bastoonet]

voici le script de création du referentiel BO....si ça peux t'aider..
Le mieux étant de naviguer avec TOAD(ou autre) pour voir le contenu des tables...

Création du domaine sécurité en cours...
create table OBJ_M_ACTOR (M_ACTOR_N_ID NUMBER(10) not null, M_ACTOR_N_TYPE NUMBER(10) not null, M_ACTOR_N_LEVEL NUMBER(10) not null, M_ACTOR_C_NAME VARCHAR2(70) not null, M_ACTOR_C_PASSWORD VARCHAR2(70), M_ACTOR_N_AUTID NUMBER(10) not null, M_ACTOR_N_LAD NUMBER(10) not null, M_ACTOR_N_LAT NUMBER(10) not null, M_ACTOR_N_STATUS NUMBER(10) not null, M_ACTOR_N_ENDING NUMBER(10), M_ACTOR_N_CNTDOWN NUMBER(10))
create table OBJ_M_DOCCST (M_DOCC_N_DOCLINKID NUMBER(10) not null, M_DOCC_C_FLAGS VARCHAR2(10) not null, M_DOCC_N_LAD NUMBER(10) not null, M_DOCC_N_LAT NUMBER(10) not null)
create table OBJ_M_GENPAR (M_GENPAR_N_ID NUMBER(10) not null, M_GENPAR_N_APPLID NUMBER(10) not null, M_GENPAR_N_USERID NUMBER(10) not null, M_GENPAR_N_TYPE NUMBER(10) , M_GENPAR_N_VALUE NUMBER(10) not null, M_GENPAR_C_LABEL VARCHAR2(254) )
create table OBJ_M_MAGICID (M_MAGIC_N_ID NUMBER(10) not null, M_MAGIC_C_NAME VARCHAR2(35) not null)
create table OBJ_M_RESLINK (M_RES_N_ID NUMBER(10) not null, M_RES_N_ACTLINKID NUMBER(10) not null, M_RES_N_RESID NUMBER(10) not null, M_RES_N_RESTYPE NUMBER(10) not null, M_RES_N_STATUS NUMBER(10) not null, M_RES_N_INFO NUMBER(10), M_RES_N_LAD NUMBER(10) not null, M_RES_N_LAT NUMBER(10) not null)
create table OBJ_M_UNIVCST (M_UNIC_N_UNILINKID NUMBER(10) not null, M_UNIC_C_LONGNAME VARCHAR2(35) not null, M_UNIC_N_CNTID NUMBER(10) not null, M_UNIC_N_MAXLINE NUMBER(10) not null, M_UNIC_N_MAXTIME NUMBER(10) not null, M_UNIC_N_WARNTIME NUMBER(10) not null, M_UNIC_N_ITEMLEN NUMBER(10) not null, M_UNIC_C_FLAGS VARCHAR2(20) not null, M_UNIC_N_HELPSLCID NUMBER(10) not null, M_UNIC_N_LAD NUMBER(10) not null, M_UNIC_N_LAT NUMBER(10) not null)
create table OBJ_M_UNIVSLC (M_UNIS_N_ID NUMBER(10) not null, M_UNIS_N_BLKID NUMBER(10) not null, M_UNIS_C_NAME VARCHAR2(35) not null, M_UNIS_C_BULK VARCHAR2(254) not null)
create table OBJ_M_ACTORDOC (M_ACTDC_N_ACTORID NUMBER(10) not null, M_ACTDC_N_DOCID NUMBER(10) not null)
create table OBJ_M_DOCUMENTS (M_DOC_N_ID NUMBER(10) not null, M_DOC_C_NAME VARCHAR2(254) not null, M_DOC_N_SIZE NUMBER(10) not null, M_DOC_N_REPOID NUMBER(10) not null, M_DOC_N_DATE NUMBER(10) not null, M_DOC_N_USERID NUMBER(10) not null, M_DOC_N_TYPE NUMBER(10) not null, M_DOC_N_PERSISTENT NUMBER(10) not null, M_DOC_N_FORMAT NUMBER(10) not null, M_DOC_C_FLAGS VARCHAR2(10) not null, M_DOC_N_HELPSLCID NUMBER(10), M_DOC_N_LAD NUMBER(10) not null, M_DOC_N_LAT NUMBER(10) not null)
create table OBJ_M_UNIVERSES (M_UNI_N_ID NUMBER(10) not null, M_UNI_N_REPOID NUMBER(10) not null, M_UNI_C_FILENAME VARCHAR2(14) not null, M_UNI_C_LONGNAME VARCHAR2(35) not null, M_UNI_N_REVISION NUMBER(10) not null, M_UNI_N_LUT NUMBER(10) not null, M_UNI_N_LOV NUMBER(10) not null, M_UNI_N_HELPSLCID NUMBER(10) not null, M_UNI_N_CNTID NUMBER(10) not null, M_UNI_N_MAXLINE NUMBER(10) not null, M_UNI_N_MAXTIME NUMBER(10) not null, M_UNI_N_WARNTIME NUMBER(10) not null, M_UNI_N_ITEMLENGTH NUMBER(10) not null, M_UNI_C_FLAGS VARCHAR2(20) not null, M_UNI_N_LOCKER NUMBER(10) not null, M_UNI_N_LAD NUMBER(10) not null, M_UNI_N_LAT NUMBER(10) not null)
create table OBJ_M_ACTORLINK (M_ACTL_N_ID NUMBER(10) not null, M_ACTL_N_ACTORID NUMBER(10) not null, M_ACTL_N_ACTORTYPE NUMBER(10) not null, M_ACTL_N_STATUS NUMBER(10) not null, M_ACTL_N_FATLINKID NUMBER(10) not null, M_ACTL_N_INFO NUMBER(10) not null, M_ACTL_N_LAD NUMBER(10) not null, M_ACTL_N_LAT NUMBER(10) not null)
create table OBJ_M_TIMESTAMP (M_TMS_N_ID NUMBER(10) not null, M_TMS_N_ENTITYTYPE NUMBER(10) not null, M_TMS_N_ENTITYID NUMBER(10) not null, M_TMS_N_BEGINTIME NUMBER(10), M_TMS_N_ENDTIME NUMBER(10), M_TMS_N_REPVALUE NUMBER(10) not null, M_TMS_N_REPUNIT NUMBER(10) not null, M_TMS_N_DURREPVAL NUMBER(10) not null, M_TMS_N_DURREPUNIT NUMBER(10) not null, M_TMS_N_OFFREPVAL NUMBER(10) not null, M_TMS_N_OFFREPUNIT NUMBER(10) not null, M_TMS_N_LAD NUMBER(10) not null, M_TMS_N_LAT NUMBER(10) not null)
create table OBJ_M_UNIVDBCST (M_UNID_N_ID NUMBER(10) not null, M_UNID_N_UNILINKID NUMBER(10) not null, M_UNID_N_TYPE NUMBER(10) not null, M_UNID_N_ITEMSRCID NUMBER(10) not null, M_UNID_C_ITEMSRC VARCHAR2(254) not null, M_UNID_N_ITEMDSTID NUMBER(10) not null, M_UNID_C_ITEMDST VARCHAR2(254) not null, M_UNID_N_LAD NUMBER(10) not null, M_UNID_N_LAT NUMBER(10) not null)
create table OBJ_M_CHANNEL (M_CHNL_N_ID NUMBER(10), M_CHNL_C_NAME VARCHAR(254), M_CHNL_C_COMMENT VARCHAR(254), M_ACTOR_N_ID NUMBER(10), M_CHNL_N_LAD NUMBER(10), M_DASACTOR_N_ID NUMBER(10), M_CHNL_N_CDF_VER NUMBER(10) )
create table OBJ_M_CONNECTION (M_CNTN_N_ID NUMBER(10) not null, M_CNTN_C_NAME VARCHAR2(35) not null, M_CNTN_N_TYPE NUMBER(10) not null, M_CNTN_C_NETNAME VARCHAR(35) not null, M_CNTN_C_RDBMSNAME VARCHAR2(35) not null, M_CNTN_N_CHARSET NUMBER(10) not null, M_CNTN_N_LAD NUMBER(10) not null, M_CNTN_N_LAT NUMBER(10) not null)
create table DS_USER_LIST(DOCUMENT_ID NUMBER(10) not null,USER_ID NUMBER(10) not null)
create table OBJ_M_REPOSITORY (M_REPO_N_ID NUMBER(10) not null, M_REPO_N_CONNECTID NUMBER(10) not null, M_REPO_C_NAME VARCHAR2(35) not null, M_REPO_N_TYPE NUMBER(10) not null, M_REPO_C_VERSION VARCHAR2(35) not null, M_REPO_N_USERID NUMBER(10) not null, M_REPO_N_CREATDATE NUMBER(10) not null, M_REPO_N_LAD NUMBER(10) not null, M_REPO_N_LAT NUMBER(10) not null)
create table OBJ_M_CATEG(M_CATEG_N_ID NUMBER(10) not null, M_CATEG_C_NAME VARCHAR(254) null, M_ACTOR_N_ID NUMBER(10) null, M_CATEG_N_LAD NUMBER(10) null, M_CATEG_N_PARENTID NUMBER(10) null)
create table OBJ_M_CONNECTDATA (M_CNTA_N_CNTNID NUMBER(10) not null, M_CNTA_N_TYPE NUMBER(10) not null, M_CNTA_N_BLOCKID NUMBER(10) not null, M_CNTA_C_BLKVALUE VARCHAR2(254) not null)
create table OBJ_M_OBJSLICE (M_OBJS_N_ID NUMBER(10), M_OBJS_N_TYPE NUMBER(10), M_OBJS_N_BLOCK_ID NUMBER(10), M_OBJS_C_VALUE VARCHAR(254))
create table OBJ_M_RESERVATION (M_RSRV_N_ENTID NUMBER(10) not null, M_RSRV_N_ENTTYPE NUMBER(10) not null, M_RSRV_N_SESSIONID NUMBER(10) not null, M_RSRV_N_ACTORID NUMBER(10) not null, M_RSRV_N_ENDTIME NUMBER(10) not null)
create table DS_PENDING_JOB(BATCH_ID NUMBER(10) not null,DOCUMENT_ID NUMBER(10) not null,PRC_ID VARCHAR2(10) null,USER_SUBMIT_ID NUMBER(10) not null,PRIORITY NUMBER(10) not null,FREQUENCY NUMBER(10) not null,DAY_TIMING NUMBER(10) not null,BEGIN_TIME NUMBER(10) null,BEGIN_DATE NUMBER(10) null,START_DATETIME NUMBER(10) null,END_DATETIME NUMBER(10) null,SUBMIT_DATETIME NUMBER(10) not null, EXPIRATION_DATE NUMBER(10) null,JOB_STATUS NUMBER(10) null,JOB_ERROR NUMBER(10) null,DOCSERVER_ID NUMBER(10) null,JOB_SCRIPT VARCHAR2(254) null,JOB_DESC VARCHAR2(254) null, JOB_DATA VARCHAR(70) null, IP_ADDRESS VARCHAR(254) null, ERROR_TEXT VARCHAR(254) null, VERSION NUMBER(10) null, IN_NAME_OF NUMBER(10) null, JOB_PLATFORM NUMBER(10) null)
create table OBJ_M_DOCCATEG(M_CATEG_N_ID NUMBER(10) not null, M_DOC_N_ID NUMBER(10) not null)
create table OBJ_M_DOCAT(M_DOC_N_ID NUMBER(10) not null, M_DOCAT_N_LPRINT NUMBER(10) null, M_DOCAT_N_LAD NUMBER(10) null)
create table OBJ_M_DOCATVAR(M_DOC_N_ID NUMBER(10) not null, M_DOCATV_C_DPNAME VARCHAR(254) null, M_SRC_C_NAME VARCHAR(254) null, M_DOCATV_N_REF NUMBER(10) null, M_DOCATV_N_NBROWS NUMBER(10) null, M_DOCATV_N_REFDUR NUMBER(10) null, M_DOCATV_N_LAD NUMBER(10) null, M_DOCATV_N_PARTIAL NUMBER(10) null)
create unique index PK_M_ACTOR on OBJ_M_ACTOR (M_ACTOR_N_ID asc)
create unique index PK_M_DOCCST on OBJ_M_DOCCST (M_DOCC_N_DOCLINKID asc)
create unique index PK_M_GENPAR on OBJ_M_GENPAR (M_GENPAR_N_ID asc, M_GENPAR_N_APPLID asc, M_GENPAR_N_USERID asc)
create unique index PK_M_MAGICID on OBJ_M_MAGICID (M_MAGIC_C_NAME asc)
create unique index PK_M_RESLINK on OBJ_M_RESLINK (M_RES_N_ID asc)
create unique index PK_M_UNIVCST on OBJ_M_UNIVCST (M_UNIC_N_UNILINKID asc)
create unique index PK_M_UNIVSLC on OBJ_M_UNIVSLC (M_UNIS_N_ID asc, M_UNIS_N_BLKID asc, M_UNIS_C_NAME asc)
create unique index PK_M_ACTORDOC on OBJ_M_ACTORDOC (M_ACTDC_N_ACTORID asc, M_ACTDC_N_DOCID asc)
create unique index PK_M_DOCUMENTS on OBJ_M_DOCUMENTS (M_DOC_N_ID asc)
create unique index PK_M_UNIVERSES on OBJ_M_UNIVERSES (M_UNI_N_ID asc)
create unique index PK_M_ACTORLINK on OBJ_M_ACTORLINK (M_ACTL_N_ID asc)
create unique index PK_M_TIMESTAMP on OBJ_M_TIMESTAMP (M_TMS_N_ID asc)
create unique index PK_M_UNIVDBCST on OBJ_M_UNIVDBCST (M_UNID_N_ID asc)
create unique index PK_M_CHANNEL on OBJ_M_CHANNEL (M_CHNL_N_ID)
create unique index PK_M_CONNECTION on OBJ_M_CONNECTION (M_CNTN_N_ID asc)
create unique index PKX_USER_LIST on DS_USER_LIST (DOCUMENT_ID asc, USER_ID asc)
create unique index PK_M_REPOSITORY on OBJ_M_REPOSITORY (M_REPO_N_ID asc)
create unique index PK_M_CONNECTDATA on OBJ_M_CONNECTDATA (M_CNTA_N_CNTNID asc, M_CNTA_N_TYPE asc, M_CNTA_N_BLOCKID asc)
create unique index PK_OBJSLICE on OBJ_M_OBJSLICE (M_OBJS_N_ID, M_OBJS_N_TYPE, M_OBJS_N_BLOCK_ID)
create unique index PK_M_RESERVATION on OBJ_M_RESERVATION (M_RSRV_N_ENTID asc, M_RSRV_N_ENTTYPE asc)
create unique index PKX_BATCH on DS_PENDING_JOB (BATCH_ID asc)
create unique index PK_M_DOCAT on OBJ_M_DOCAT (M_DOC_N_ID asc)
comment on table OBJ_M_ACTOR is 'Actors main information'
comment on table OBJ_M_DOCCST is 'Documents constraints informations'
comment on table OBJ_M_GENPAR is 'Generic Parameters'
comment on table OBJ_M_MAGICID is 'Magic ID generator'
comment on table OBJ_M_RESLINK is 'Resource Link informations'
comment on table OBJ_M_UNIVCST is 'Universe Constraints information'
comment on table OBJ_M_UNIVSLC is 'Universe Slices informations'
comment on table OBJ_M_ACTORDOC is 'Documents list for Actors'
comment on table OBJ_M_DOCUMENTS is 'Documents informations'
comment on table OBJ_M_UNIVERSES is 'Universes informations'
comment on table OBJ_M_ACTORLINK is 'Actor Link informations'
comment on table OBJ_M_TIMESTAMP is 'Timestamp informations'
comment on table OBJ_M_UNIVDBCST is 'Universe Rdbms Constraints information'
comment on table OBJ_M_CONNECTION is 'Connection main information'
comment on table DS_USER_LIST is 'Table of list of Users'
comment on table OBJ_M_REPOSITORY is 'Repository main information'
comment on table OBJ_M_CONNECTDATA is 'Connection long sliced information'
comment on table OBJ_M_RESERVATION is 'Reservation informations'
comment on table DS_PENDING_JOB is 'Table containing a Batch'
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (10 ,'DX')
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (10 ,'USER')
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (10 ,'BATCH')
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (10 ,'RESLINK')
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (10 ,'SESSION')
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (10 ,'ACTORDEF')
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (10 ,'UNIVERSE')
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (10 ,'ACTLORDER')
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (1000 ,'ACTORLINK')
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (10 ,'TIMESTAMP')
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (10 ,'UNIVDBCST')
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (10 ,'CHANNEL')
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (10 ,'CONNECTION')
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (10 ,'REPOSITORY')
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (10 ,'UNIVCSTSLC')
insert into OBJ_M_MAGICID(M_MAGIC_N_ID,M_MAGIC_C_NAME) VALUES (10 ,'CATEGORY')
insert into OBJ_M_GENPAR(M_GENPAR_N_ID, M_GENPAR_N_APPLID, M_GENPAR_N_USERID, M_GENPAR_N_TYPE, M_GENPAR_N_VALUE, M_GENPAR_C_LABEL) values (121, 0, 0, 0, 0, '72E14A55-B73C-45F4-ADB0-F73031A6C3DD')
Domaine sécurité créé.
create table OBJ_X_DOCUMENTS(X_DOC_N_ID NUMBER(10) not null, X_DOC_N_BLOCKID NUMBER(10) not null, X_DOC_B_CONTENT LONG RAW not null)
create unique index PKX_DOCUMENTS on OBJ_X_DOCUMENTS (X_DOC_N_ID asc, X_DOC_N_BLOCKID asc)
comment on table OBJ_X_DOCUMENTS is 'Document storage table'
Domaine document créé.
Création du domaine univers en cours...
create table UNV_JOIN(JOIN_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null, JN_X_AXIS NUMBER(10) not null, JN_Y_AXIS NUMBER(10) not null, JN_X1 NUMBER(10) null, JN_X2 NUMBER(10) null, JN_HIDDEN CHAR(2) not null, JN_POSITION NUMBER(10) not null)
create table UNV_AUDIT (AUDIT_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null, AUD_UNIVERSION NUMBER(10) not null, AUD_ITEM_ID NUMBER(10) not null, AUD_ITEMTYPE CHAR(12) not null, AUD_MODIFTYPE CHAR(12) not null, AUD_MODIFDATA NUMBER(10) not null, AUD_POSITION NUMBER(10) not null)
create table UNV_CLASS (CLASS_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null,CLS_NAME VARCHAR2(35) not null,CLS_BASECLASSID NUMBER(10) not null,CLS_HIDDEN CHAR(2) not null, CLS_POSITION NUMBER(10) not null)
create table UNV_RELATIONS(DERIV_UNV_ID NUMBER(10) not null, BASIC_UNV_ID NUMBER(10) not null)
create table UNV_DIM_OBJ (DIMENSION_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null, OBJECT_ID NUMBER(10) not null, DIM_SEQ NUMBER(10) not null)
create table UNV_OBJECT(OBJECT_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null, CLASS_ID NUMBER(10) not null, OBJ_NAME VARCHAR2(35) not null,OBJ_HIDDEN CHAR(2) not null, OBJ_POSITION NUMBER(10) not null)
create table UNV_OBJ_TAB (OBJECT_ID NUMBER(10) not null, TABLE_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null)
create table UNV_TAB_OBJ(TABLE_ID NUMBER(10) not null, OBJECT_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null)
create table UNV_CONTEXT (CONTEXT_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null, CTX_NAME CHAR(35) not null, CTX_POSITION NUMBER(10) not null)
create table UNV_CTX_JOIN (CONTEXT_ID NUMBER(10) not null, JOIN_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null)
create table UNV_TAB_PROP(TABLE_ID NUMBER(10) not null, PROPERTY_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null)
create table UNV_JOIN_DATA (JOIN_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null, JN_DATATYPE CHAR(2) not null, JN_SLICE NUMBER(6) not null, JN_DATAVALUE VARCHAR2(240) not null)
create table UNV_PROP_DATA (PROPERTY_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null, PRP_DATATYPE CHAR(2) not null, PRP_SLICE NUMBER(6) not null, PRP_DATAVALUE VARCHAR2(240) not null)
create table UNV_PROPERTY (PROPERTY_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null, CLASS_ID NUMBER(10) not null, PRP_NAME VARCHAR2(35) not null, PRP_HIDDEN CHAR(2) not null, PRP_POSITION NUMBER(10) not null)
create table UNV_UNIVERSE (UNIVERSE_ID NUMBER(10) not null,UNI_FILENAME CHAR(8) not null,UNI_LONGNAME VARCHAR2(35) not null,UNI_CONNEXION NUMBER(10) not null,UNI_VERSION NUMBER(10) not null,UNI_FIRSTAUTHOR VARCHAR2(35) null,UNI_LASTAUTHOR VARCHAR2(35) null,UNI_CREATEDATE CHAR(12) null,UNI_MODIFYDATE CHAR(12) null,UNI_MAXTIME NUMBER(10) not null,UNI_MAXLINES NUMBER(10) not null,UNI_ESTIMATE NUMBER(10) null,UNI_MAXCOLUMN NUMBER(6) null,UNI_PREFERENCES VARCHAR2(35) null,UNI_CONVERSION NUMBER(1) null,UNI_REPODOCID NUMBER(10) null,UNI_QUALIFIERS VARCHAR2(35) null,UNI_OWNERS VARCHAR2(35) null)
create table UNV_CLASS_DATA (CLASS_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null, CLS_DATATYPE CHAR(2) not null, CLS_SLICE NUMBER(6) not null, CLS_DATAVALUE VARCHAR2(240) not null)
create table UNV_DIMENSION (DIMENSION_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null, DIM_NAME VARCHAR2(35) not null, DIM_POSITION NUMBER(10) not null)
create table UNV_PROP_TAB (PROPERTY_ID NUMBER(10) not null, TABLE_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null)
create table UNV_OBJECT_DATA (OBJECT_ID NUMBER(10) not null,UNIVERSE_ID NUMBER(10) not null,OBJ_DATATYPE CHAR(2) not null,OBJ_SLICE NUMBER(6) not null,OBJ_DATAVALUE VARCHAR2(240) not null)
create table UNV_CONTEXT_DATA (CONTEXT_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null, CTX_DATATYPE CHAR(2) not null, CTX_SLICE NUMBER(6) not null, CTX_DATAVALUE VARCHAR2(240) not null)
create table UNV_JOINCONTENT(JOIN_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null, JN_TABLE1_ID NUMBER(10) not null, JN_TABLE2_ID NUMBER(10) not null, JN_PROP VARCHAR2(35) not null)
create table UNV_UNIVERSE_DATA (UNIVERSE_ID NUMBER(10) not null, UNI_DATATYPE CHAR(2) not null, UNI_SLICE NUMBER(6) not null, UNI_DATAVALUE VARCHAR2(240) not null)
create table UNV_OBJCONTENT(OBJECT_ID NUMBER(10) not null,UNIVERSE_ID NUMBER(10) not null,OBJ_PROP VARCHAR2(35) not null,OBJ_WEIGHT NUMBER(10) not null,OBJ_INPUT VARCHAR2(50) null,OBJ_OUTPUT VARCHAR2(50) null,OBJ_LIST_VALUES VARCHAR2(50) null,OBJ_SECURITY NUMBER(1) null,OBJ_AXIS_ID NUMBER(10) null,OBJ_CONDOBJ_ID NUMBER(10) null,OBJ_DATEFORMAT VARCHAR2(35) null,OBJ_YEAR_ID NUMBER(10) null,OBJ_QUARTER_ID NUMBER(10) null,OBJ_MONTH_ID NUMBER(10) null,OBJ_WEEK_ID NUMBER(10) null,OBJ_BASICDATE_ID NUMBER(10) null,OBJ_LOVID NUMBER(10) null)
create table UNV_TABLE(TABLE_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null, TAB_NAME VARCHAR2(110) not null, TAB_PROP VARCHAR2(35) null, TAB_SCROLL NUMBER(10) null, TAB_LEFT NUMBER(10) not null, TAB_TOP NUMBER(10) not null, TAB_RIGHT NUMBER(10) not null, TAB_BOTTOM NUMBER(10) not null,TAB_WEIGHT NUMBER(10) null,ALIAS_TABLE NUMBER(10) null)
create unique index JOIN_PK on UNV_JOIN (JOIN_ID asc, UNIVERSE_ID asc)
create unique index AUDIT_PK on UNV_AUDIT (AUDIT_ID asc, UNIVERSE_ID asc)
create unique index CLASS_PK on UNV_CLASS (CLASS_ID asc, UNIVERSE_ID asc)
create unique index UNV_RELATIONS_PK on UNV_RELATIONS (DERIV_UNV_ID asc, BASIC_UNV_ID asc)
create unique index DIM_OBJ_PK on UNV_DIM_OBJ (DIMENSION_ID asc, OBJECT_ID asc, UNIVERSE_ID asc)
create unique index OBJECT_PK on UNV_OBJECT (OBJECT_ID asc, UNIVERSE_ID asc)
create unique index OBJ_TAB_PK on UNV_OBJ_TAB (OBJECT_ID asc, TABLE_ID asc, UNIVERSE_ID asc)
create unique index TAB_OBJ_PK on UNV_TAB_OBJ (TABLE_ID asc, OBJECT_ID asc, UNIVERSE_ID asc)
create unique index CONTEXT_PK on UNV_CONTEXT (CONTEXT_ID asc, UNIVERSE_ID asc)
create unique index CTX_JOIN_PK on UNV_CTX_JOIN (CONTEXT_ID asc, JOIN_ID asc, UNIVERSE_ID asc)
create unique index TAB_PROP_PK on UNV_TAB_PROP (TABLE_ID asc, PROPERTY_ID asc, UNIVERSE_ID asc)
create unique index JOIN_DATA_PK on UNV_JOIN_DATA (JOIN_ID asc, UNIVERSE_ID asc, JN_DATATYPE asc, JN_SLICE asc)
create unique index PROP_DATA_PK on UNV_PROP_DATA (PROPERTY_ID asc, UNIVERSE_ID asc, PRP_DATATYPE asc, PRP_SLICE asc)
create unique index PROPERTY_PK on UNV_PROPERTY (PROPERTY_ID asc, UNIVERSE_ID asc)
create unique index UNIVERSE_PK on UNV_UNIVERSE (UNIVERSE_ID asc)
create unique index CLASS_DATA_PK on UNV_CLASS_DATA (CLASS_ID asc, UNIVERSE_ID asc, CLS_DATATYPE asc, CLS_SLICE asc)
create unique index DIMENSION_PK on UNV_DIMENSION (DIMENSION_ID asc, UNIVERSE_ID asc)
create unique index PROP_TABLE_PK on UNV_PROP_TAB (PROPERTY_ID asc, TABLE_ID asc, UNIVERSE_ID asc)
create unique index OBJECT_DATA_PK on UNV_OBJECT_DATA (OBJECT_ID asc, UNIVERSE_ID asc, OBJ_DATATYPE asc, OBJ_SLICE asc)
create unique index CONTEXT_DATA_PK on UNV_CONTEXT_DATA (CONTEXT_ID asc, UNIVERSE_ID asc, CTX_DATATYPE asc, CTX_SLICE asc)
create unique index JOIN_CONTENT_PK on UNV_JOINCONTENT (JOIN_ID asc, UNIVERSE_ID asc)
create unique index UNI_DATA_PK on UNV_UNIVERSE_DATA (UNIVERSE_ID asc, UNI_DATATYPE asc, UNI_SLICE asc)
create unique index OBJECT_CONTENT_PK on UNV_OBJCONTENT (OBJECT_ID asc, UNIVERSE_ID asc)
create unique index UNV_TABLE_PK on UNV_TABLE (TABLE_ID asc, UNIVERSE_ID asc)
comment on table UNV_JOIN is 'Table containing joins between universe tables'
comment on table UNV_AUDIT is 'Table of modifications of universe components'
comment on table UNV_CLASS is 'Table of universe classes'
comment on table UNV_RELATIONS is 'Table of universe derivations'
comment on table UNV_DIM_OBJ is 'Table of dimension objects'
comment on table UNV_OBJECT is 'Table containing universe objects'
comment on table UNV_OBJ_TAB is 'Table of universe tables referenced by an object'
comment on table UNV_TAB_OBJ is 'Table of universe objects referenced by a table'
comment on table UNV_CONTEXT is 'Table of universe contexts'
comment on table UNV_CTX_JOIN is 'Table of context joins'
comment on table UNV_TAB_PROP is 'Table of Universe Property referenced by a table'
comment on table UNV_JOIN_DATA is 'Table of data associated with a join'
comment on table UNV_PROP_DATA is 'Table of data associated with a property'
comment on table UNV_PROPERTY is 'Table of class properties'
comment on table UNV_UNIVERSE is 'Table of universes'
comment on table UNV_CLASS_DATA is 'Table of data associated with a class'
comment on table UNV_DIMENSION is 'Table of universe dimensions'
comment on table UNV_PROP_TAB is 'Table of universe tables used in a property'
comment on table UNV_OBJECT_DATA is 'Table of data associated with an object'
comment on table UNV_CONTEXT_DATA is 'Table of data associated with a context'
comment on table UNV_JOINCONTENT is 'Table containing joins contents between universe tables'
comment on table UNV_UNIVERSE_DATA is 'Table of data associated with a universe'
comment on table UNV_OBJCONTENT is 'Table containing universe objects contents'
comment on table UNV_TABLE is 'Table of universe tables'
Domaine univers créé.

[marion782]

Merci pour ce script.
Je vais voir ce que je peux en faire...

[nuke_y]

N'hésite pas à poster le résultat de tes travaux, ça m'intéresse pour des specs d'univers à venir ;D