5 Replies Latest reply on Jul 30, 2009 5:03 PM by 714866

    ent-06972:error while displaying bibean for dimension dataviewer

    598056
      1) I create a time dimension using time wizard with a Week Hierarchy:


      CREATE DIMENSION WK
      LEVEL "DAY" IS "SPINEMESSAGEDESIGNER"."WK"."DAY_ID"
      LEVEL "CALENDAR_WEEK" IS "SPINEMESSAGEDESIGNER"."WK"."CALENDAR_WEEK_ID"
      HIERARCHY "CALENDAR_STANDARD" (
      "DAY" CHILD OF
      "CALENDAR_WEEK"
      )
      ATTRIBUTE "DAY" DETERMINES ( "SPINEMESSAGEDESIGNER"."WK"."DAY_OF_CAL_WEEK", "SPINEMESSAGEDESIGNER"."WK"."JULIAN_DATE", "SPINEMESSAGEDESIGNER"."WK"."DAY_OF_CAL_QUARTER", "SPINEMESSAGEDESIGNER"."WK"."DAY_DAY_CODE", "SPINEMESSAGEDESIGNER"."WK"."DAY_TIME_SPAN", "SPINEMESSAGEDESIGNER"."WK"."DAY_NAME", "SPINEMESSAGEDESIGNER"."WK"."DAY_END_DATE", "SPINEMESSAGEDESIGNER"."WK"."DAY_DESCRIPTION", "SPINEMESSAGEDESIGNER"."WK"."DAY", "SPINEMESSAGEDESIGNER"."WK"."DAY_OF_CAL_YEAR", "SPINEMESSAGEDESIGNER"."WK"."DAY_START_DATE", "SPINEMESSAGEDESIGNER"."WK"."DAY_OF_CAL_MONTH" )
      ATTRIBUTE "CALENDAR_WEEK" DETERMINES ( "SPINEMESSAGEDESIGNER"."WK"."CALENDAR_WEEK_NAME", "SPINEMESSAGEDESIGNER"."WK"."CAL_WEEK_NUMBER", "SPINEMESSAGEDESIGNER"."WK"."CALENDAR_WEEK_END_DATE", "SPINEMESSAGEDESIGNER"."WK"."CALENDAR_WEEK_DESCRIPTION", "SPINEMESSAGEDESIGNER"."WK"."CALENDAR_WEEK_START_DATE", "SPINEMESSAGEDESIGNER"."WK"."CALENDAR_WEEK_CAL_WEEK_CODE", "SPINEMESSAGEDESIGNER"."WK"."CALENDAR_WEEK_TIME_SPAN" )
      ;

      2) Deployed the object and associated map, run the map.

      3) On the design Center, tried to view the data. Everything work. Data is showed in the Dimension data Viewer.


      4) I create another time dimension with a CALENDARSTANDARD Hierarchy and a Week Hierarchy:


      CREATE DIMENSION TM
      LEVEL "DAY" IS "SPINEMESSAGEDESIGNER"."TM"."DAY_ID"
      LEVEL "CALENDAR_MONTH" IS "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_MONTH_ID"
      LEVEL "CALENDAR_QUARTER" IS "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_QUARTER_ID"
      LEVEL "CALENDAR_YEAR" IS "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_YEAR_ID"
      LEVEL "CALENDAR_WEEK" IS "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_WEEK_ID"
      HIERARCHY "CALENDARSTANDARD" (
      "DAY" CHILD OF
      "CALENDAR_MONTH" CHILD OF
      "CALENDAR_QUARTER" CHILD OF
      "CALENDAR_YEAR"
      )
      HIERARCHY "CALENDARWEEK" (
      "DAY" CHILD OF
      "CALENDAR_WEEK"
      )
      ATTRIBUTE "DAY" DETERMINES ( "SPINEMESSAGEDESIGNER"."TM"."DAY_NAME", "SPINEMESSAGEDESIGNER"."TM"."DAY_OF_CAL_YEAR", "SPINEMESSAGEDESIGNER"."TM"."DAY_DESCRIPTION", "SPINEMESSAGEDESIGNER"."TM"."JULIAN_DATE", "SPINEMESSAGEDESIGNER"."TM"."DAY_OF_CAL_WEEK", "SPINEMESSAGEDESIGNER"."TM"."DAY_OF_CAL_QUARTER", "SPINEMESSAGEDESIGNER"."TM"."DAY_OF_CAL_MONTH", "SPINEMESSAGEDESIGNER"."TM"."DAY_DAY_CODE", "SPINEMESSAGEDESIGNER"."TM"."DAY_START_DATE", "SPINEMESSAGEDESIGNER"."TM"."DAY_END_DATE", "SPINEMESSAGEDESIGNER"."TM"."DAY", "SPINEMESSAGEDESIGNER"."TM"."DAY_TIME_SPAN" )
      ATTRIBUTE "CALENDAR_MONTH" DETERMINES ( "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_MONTH_NAME", "SPINEMESSAGEDESIGNER"."TM"."MONTH_OF_QUARTER", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_MONTH_START_DATE", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_MONTH_TIME_SPAN", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_MONTH_CAL_MONTH_CODE", "SPINEMESSAGEDESIGNER"."TM"."MONTH_OF_YEAR", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_MONTH_DESCRIPTION", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_MONTH_END_DATE", "SPINEMESSAGEDESIGNER"."TM"."CAL_MONTH_NUMBER" )
      ATTRIBUTE "CALENDAR_QUARTER" DETERMINES ( "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_QUARTER_DESCRIPTION", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_QUART_CAL_QUARTER_CO", "SPINEMESSAGEDESIGNER"."TM"."QUARTER_OF_YEAR", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_QUARTER_END_DATE", "SPINEMESSAGEDESIGNER"."TM"."CAL_QUARTER_NUMBER", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_QUARTER_NAME", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_QUARTER_START_DATE", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_QUARTER_TIME_SPAN" )
      ATTRIBUTE "CALENDAR_YEAR" DETERMINES ( "SPINEMESSAGEDESIGNER"."TM"."CAL_YEAR_NUMBER", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_YEAR_NAME", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_YEAR_DESCRIPTION", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_YEAR_END_DATE", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_YEAR_START_DATE", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_YEAR_TIME_SPAN", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_YEAR_CAL_YEAR_CODE" )
      ATTRIBUTE "CALENDAR_WEEK" DETERMINES ( "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_WEEK_CAL_WEEK_CODE", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_WEEK_DESCRIPTION", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_WEEK_TIME_SPAN", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_WEEK_START_DATE", "SPINEMESSAGEDESIGNER"."TM"."CAL_WEEK_NUMBER", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_WEEK_END_DATE", "SPINEMESSAGEDESIGNER"."TM"."CALENDAR_WEEK_NAME" )
      ;

      2) validate the object, OK.

      3) deployed the object, OK.

      4) On the design Center, select the first created dimension WK, tried to view the WK data. The above error poped up.

      Pleas help.