Page 1 of 1

Running totals in olap

Posted: Thu Oct 14, 2010 10:19 pm
by pagiu
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 pagius@isl.com.mt

Re: Running totals in olap

Posted: Sat Oct 16, 2010 4:47 pm
by Marcus Scherer
for MonthToDate (MTD) you could use the following function:

Mtd(Member_Expression)

HTH,

Marcus