If you have followed the documented partitioning guidelines and query performance is still poor, collect the following information:
the Transformer log file from the cube build; shows how dimensions are partitioned and how well records are being consolidated
the populated model (.mdl or .py? file) and cube (.mdc file); the partition status shows partitioned categories and record distribution
an indication of which dimensions are most often queried, and the extent to which users of the PowerPlay client applications are querying at lower levels in your cube
details about problematic reports or exploration activities, such as slow performance when navigating alternate drills or nested levels in the PowerPlay client applications
We recommend that you forward this information to Cognos Software Services and let our experienced personnel investigate the problem.