1 Reply Latest reply on Aug 20, 2012 10:21 PM by user7853353

    Cumualtive Sum over User Defined Time Dimension

    user7853353
      Hoping that someone could explain how to use an Olap expression to determine the cumulative sum over a hierarchy.

      I have a Date Dimension with levels:

      DAY,WEEK,MONTH,YEAR

      And a Time dimension with levels:

      ALL_TIME,HOUR,MIN

      How can I perform a cumulative SUM of a measure over my Time Dimension?

      I get the following error:

      An error has occurred on the server
      Error class: Express Failure
      Server error descriptions:
      DPR: cannot create server cursor, Generic at TxsOqDefinitionManager::generic<CommitRoot>
      INI: XOQ-02000: PrimaryDimension "SH_OLAP.TM" is not a valid TimeDimension for the time series expression., Generic at TxsOqSyntaxPrinter::checkIsTimeDimension

      With the following expression.

      SUM(SH_OLAP.SALES) OVER (HIERARCHY TM.STANDARD BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN LEVEL)

      TM in this case is my Time dimension.