Dynamic Named Sets used in Calculated Members slow down all queries - by Gerhard Brueckl

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 1049569 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 12/8/2014 3:52:49 AM
Access Restriction Public


When dynamic named sets are used in combination with calculated members all queries against that cube are affected even if the calculated member is not used in the query. 
for details please check my blogpost on that topic: http://blog.gbrueckl.at/?p=685
Sign in to post a comment.
Posted by Alexei Stoyanovsky on 5/19/2016 at 1:48 AM
This bug has been missing the comment that this design decision is questionable at best
Posted by pdigrego on 2/11/2016 at 2:38 AM
this is really problematic in to context of a report issuing multiple select in one session and where an expensive dynamic set needs to be used in only one query.
Any workaround to propose ?
Posted by Jonimatix on 7/21/2015 at 2:26 AM

The status is set to Resolved. Can you please indicate the solution, as this issue is really annoying?
This problem is prohibiting us from using Dynamic Sets at all..