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
Hi, I want to genarate number ranges for remote system like a100 to z999. But in Console its allowing me to enter only numaric values only. could you please suggest me to achive this functionality. Thanks in Advance. Kiran.GHi Kiran, I want to genara [More]
I accidentally changed the magnification settings in Z10. I cant revrse it. please help Solved! Go to Solution.After you swipe from the top down from your home screen and select settings, then System settings shows up, it doesn't allow you to scroll [More]
We installed business package for PLM WEB User interface and we start playiong around with the POWL functionality. For some reason teh system ends in an error calling ....../sap/bc/webdynpro/PLMU/wda_wcc_myobj/ This is section Personal Object Worklis [More]
Hello folks, Has amyone encountered this exception? If so, could you please shed some light for what might be going wrong? Here is my confuguration: 400MB RAM 1.2GHTz processor Win2K Pro Oracle server 9.0.1 JDBC Thin driver (libs for 9.0.1) Scenario: [More]
Hi I have developed a PP report based on the templaate RBCA_PP_SIF_RUN_PP_TEMPLATE. The report is a simple selection and is supposed to write to the spool (success or error messages). Using WRITE <text> should write to the spool for every job under [More]
HI, I am getting this error frequently.. any recomendations : Executed as user: DB0\sqlservices. Processing database: dbin [SQLSTATE 01000] (Message 0)  Cannot shrink log file 2 (DB_log) because the logical log file located at the end of the file is [More]
Hello Experts, Is there an existing user exit in VA02 that can be used to add another menu item under menu Edit > Fast Change of ... I would like to add another item under that I can use to change the user status of the item. Thanks in advance. Regar [More]
I originally posted this, last night, to Using Mac OS X Leopard. I think I can get an answer here. That site rolls pretty fast. Here is my post: This story here is totally new to me. I have made bootable clones stored on external fw hd's. All work on [More]
Hello Gurus, i am printing many tables in a smartform. The problem is that when the page changes i have half of a table o the first page and another half on the second page. Can i set the table to be unbreakable, i mean that if there is no space on t [More]
I cannot see my iphoto pics in Lightroom or photoshop I am using the trial version however I do not find this user friendly in terms of importing at present it is frustrating and unless I get a solution I do not think I will purchase surely if you wa [More]