I have a MDX select statment that I had working in DTS, I need to get it to
work in SSIS and I have not been able to figure out how does any one have any
suggestions. I have been trying to get it to work using The anayalsis
services Execute DDL Task, but can't get it to work.
The MDX select is listed below
with member [Measures].[TimeDisplayName] as '
[Discharge].Currentmember.Name+"-"+[Discharge].[Parent.Name'
Select { [Measures].[TimeDisplayName], [Measures].[CaseCount],
[Measures].[Admit Feeding]} on Columns,
CrossJoin({[Facility].[Regcode].Members,[Facility].[Natcode].Members},[CMG].Members) ON rows
FROM [udspro_region]
WHERE [Discharge].[All Discharge].LastChild.LastChild

I think I have to convert this to XMLA somehow, but all attempts I have made
have failed.