Sitemap

Amicuk Programming Answers

BIB-9509

-0001-11-30   Views:0

Advertisement

I´m trying to create a crostab with one fact and 6 dimensions. i[m using Jdeveloper 9.0.3.10.90 and Oracle9i Enterprise Edition Release 9.2.0.4.0. In Query builder in the dimensions tab, when i select one of my dimensions, just that one, i cant pass

I´m trying to create a crostab with one fact and 6 dimensions. i[m using Jdeveloper 9.0.3.10.90 and Oracle9i Enterprise Edition Release 9.2.0.4.0.
In Query builder in the dimensions tab, when i select one of my dimensions, just that one, i cant pass the members of that dimensions and the wizard ends with the next error:
BIB-9509 Oracle OLAP no ha creado el cursor.
class: OLAPI
Server error descriptions:
DPR: No se ha podido crear el cursor del servidor, Genérico at TxsOqDefinitionManagerSince9202::crtCurMgrWthInputTypes
OES: ORA-01722: invalid number
Genérico at TxsRdbSelectStatement:execute()
can anyone help me?
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               

The replay answer
Advertisement
I found this script in metalink
set echo on
set linesize 135
set pagesize 50
set serverout on size 100000
exec cwm2_olap_manager.set_echo_on;
spool D:\jos\Pemex\Inconformidades\validate.log
exec cwm2_olap_validate.validate_all_cubes('OLAP API');
PROMPT exec cwm2_olap_validate.validate_all_dimensions('OLAP API');
execute cwm2_olap_manager.End_Log;
execute cwm2_olap_manager.Set_Echo_Off;
spool off
and the output for this script is:
SQL> PROMPT exec cwm2_olap_validate.validate_all_cubes('OLAP API');
exec cwm2_olap_validate.validate_all_cubes('OLAP API')
SQL> exec cwm2_olap_validate.validate_all_dimensions('OLAP API');
.Validate All Dimensions
.Validate Dimension: DMCGC0.D_ACTUACION_I_DIM Type of Validation: OLAP API Verbose Report: YES
.Validating Dimension Metadata in OLAP Catalog 2 Date: 2004 JUNIO 08 Time: 10:55:10 User: DMCGC0 030715
.ENTITY TYPE ENTITY NAME STATUS COMMENT
. Dimension DMCGC0.D_ACTUACION_I_DIM VALID Default Display Hierarchy: "H_ACTUACION".
. DimensionAttribute LONG DESCRIPTION VALID DimensionAttribute Type: "Long Description".
. Hierarchy H_ACTUACION VALID
. Level L_ACTUACION VALID Hierarchy Depth: 1 (Lowest Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_ACTUACION_I
- .A_ID_ACTUACION".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_ACTUACION_I
- .A_DESC_ACTUACION".
.Validate Dimension: DMCGC0.D_AREA_I_DIM Type of Validation: OLAP API Verbose Report: YES
.Validating Dimension Metadata in OLAP Catalog 2 Date: 2004 JUNIO 08 Time: 10:55:10 User: DMCGC0 030715
.ENTITY TYPE ENTITY NAME STATUS COMMENT
. Dimension DMCGC0.D_AREA_I_DIM VALID Default Display Hierarchy: "H_AREA".
. DimensionAttribute LONG DESCRIPTION VALID DimensionAttribute Type: "Long Description".
. DimensionAttribute SHORT DESCRIPTION VALID DimensionAttribute Type: "Short Description".
. Hierarchy H_AREA VALID
. Level UNIDAD VALID Hierarchy Depth: 1 (Lowest Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_AREA_I.UC_ID_UNIDAD".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_AREA_I
- .UC_DESC_UNIDAD_COMP".
. Level GERENCIA VALID Hierarchy Depth: 2.
. LevelMap VALID Mapped Column: "DMCGC0.D_AREA_I.G_ID_GERENCIA".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_AREA_I.G_DESC_GERENCIA".
. Level SUBDIR VALID Hierarchy Depth: 3.
. LevelMap VALID Mapped Column: "DMCGC0.D_AREA_I
- .SD_ID_SUBDIRECCION".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_AREA_I
- .SD_DESC_SUBDIRECCI".
. LevelAttribute SHORT DESCRIPTION VALID DimensionAttribute: "SHORT DESCRIPTION".
- LevelAttribute Type: "Short Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_AREA_I
- .SD_CVE_SUBDIRECCION".
. Level DIRECCION VALID Hierarchy Depth: 4.
. LevelMap VALID Mapped Column: "DMCGC0.D_AREA_I.D_ID_DIRECCION".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_AREA_I.D_DESC_DIRECCION".
. LevelAttribute SHORT DESCRIPTION VALID DimensionAttribute: "SHORT DESCRIPTION".
- LevelAttribute Type: "Short Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_AREA_I.D_CVE_DIRECCION".
. Level ORGANISMO VALID Hierarchy Depth: 5 (Top Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_AREA_I.O_ID_ORGANISMO".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_AREA_I.O_DESC_ORGANISMO".
. LevelAttribute SHORT DESCRIPTION VALID DimensionAttribute: "SHORT DESCRIPTION".
- LevelAttribute Type: "Short Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_AREA_I.O_CVE_ORGANISMO".
.Validate Dimension: DMCGC0.D_AREAS_TURNADAS_I_DIM Type of Validation: OLAP API Verbose Report: YES
.Validating Dimension Metadata in OLAP Catalog 2 Date: 2004 JUNIO 08 Time: 10:55:10 User: DMCGC0 030715
.ENTITY TYPE ENTITY NAME STATUS COMMENT
. Dimension DMCGC0.D_AREAS_TURNADAS_I_DIM VALID Default Display Hierarchy: "H_AREA_TURNADA".
. DimensionAttribute LONG DESCRIPTION VALID DimensionAttribute Type: "Long Description".
. DimensionAttribute SHORT DESCRIPTION VALID DimensionAttribute Type: "Short Description".
. Hierarchy H_AREA_TURNADA VALID
. Level L_AREA_TURNADA VALID Hierarchy Depth: 1 (Lowest Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_AREAS_TURNADAS_I
- .AT_ID_AREA_TURNADA".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_AREAS_TURNADAS_I
- .AT_DESC_AREA_TURNA".
. LevelAttribute SHORT DESCRIPTION VALID DimensionAttribute: "SHORT DESCRIPTION".
- LevelAttribute Type: "Short Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_AREAS_TURNADAS_I
- .AT_CVE_AREA_TURNADA".
. Level L_ORGANISMO VALID Hierarchy Depth: 2 (Top Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_AREAS_TURNADAS_I
- .O_ID_ORGANISMO".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_AREAS_TURNADAS_I
- .O_DESC_ORGANISMO".
. LevelAttribute SHORT DESCRIPTION VALID DimensionAttribute: "SHORT DESCRIPTION".
- LevelAttribute Type: "Short Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_AREAS_TURNADAS_I
- .O_CVE_ORGANISMO".
.Validate Dimension: DMCGC0.D_CABECERO_I_DIM Type of Validation: OLAP API Verbose Report: YES
.Validating Dimension Metadata in OLAP Catalog 2 Date: 2004 JUNIO 08 Time: 10:55:10 User: DMCGC0 030715
.ENTITY TYPE ENTITY NAME STATUS COMMENT
. Dimension DMCGC0.D_CABECERO_I_DIM VALID Default Display Hierarchy: "H_CABECERO".
. DimensionAttribute CONCLUIDOS VALID
. DimensionAttribute EN PROCESO VALID
. DimensionAttribute LONG DESCRIPTION VALID DimensionAttribute Type: "Long Description".
. DimensionAttribute SUBTOTAL VALID
. DimensionAttribute TRIMESTRE ACTUAL VALID
. DimensionAttribute TRIMESTRE ANTERIOR VALID
. Hierarchy H_CABECERO VALID
. Level L_CABECERO VALID Hierarchy Depth: 1 (Lowest Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_CABECERO_I
- .C_ID_CABECERO".
. LevelAttribute CONCLUIDOS VALID DimensionAttribute: "CONCLUIDOS".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_CABECERO_I.C_CONCLUIDOS".
. LevelAttribute EN PROCESO VALID DimensionAttribute: "EN PROCESO".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_CABECERO_I.C_EN_PROCESO".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_CABECERO_I
- .C_DESCRIPCION".
. LevelAttribute SUBTOTAL VALID DimensionAttribute: "SUBTOTAL".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_CABECERO_I.C_SUBTOTAL".
. LevelAttribute TRIMESTRE ACTUAL VALID DimensionAttribute: "TRIMESTRE ACTUAL".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_CABECERO_I
- .C_TRIMESTRE_ACTUAL".
. LevelAttribute TRIMESTRE ANTERIOR VALID DimensionAttribute: "TRIMESTRE ANTERIOR".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_CABECERO_I
- .C_TRIMESTRE_ANTERIOR".
.Validate Dimension: DMCGC0.D_EVENTO_I_DIM Type of Validation: OLAP API Verbose Report: YES
.Validating Dimension Metadata in OLAP Catalog 2 Date: 2004 JUNIO 08 Time: 10:55:10 User: DMCGC0 030715
.ENTITY TYPE ENTITY NAME STATUS COMMENT
. Dimension DMCGC0.D_EVENTO_I_DIM VALID Default Display Hierarchy: "H_EVENTO".
. DimensionAttribute LONG DESCRIPTION VALID DimensionAttribute Type: "Long Description".
. DimensionAttribute SHORT DESCRIPTION VALID DimensionAttribute Type: "Short Description".
. Hierarchy H_EVENTO VALID
. Level L_EVENTO VALID Hierarchy Depth: 1 (Lowest Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_EVENTO_I.E_ID_EVENTO".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_EVENTO_I.E_DESC_EVENTO".
. LevelAttribute SHORT DESCRIPTION VALID DimensionAttribute: "SHORT DESCRIPTION".
- LevelAttribute Type: "Short Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_EVENTO_I.E_CVE_EVENTO".
.Validate Dimension: DMCGC0.D_INCONFORME_I_DIM Type of Validation: OLAP API Verbose Report: YES
.Validating Dimension Metadata in OLAP Catalog 2 Date: 2004 JUNIO 08 Time: 10:55:10 User: DMCGC0 030715
.ENTITY TYPE ENTITY NAME STATUS COMMENT
. Dimension DMCGC0.D_INCONFORME_I_DIM VALID Default Display Hierarchy: "H_INCONFORME".
. DimensionAttribute LONG DESCRIPTION VALID DimensionAttribute Type: "Long Description".
. Hierarchy H_INCONFORME VALID
. Level L_INCONFORME VALID Hierarchy Depth: 1 (Lowest Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_INCONFORME_I
- .I_ID_INCONF".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_INCONFORME_I
- .I_DESC_INCONF".
.Validate Dimension: DMCGC0.D_PROVEEDOR_I_DIM Type of Validation: OLAP API Verbose Report: YES
.Validating Dimension Metadata in OLAP Catalog 2 Date: 2004 JUNIO 08 Time: 10:55:10 User: DMCGC0 030715
.ENTITY TYPE ENTITY NAME STATUS COMMENT
. Dimension DMCGC0.D_PROVEEDOR_I_DIM VALID Default Display Hierarchy: "H_PROVEEDOR".
. DimensionAttribute LONG DESCRIPTION VALID DimensionAttribute Type: "Long Description".
. Hierarchy H_PROVEEDOR VALID
. Level L_PROVEEDOR VALID Hierarchy Depth: 1 (Lowest Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_PROVEEDOR_I
- .P_ID_PROVEEDOR".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_PROVEEDOR_I
- .P_DESC_PROVEEDOR".
.Validate Dimension: DMCGC0.D_TIEMPO_DIM Type of Validation: OLAP API Verbose Report: YES
.Validating Dimension Metadata in OLAP Catalog 2 Date: 2004 JUNIO 08 Time: 10:55:10 User: DMCGC0 030715
.ENTITY TYPE ENTITY NAME STATUS COMMENT
. Dimension DMCGC0.D_TIEMPO_DIM VALID Dimension Type: "Time".
- Default Display Hierarchy: "TIME_HIER".
. DimensionAttribute END DATE VALID DimensionAttribute Type: "End Date".
. DimensionAttribute LONG DESCRIPTION VALID DimensionAttribute Type: "Long Description".
. DimensionAttribute TIME SPAN VALID DimensionAttribute Type: "Time Span".
. Hierarchy TIME_HIER VALID
. Level TIME_DATE VALID Hierarchy Depth: 1 (Lowest Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_TIEMPO.F_ID_FECHA".
. LevelAttribute END DATE VALID DimensionAttribute: "END DATE".
- LevelAttribute Type: "End Date".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.F_FIN_FECHA".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.F_DESC_FECHA".
. LevelAttribute TIME SPAN VALID DimensionAttribute: "TIME SPAN".
- LevelAttribute Type: "Time Span".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.F_DURACION_FECHA".
. Level TIME_DAY VALID Hierarchy Depth: 2.
. LevelMap VALID Mapped Column: "DMCGC0.D_TIEMPO.D_ID_DIA".
. LevelAttribute END DATE VALID DimensionAttribute: "END DATE".
- LevelAttribute Type: "End Date".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.D_FIN_DIA".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.D_DESC_DIA".
. LevelAttribute TIME SPAN VALID DimensionAttribute: "TIME SPAN".
- LevelAttribute Type: "Time Span".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.D_DURACION_DIA".
. Level TIME_MON VALID Hierarchy Depth: 3.
. LevelMap VALID Mapped Column: "DMCGC0.D_TIEMPO.X_ID_MES".
. LevelAttribute END DATE VALID DimensionAttribute: "END DATE".
- LevelAttribute Type: "End Date".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.X_FIN_MES".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.X_DESC_MES".
. LevelAttribute TIME SPAN VALID DimensionAttribute: "TIME SPAN".
- LevelAttribute Type: "Time Span".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.X_DURACION_MES".
. Level TIME_QTR VALID Hierarchy Depth: 4.
. LevelMap VALID Mapped Column: "DMCGC0.D_TIEMPO.T_ID_TRIM".
. LevelAttribute END DATE VALID DimensionAttribute: "END DATE".
- LevelAttribute Type: "End Date".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.T_FIN_TRIM".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.T_DESC_TRIM".
. LevelAttribute TIME SPAN VALID DimensionAttribute: "TIME SPAN".
- LevelAttribute Type: "Time Span".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.T_DURACION_TRIM".
. Level TIME_SEM VALID Hierarchy Depth: 5.
. LevelMap VALID Mapped Column: "DMCGC0.D_TIEMPO.S_ID_SEM".
. LevelAttribute END DATE VALID DimensionAttribute: "END DATE".
- LevelAttribute Type: "End Date".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.S_FIN_SEM".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.S_DESC_SEM".
. LevelAttribute TIME SPAN VALID DimensionAttribute: "TIME SPAN".
- LevelAttribute Type: "Time Span".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.S_DURACION_SEM".
. Level TIME_YEAR VALID Hierarchy Depth: 6 (Top Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_TIEMPO.A_ID_ANIO".
. LevelAttribute END DATE VALID DimensionAttribute: "END DATE".
- LevelAttribute Type: "End Date".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.A_FIN_ANIO".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.A_DESC_ANIO".
. LevelAttribute TIME SPAN VALID DimensionAttribute: "TIME SPAN".
- LevelAttribute Type: "Time Span".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIEMPO.A_DURACION_ANIO".
.Validate Dimension: DMCGC0.D_TIPO_CONTRAT_I_DIM Type of Validation: OLAP API Verbose Report: YES
.Validating Dimension Metadata in OLAP Catalog 2 Date: 2004 JUNIO 08 Time: 10:55:10 User: DMCGC0 030715
.ENTITY TYPE ENTITY NAME STATUS COMMENT
. Dimension DMCGC0.D_TIPO_CONTRAT_I_DIM VALID Default Display Hierarchy: "H_TIPO_CONTRAT".
. DimensionAttribute LONG DESCRIPTION VALID DimensionAttribute Type: "Long Description".
. DimensionAttribute SHORT DESCRIPTION VALID DimensionAttribute Type: "Short Description".
. Hierarchy H_TIPO_CONTRAT VALID
. Level L_TIPO_CONTRAT VALID Hierarchy Depth: 1 (Lowest Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_TIPO_CONTRAT_I
- .TP_ID_TIPO_CONTRAT".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIPO_CONTRAT_I
- .TP_DESC_TIPO_CONTR".
. LevelAttribute SHORT DESCRIPTION VALID DimensionAttribute: "SHORT DESCRIPTION".
- LevelAttribute Type: "Short Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIPO_CONTRAT_I
- .TP_CVE_TIPO_CONTRAT".
. Level L_TIPO_LEY VALID Hierarchy Depth: 2 (Top Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_TIPO_CONTRAT_I
- .TL_ID_TIPO_LEY".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIPO_CONTRAT_I
- .TL_DESC_TIPO_LEY".
.Validate Dimension: DMCGC0.D_TIPO_LEY_I_DIM Type of Validation: OLAP API Verbose Report: YES
.Validating Dimension Metadata in OLAP Catalog 2 Date: 2004 JUNIO 08 Time: 10:55:10 User: DMCGC0 030715
.ENTITY TYPE ENTITY NAME STATUS COMMENT
. Dimension DMCGC0.D_TIPO_LEY_I_DIM VALID Default Display Hierarchy: "H_TIPO_LEY".
. DimensionAttribute LONG DESCRIPTION VALID DimensionAttribute Type: "Long Description".
. Hierarchy H_TIPO_LEY VALID
. Level L_TIPO_LEY VALID Hierarchy Depth: 1 (Lowest Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_TIPO_LEY_I
- .TL_ID_TIPO_LEY".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIPO_LEY_I
- .TL_DESC_TIPO_LEY".
.Validate Dimension: DMCGC0.D_TIPO_PROC_I_DIM Type of Validation: OLAP API Verbose Report: YES
.Validating Dimension Metadata in OLAP Catalog 2 Date: 2004 JUNIO 08 Time: 10:55:10 User: DMCGC0 030715
.ENTITY TYPE ENTITY NAME STATUS COMMENT
. Dimension DMCGC0.D_TIPO_PROC_I_DIM VALID Default Display Hierarchy: "H_TIPO_PROC".
. DimensionAttribute LONG DESCRIPTION VALID DimensionAttribute Type: "Long Description".
. DimensionAttribute SHORT DESCRIPTION VALID DimensionAttribute Type: "Short Description".
. Hierarchy H_TIPO_PROC VALID
. Level L_TIPO_PROC VALID Hierarchy Depth: 1 (Lowest Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_TIPO_PROC_I
- .TP_ID_TIPO_PROC".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIPO_PROC_I
- .TP_DESC_TIPO_PROC".
. LevelAttribute SHORT DESCRIPTION VALID DimensionAttribute: "SHORT DESCRIPTION".
- LevelAttribute Type: "Short Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIPO_PROC_I
- .TP_CVE_TIPO_PROC".
.Validate Dimension: DMCGC0.D_TIPO_RESOL_I_DIM Type of Validation: OLAP API Verbose Report: YES
.Validating Dimension Metadata in OLAP Catalog 2 Date: 2004 JUNIO 08 Time: 10:55:11 User: DMCGC0 030715
.ENTITY TYPE ENTITY NAME STATUS COMMENT
. Dimension DMCGC0.D_TIPO_RESOL_I_DIM VALID Default Display Hierarchy: "H_TIPO_RESOL".
. DimensionAttribute LONG DESCRIPTION VALID DimensionAttribute Type: "Long Description".
. DimensionAttribute SHORT DESCRIPTION VALID DimensionAttribute Type: "Short Description".
. Hierarchy H_TIPO_RESOL VALID
. Level L_RESOLUCION VALID Hierarchy Depth: 1 (Lowest Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_TIPO_RESOL_I
- .TR_ID_RESOL".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIPO_RESOL_I
- .TR_DESC_RESOL".
. LevelAttribute SHORT DESCRIPTION VALID DimensionAttribute: "SHORT DESCRIPTION".
- LevelAttribute Type: "Short Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIPO_RESOL_I
- .TR_CVE_RESOL".
. Level L_TIPO_RESOL VALID Hierarchy Depth: 2 (Top Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_TIPO_RESOL_I
- .TR_ID_TIPO_RESOL".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIPO_RESOL_I
- .TR_DESC_TIPO_RESOL".
. LevelAttribute SHORT DESCRIPTION VALID DimensionAttribute: "SHORT DESCRIPTION".
- LevelAttribute Type: "Short Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIPO_RESOL_I
- .TR_CVE_TIPO_RESOL".
.Validate Dimension: DMCGC0.D_TIPO_RESOL_IMPUG_I_DIM Type of Validation: OLAP API Verbose Report: YES
.Validating Dimension Metadata in OLAP Catalog 2 Date: 2004 JUNIO 08 Time: 10:55:11 User: DMCGC0 030715
.ENTITY TYPE ENTITY NAME STATUS COMMENT
. Dimension DMCGC0.D_TIPO_RESOL_IMPUG_I_DIM VALID Default Display Hierarchy: "H_TIPO_RESOL_IMPUG".
. DimensionAttribute LONG DESCRIPTION VALID DimensionAttribute Type: "Long Description".
. Hierarchy H_TIPO_RESOL_IMPUG VALID
. Level L_RESOLUCION_IMPUG VALID Hierarchy Depth: 1 (Lowest Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_TIPO_RESOL_IMPUG_I
- .RI_ID_RESOL_IMPUG".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIPO_RESOL_IMPUG_I
- .RI_DESC_RESOL_IMPUG".
. Level L_TIPO_RESOL_IMPUG VALID Hierarchy Depth: 2 (Top Level).
. LevelMap VALID Mapped Column: "DMCGC0.D_TIPO_RESOL_IMPUG_I
- .TRI_ID_TIPO_RESOL_IMPUG".
. LevelAttribute LONG DESCRIPTION VALID DimensionAttribute: "LONG DESCRIPTION".
- LevelAttribute Type: "Long Description".
. LevelAttributeMap VALID Mapped Column: "DMCGC0.D_TIPO_RESOL_IMPUG_I
- .TRI_DESC_TIPO_RESOL".
PL/SQL procedure successfully completed.
SQL> execute cwm2_olap_manager.End_Log;
PL/SQL procedure successfully completed.
SQL> execute cwm2_olap_manager.Set_Echo_Off;
PL/SQL procedure successfully completed.
SQL> spool off

Go to See the other 9 answers

Error in Running a dimension ( BIB-9509 Oracle OLAP did not create cursor.)

Category:DefaultRelease time:2015-10-11Views:130

oracle.dss.dataSource.common.QueryRuntimeException: BIB-9509 Oracle OLAP did not create cursor. oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionManagerS[More]

BIB-9509 Oracle OLAP doesn't have  created the cursor

Category:DefaultRelease time:2015-10-11Views:130

Hello, I'm using Oracle Analytic Workspace Manager 10.1.0.4 on a database 10g enterprise edition 10.1.0.3.0. When I create a cube with more then 10 dimensions, it gives me the error: BIB-9509 Oracle OLAP non ha creato il cursore. oracle.express.idl.u[More]

BIB-9509 error when trying to create query on 7 Dimensional Measure

Category:DefaultRelease time:-0001-11-30Views:130

PART1 of the text below ----------------------------- Is there a limit on the ability to create a bibean query on measure that is associated with a large number of dimensions. Basically I am trying to create a bibean query on measure which has 7 dime[More]

BIB-9509 on Cube Viewer

Category:DefaultRelease time:-0001-11-30Views:130

After generating a cube with 4 dimensions, the error message below was returned. When only using 3 dimensions everything was fine. Now I can't view any cubes, either 3 or 4 dimensions. BIB-9509 The Olap Service did not create cursor. oracle.express.E[More]

BIB-9509 and ORA-00600, ORA-06512

Category:DefaultRelease time:-0001-11-30Views:130

============================================================================ Queries on the following measures or dimensions failed (S=Schema, C=Cube, M=Measure, D=Dimension) "Cantitate vanduta" measure query with S=ANA, C=CUB1, M=CANT_VANDUTA &[More]

BIB-9509: please help to fix

Category:DefaultRelease time:-0001-11-30Views:130

BI Beans Diagnostics(v1.0.2.0) 3/29/05 =============================================================================== JDEV_ORACLE_HOME .......................... = c:\JDeveloper JAVA_HOME ................................. = c:\JDeveloper\jdk JDevelo[More]

BIB-9509

Category:DefaultRelease time:-0001-11-30Views:130

I´m trying to create a crostab with one fact and 6 dimensions. i[m using Jdeveloper 9.0.3.10.90 and Oracle9i Enterprise Edition Release 9.2.0.4.0. In Query builder in the dimensions tab, when i select one of my dimensions, just that one, i cant pass[More]

BIB-9509 OLAP can't create cursor

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have this BIB-9509 when I try to create a report or graphic. I've seen when I use a fact table with 2 or 3 dimensional tables the Bi Beans work without problem but when I use more than 4 dimensional tables I find the BIB-9509 error. Anyone know[More]

BIB-9509 Oracle OLAP did not create cursor.

Category:DefaultRelease time:-0001-11-30Views:130

I am getting following error. How can this be resolved? BIB-9509 Oracle OLAP did not create cursor. oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionMana[More]

BIB-9509  - Oracle olap can't create cursor

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have this BIB-9509 when I try to create a report or graphic. I've seen when I use a fact table with 2 or 3 dimensional tables the Bi Beans work without problem but when I use more than 4 dimensional tables I find the BIB-9509 error. Anyone know[More]

Facing Error - BIB-9509 Oracle did not create cursor

Category:DefaultRelease time:-0001-11-30Views:130

Hi All , While Creating Crosstab/Graph I am facing one error " Unable to apply all the settings to the Presentation". BIB-9509 Oracle did not create cursor OracleExpress server ExceptionError. Require help.. Regards, ViSHAL.Hi All , While Creati[More]

Hot
I have tried unchecking the option "Open at startup" found when you higlight the program while it is in the dock.  I have also gone into Preferences/Users and Groups and none of the programs that I do not want to open at startup are in the list. [More]
After the latest itunes update I can no longer see my iPhone listed on the left column. How can I get to the section where I can pick & choose apps etc to be synced? Also I had to get a new iPhone & so I backed up the night before to the cloud &am [More]
Just updated to OS7 with a password. 4 yr old grand daughter ear just disabled my iPhone trying to figure out the password. I can only make emergency calls!!! How do I fix my phone?iOS: Forgotten passcode or device disabled after entering ... - Suppo [More]
Hi, i am trying to create a outbound delivery vl02n but picked qty field is disabled. can any on pl help me? Basically i am trying to do a STO with delivery. betw..plant to plant in same company code. How to activate that field. In LT03 also system i [More]
I am new to computers and even even less familiar with mac so I need some help. Every time I open Iphoto it says "you have ten photos in your iphoto library that have not been imported would you like to import these photos now" if I choose no it [More]
When I click on the Fullscreen [   ] Icon on YouTube, the video completely stops, then goes into another desktop, then it starts loading(buffering) again. Then when I click to go out of fullscreen the video stops again. This only happens on Safari, m [More]
hey! so i was do a AHT on my macbook pro retina and their was a error 4SNS/1/40000001:1DOR-0.000 need help thanks!Welcome to Apple Support Communities It looks like you ran Apple Hardware Test without plugging the MacBook to the charger. It's normal [More]
Hello I just recently successfully upgraded to leopard and everything seems like it's running fine but one thing i noticed is that it seems that leopard takes longer to startup. I also find that when I try to log out the beach ball rolls forever and [More]
Hi, We want  request from security stage to forward request to  next stage specific SOX approver.i saw forward request is allowed only with in the stage.Is there any option for one stage to forward request to next stage specific approver. Thanks Yako [More]
for some reason after the last time i did a shutdown the mac now does not start up. I enter the password ,( correctly , i checked for caps lock etc..) it seems to accept it and then it blinks and takes me back to the login . The same thing happens on [More]