Hi All, We have a cubeview that is taking much longer than we would expect. It can take up to 4 minutes to run or, in some cases, it keeps going forever and we have to logout and abort. The cub...
Hi miked , Can you post the XFBR String for Time as your columns, and both XFBR Strings for UD3 and Account in the Rows? Are you using suppression on either the Rows or Cols? There are techniques for improving performance when using suppression, in general it is pertinent to know how Cube Views render and the sequence of Rows and Cols, and then the Row Overrides and Col Overrides. This here is a performance improvement setting for Allow Sparse Row Suppression setting - True (but determine sparse rows using other columns).
My best guess is that it is explainable.
Hope this helps and would gladly continue the conversation with you as you provide additional info.