RollUpChildren Not Working

hi all, trying use rollupchildren function , not working expecting. please see blow sample mdx, based on understanding same value rsa ressler sales amount measure, here rsa giving null?

with   member [measures].[rsa]  rollupchildren ([measures].[reseller sales amount],"+")    select       {       [measures].[reseller sales amount],       [measures].[rsa]       } on columns,       {       [geography].[geography].[country].&[united states]              } on rows          [adventure works]

---

thanks, gaurav
http://gauravsqlserver.blogspot.com

this because have passed measure rollup children , measures not have children. need pass member in hierarchy has children. rollup children using supplied unary operators.

so not create measure function, instead create calculated member in dimension.

eg.

with
member [geography].[geography].[united states test]as
rollupchildren ([geography].[geography].[country].&[united states],"-")

select
     {
     [measures].[reseller sales amount]
     } on columns,
     {
     [geography].[geography].[country].&[united states]

,[geography].[geography].[united states test]
    
     } on rows

      [adventure works]

---

http://darren.gosbell.com - please mark correct answers

SQL Server  >  SQL Server Analysis Services