locked
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.

     

    Thanks.

    Friday, April 11, 2008 7:16 AM

Answers

  • 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?

     

    Cheers,

    Nick

    Wednesday, April 16, 2008 7:49 PM