Finding rolling costs for 13 months

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  bi query languages (mdx, dmx)   » Finding rolling costs for 13 months

Finding rolling costs for 13 months

Topic RSS Feed

Posts under the topic: Finding rolling costs for 13 months

Posted: 9/6/2010

Jedi Youngling 6  points  Jedi Youngling
  • Joined on: 9/6/2010
  • Posts: 3

Hi Experts,
I need urgent help on this issue

I have a formula

'Sum(LastPEriods(13, CLosingPeriod([Rolling Date].[Month], [Rolling Date].CurrentMember)), [Measures].[Waste Costs])'

which calculates rolling costs for last 13 months
e.g today current month + last 12 months

,but when i drill down to hierarchy level 8 it shows me few records of year 2006 also,i think this shuld not be case,coz formula should show me records till july 2009 (assuming go back 13 months from current date)

can you please guide me are there any corrrections in this formula or if i m going to level 8 -drill down then it will include costs for 2006 also?
I'm unable to make any firm conclusion on this


Posted: 9/7/2010

Jedi Master 4924  points  Jedi Master
  • Joined on: 10/27/2009
  • Posts: 272

Could you explain a little more. What is hierarchy level 8?


tags MDX

Posted: 9/7/2010

Jedi Youngling 6  points  Jedi Youngling
  • Joined on: 9/6/2010
  • Posts: 3

here level means ......

level1

 

 

country

 

 

e.g US or UK etc

 

 

level2

 

 

state

 

 

 

level3

 

 

district

 

 

 

level4

 

 

city

 

 

 

level5

 

 

town

 

 

 

level6

 

 

plant

 

 

 

level7

 

 

department

 

 

 

level8

 

 

sub department

 

 

 

level9

 

 

machine

 

 

 

Please help me in this


Posted: 9/7/2010

Jedi Master 4924  points  Jedi Master
  • Joined on: 10/27/2009
  • Posts: 272

Instead of drilling down, what happens when you just browse directly to level 8?

It looks like the measure could be, mapped to the this dimension in a way that makes the month not count back correctly.


tags MDX

Posted: 9/8/2010

Jedi Youngling 6  points  Jedi Youngling
  • Joined on: 9/6/2010
  • Posts: 3

how to traverse to level 8 directly?

earlier I was traversing to the path

Paris-->manufacturing dept-->cc pant line 10-->p10 Adhesives Process-->P10 Elastics System

and checked dates that I found it's including 2006 dates also

 

 

 

Now i traversed to the path

P10 Elastics System directly still I'm seeing the same result

Also I traversed to the path  paris-->manufacturning dept and I checked the dates I found it's calculation last 13 month's data

is the formula wrong?

or in case drill down it will find the records associated to child level also

Like i found the formula has scope till paris-->manufacturning dept  and i observed scope of formula ends if i'm drilling down the data

 

can you please recheck again this?

Thanks in advance for your help


Page 1 of 1 (5 items)