I am trying to bring back the expressison of a subset. The current dimension has about 2500 subsets. When I try to run the following code it takes forever and a day to retrieve a result. I have used this against smaller dimensions without issue (nearly instantaneous result), but there seems to be a performance threshhold somewhere based on the number of elements in the given arrays.
Code: Select all
SubMDX = _server.Dimensions[dimension].PublicSubsets[subsetName].Expression.ToString();Has anyone else experienced this type of slowdown? If so how did you get around it?