chulataxing
New Member
\[code\]SELECT {} ON COLUMNS,EXCEPT( EXCEPT( DESCENDANTS([Disposition].[Disposition Hierarchy].[Disposition Eligibility].&[Eligible],,SELF_AND_AFTER) ,[Disposition].[Disposition Hierarchy].[Disposition Group].&[Ungrouped Eligible] ) ,[Disposition].[Disposition Hierarchy].[Disposition Code].&[030] ) ,EXCEPT( DESCENDANTS([Disposition].[Disposition Hierarchy].[Disposition Master].&[Total],,SELF_AND_AFTER) , {DESCENDANTS([Disposition].[Disposition Hierarchy].[Disposition Eligibility].&[Eligible],,SELF_AND_AFTER) , DESCENDANTS([Disposition].[Disposition Hierarchy].[Disposition Group].&[None],,SELF_AND_AFTER) ,[Disposition].[Disposition Hierarchy].[Disposition Group].& [Duplicate / Recently Contacted]} ) ON ROWSFROM CUBE\[/code\]I want to create a field in SSRS so I can use the data to populate a Column in my table. How would I query a new field where Field Source would be in XML format?