CUBE Processing taking long time

Comanchi 6 Reputation points
2021-09-13T23:58:34.337+00:00

Hi All,
I have a cube that takes 40 mins to process, i tried processing the corresponding DIMS and then the CUBE, still the same time. The FACT has 60million rows. I looked at the partition and it is TABLE binding, i want to do it as a SQL binding on DATE, but there are multiple dates and i am not sure how to do it . Please advice.
Thanks

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,256 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. CarrinWu-MSFT 6,866 Reputation points
    2021-09-14T02:12:18.713+00:00

    Hi @Comanchi ,

    Welcome to Microsoft Q&A!

    Have you try to use SQL Server Profiler to get more information? Such as which dimension or measure group takes long time to process, this is the first step to tune cube processing performance. For more information, please refer to Tuning Cube Processing Performance.

    Best regards,
    Carrin


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Comanchi 6 Reputation points
    2021-09-14T02:30:57.693+00:00

    @CarrinWu-MSFT thanks, i have to ask my DBA to run a trace, but it is definitely not the dimensions as i processed the DIMS and they each one took a minute to 9 minutes. I created a VIEW and replaces the FACT in the DSV with the VIEW ( has some calculations), still no luck.

    The FACT in DSV is a named Query that has many calculations, so i crated a VIEW to by pass that in the cube processing , but that did not make it any slower , instead it became slower.

    Thanks

    0 comments No comments

  3. CarrinWu-MSFT 6,866 Reputation points
    2021-09-14T06:09:20.697+00:00

    Hi @Comanchi , have you check the CPU usage and memory? And which model did you created, tabular or multidimensional model? If you are using tabular model, please noted that memory is so important to Tabular. The easiest tool with which to monitor Tabular is the Task Manager. It already provides much information about memory and CPU usage, and it is available on any Windows installation to any user, without requiring special knowledge or administrative rights.