I am executing an MDX query from T-SQL. I am using OpenQuery, and there is a need to allow the query to go beyond 4 or even 8 thousand character limit as it includes a number of query scoped calculated members that encapsulate business logic.
How can I go beyond this limit without much trouble? Suggestions are very welcome
Unless you can do multiple separate queries within the limit of 8K, I don't see a way as the limitation is stated in the BOL.Premature optimization is the root of all evil in programming. (c) by Donald Knuth