Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jas2005
Starting Member
11 Posts |
 Posted - 2008-08-01 : 02:51:10
|
| Dear All,i have a issue with MDX script if i using current system current date to get my YTD amount.1.>MDX Script ( Hardcode the criteria, the year as [May 08]))with member [Measures].[Today] AS format(vba!now(), "MMM") + ' ' + format(vba!now(), "yy") member [Measures].[Budget] AS SUM(PEriodsToDate ([Period Master].[Fiscal Period].[Financial Year], [Period Master].[Fiscal Period].[May 08]), [Measures].[Budget Amount] ) select [Measures].[Budget] on 0 from [Management PL] where [Reporting Group].[Reporting Group Hierarchy].[Revenues]>> Correct result shown. The budget amount is sum up May 2008. Budget column = 66500.332.>MDX Script ( dynamics criteria which take the current calendar date is May 2008 ) with member [Measures].[Today] AS format(vba!now(), "MMM") + ' ' + format(vba!now(), "yy") member [Measures].[Budget] AS SUM(PEriodsToDate ([Period Master].[Fiscal Period].[Financial Year], [Period Master].[Fiscal Period].currentMember = [Today]), [Measures].[Budget Amount] ) select [Measures].[Budget] on 0 from [Management PL] where [Reporting Group].[Reporting Group Hierarchy].[Revenues]>> Result shown '#Error' in the budget column.Please help, how to rectify my MDX script !!!thanks in advanceregardsJas |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-08-04 : 03:08:05
|
| Try removing "= [Today]" |
 |
|
|
jas2005
Starting Member
11 Posts |
Posted - 2008-08-05 : 02:05:45
|
| i can't cause i need current date as my mdx result filter criteria.~j~A~s |
|
|
|
|
|
|
MDX script: Show the YTD amount using calendar dat