SQL Server Performance

To Generate Running total across the Years

Discussion in 'Analysis Services/Data Warehousing' started by jitendra, Sep 27, 2006.

  1. jitendra New Member

    I have a daywise stock Qty in(+) and stock Qty out(-) entries.
    To arrive at a transactionwise balance stock I need to generate running
    total. I need to provide this in Cube with Excel front end. So when the user will
    check the Time dimension with Year, Quarter, Month and Day levels.

    He can go on to any level and the balance stock of that level should be displayed.

    Can anyone help me in this?
  2. mmarovic Active Member

  3. Madhivanan Moderator

Share This Page