Simple newbee question

#1

Hi,
I have cube with ArticleNumber, Date, Quantity
Quantity i + when article get in stock and - when he get out.
I need result which will give me for every day sum of previous day quantity
+ today quantity.
How to do that?

Thanks

Dubravko

#2

Look at the MTD and YTD functions in MDX.

#3

Quote:

Look at the MTD and YTD functions in MDX.

I need result to be like this:

1.1.2005 1.2.2005 1.3.2005 1.4.2005 1.5.2005
.... 1.31.2005
ArticleA 120 120 115 110 120
0
ArticleB 0 12 13 0
14 15
ArticleC 6 12 1 2
3 4
ArticleD 4 7 4 6
34 3

Where for ArticleA we have 120 on 1.1.2005 and -5 on 1.3.2005

#4

Maybe something like:

((Time.CurrentMember,[Measures].[ArticleA])+

(Time.CurrentMember.PrevMember,[Measures].[ArticleA]) )

VK

"Dubravko Modrusan" <dubravko (AT) recro (DOT) hr> wrote

Quote:

Look at the MTD and YTD functions in MDX.

I need result to be like this:

1.1.2005 1.2.2005 1.3.2005 1.4.2005 1.5.2005
... 1.31.2005
ArticleA 120 120 115 110
120
0
ArticleB 0 12 13 0
14 15
ArticleC 6 12 1 2
3 4
ArticleD 4 7 4 6
34 3

Where for ArticleA we have 120 on 1.1.2005 and -5 on 1.3.2005

#5

or
SUM(PeriodsToDate([Time].[(All)], Time.CurrentMember),[Measures].[ArticleA])

Quote:

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Simple newbee question

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Simple newbee question - 02-18-2005 , 03:12 AM

RE: Simple newbee question - 02-18-2005 , 07:41 AM

Re: Simple newbee question - 02-21-2005 , 04:34 AM

Re: Simple newbee question - 02-24-2005 , 07:16 AM

Re: Simple newbee question - 02-24-2005 , 07:45 AM