Selecting Members when creating a KPI is really really slow RRS feed

  • Question

  • Hi,


    I'm trying to make a KPI.  I have a cube I'm using as a datasource.  When using the Dimensional Data Source Mapping screen, I try to add a dimension.  I select a dimension that has a hierarchy.  When the window opens to select the member, it hangs when trying to drill down in the hierarchy.


    The msmdsrv.exe is pegged at 99%.  I eventually get an error stating I lost connection to the server.


    Any ideas on why this is so slow.  When I use Excel and just use a pivot table I can navigate through the hierarchy very quickly.



    Friday, April 11, 2008 7:16 AM


  • Hi JeffA,


    Is the slow reaction only for a particular cube? Are you able to test this scenario on the dimensions contained in the AdventureWorks OLAP DB and see if you get the same behaviour?




    Wednesday, April 16, 2008 7:49 PM