Running totals in olap

Post Reply
Posts: 2
Joined: Tue Apr 27, 2010 10:56 am
OLAP Product: SQL 2008
Excel Version: 2007

Running totals in olap

Post by pagiu » Thu Oct 14, 2010 10:19 pm

Hi, I am trying to do a stock valuation cube , whereby I need to sum up quantities in a given period. My problem is that if you analyse the data as at a date, you are given the value for the date and not the value from day one. is there a particular option such as running totals in olap - I am using Bids 2008.

my email is

Marcus Scherer
Community Contributor
Posts: 125
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 9.5 10.1 10.2
Excel Version: 2007
Location: Karlsruhe

Re: Running totals in olap

Post by Marcus Scherer » Sat Oct 16, 2010 4:47 pm

for MonthToDate (MTD) you could use the following function:




Post Reply