1 Reply Latest reply: Sep 23, 2008 2:36 AM by 634173 RSS

    Please, Help me

    524228
      i am trying to get the data for a specific time range. i wrote this code to get the time range from the past year to year 1999, but the query exception is thrown..


      Vector yearId = new Vector();
      yearId.addElement("
      MDM!D_CS_OLAP.SHAWT_TIME.CALENDAR.L.CAL_YEAR");

      RangeTimeStep rts = new RangeTimeStep(
      "MDM!D_CS_OLAP.SHAWT_TIME", //timeDimensionID
      "MDM!D_CS_OLAP.SHAWT_TIME.CALENDAR", //timeHierarchyID
      yearId, //yearID inside Time Dim
      new Integer(1), // one year
      RangeTimeStep.BEFORE, //before
      "1999"); //1999

      Selection timeSel = query.findSelection("MDM!D_CS_OLAP.SHAWT_TIME");
      timeSel.removeAllSteps();
      timeSel.addStep(rts);
      query.applySelection(timeSel);
      query.refreshAll();


      but the following exception is thrown:

      racle.dss.dataSource.common.QueryException:
      Step: oracle.dss.selection.step.RangeTimeStep;
      Enabled: true Valid: true Action: SELECT; Dimension: MDM!D_CS_OLAP.SHAWT_TIME; Hierarchy: MDM!D_CS_OLAP.SHAWT_TIME.CALENDAR
      Levels: [MDM!D_CS_OLAP.SHAWT_TIME.CALENDAR.L.CAL_YEAR]
      Num values: 1; Operator: Before; Reference value: 1999

      oracle.dss.dataSource.LocalStepRuntimeException:
      Step: oracle.dss.selection.step.RangeTimeStep;
      Enabled: true Valid: true Action: SELECT; Dimension: MDM!D_CS_OLAP.SHAWT_TIME; Hierarchy: MDM!D_CS_OLAP.SHAWT_TIME.CALENDAR
      Levels: [MDM!D_CS_OLAP.SHAWT_TIME.CALENDAR.L.CAL_YEAR]
      Num values: 1; Operator: Before; Reference value: 1999Process exited with exit code 0.

      Message was edited by:
      Java Eyes