MDX Utility Belt of Calculations Part 2

Who is online?  0 guests and 0 members
Home  »  Blogs  »  DevinKnight  »  MDX Utility Belt of Calculations Part 2
 
0
/5
Avg: 0/5: (0 votes)

Comments (3)

benagee
benagee said:
I have the following similar equation where the first [Date] is the name of the date dimension, [Fiscal Calendar] is the hierarchy, the next [Date] is the name of the field with the individual dates. [Fresh Caustic End Inv] is the value of the inventory stored in the Measure group. The formula below was supposed to calculate the beginning inventory (i.e., the previous days ending inventory). It returns #VALUE# -- what do I have wrong? ([Date].[Fiscal Calendar].[Date].PrevMember,[Measures].[Fresh Caustic End Inv])
12/8/2009
 · 
 
by
DevinKnight
DevinKnight said:
Try it without the hierarchy. So should look like this ([Date].[Date].PrevMember,[Measures].[Fresh Caustic End Inv])
12/8/2009
 · 
 
by
benagee
benagee said:
To follow up with everybody..... here is the final formula that worked: ([Date].[Fiscal Calendar].CurrentMember.PrevMember,[Measures].[Fresh Caustic End Inv])
12/9/2009
 · 
 
by
Blogs RSS Feed

DevinKnight's latest blog posts

Blogs RSS Feed

Latest community blog posts