|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Sunday, September 28, 2008 2:50 AM
Points: 1,
Visits: 4
|
|
How to Sets CustomRollupColumn's Express to get data as follow:
DimItem
Year month week ItemName
2008 1 1 100.10
2008 1 2 100.20
2008 1 3 100.40
2008 1 4 100.90
2008 1 sum 100.10
2008 2 1 100.50
2008 2 2 100.20
2008 2 3 100.40
2008 2 4 100.90
2008 2 sum 100.50
2008 sum 100.10
I use the express as follow, but the cell show null
case
when [Date].[CalendarDate].CurrentMember.Level.Ordinal = 0
then
null
when [Date].[CalendarDate].CurrentMember.Level.Ordinal = 1
then
([Measures].[Amount],[AmountItem].[FinanceSubjectItem].&[1],[Date].[CalendarDate].CurrentMember.FirstChild.FirstChild.FirstChild)
when [Date].[CalendarDate].CurrentMember.Level.Ordinal = 2
then
([Measures].[Amount],[AmountItem].[FinanceSubjectItem].&[1],[Date].[CalendarDate].CurrentMember.FirstChild.FirstChild)
when [Date].[CalendarDate].CurrentMember.Level.Ordinal = 3
then
([Measures].[Amount],[AmountItem].[FinanceSubjectItem].&[1],[Date].[CalendarDate].CurrentMember.FirstChild)
else
([Measures].[Amount],[AmountItem].[FinanceSubjectItem].&[1],[Date].[CalendarDate].CurrentMember)
end
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 20,156,
Visits: 13,694
|
|
|
|
|
