Running totals in olap

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

Running totals in olap

Post 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
Marcus Scherer
Community Contributor
Posts: 126
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016
Location: Karlsruhe

Re: Running totals in olap

Post by Marcus Scherer »

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

Mtd(Member_Expression)

HTH,

Marcus
Post Reply