I have an xmla query that is 10.8 megs, to generate a full SSAS DB with partitions.
After a certain size the editor stops working, I cannot copy paste from/to it, I get memory errors when trying to save and when I try to execute the query, nothing happens.
I have tried on several different machines to rule out a resource issue.
I haven't found anything related to xmla limit that's out there.
Anyone aware of a limit in this area? And if there is, does SQL 2012 remedy it?