This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 11%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Hi All,
While using the CUBE Browser or PowerBI or SSRS, it is taking forever to render the data , doe's the report rendering depend upon the space available on the DRIVE? It is a Multidimensional CUBE. Please suggest.
Thanks
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.
Hi @Amy Jandreau , we have not get a reply from you. Could below answers help you? If yes, please do "Accept Answer". By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!
Hi @Amy Jandreau ,
Thanks for your posting.
doe's the report rendering depend upon the space available on the DRIVE?
The performance issues are depend on various reasons, it may cause by slow queries, disk, memory, or CPU. You should find the root cause of bad performance issue first. For more information, please refer to SSAS - Best Practices and Performance Optimization.
Best regards,
Carrin
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.
@CarrinWu-MSFT Thanks. Here is scenario. My CUBE has a FACT with 50 million rows. It took 30 mins to process and almost 15 mins to render data from this cube. I created Partitions by years
SELECT *
FROM FACT
WHERE YEAR=2010
I created 11 partitions and now the process of the cube is taking over an hour. I thought partitions will increase the performance.
Thanks
Hi @Amy Jandreau , thanks for your replying. Please using SQL Server Profiler to monitor your partition. On the Trace Properties dialog choose the Blank template and go to the Events Selection tab and check the following:
• Progress Reports\Progress Report Begin
• Progress Reports\Progress Report End
• Queries Events\Query Begin
• Queries Events\Query End
• Query Processing\Execute MDX Script Begin
• Query Processing\Execute MDX Script End
• Query Processing\Query Cube Begin
• Query Processing\Query Cube End
• Query Processing\Get Data From Aggregation
• Query Processing\Query Subcube Verbose
• Query Processing\Resource Usage
At this point in the cube optimization process you should be seeing in Profiler that when your users run queries they hit as few partitions as possible and hit aggregations as often as possible. If you regularly see queries that scan all the partitions in your cube or which do not use any aggregations at all, you should consider going back to the beginning of the process and rethinking your partitioning strategy and rerunning the aggregation design wizards. In a production system many queries will be answered from cache and therefore be very quick, but you should always try to optimize for the worst-case scenario of a query running on a cold cache.
And also, here has a similar thread you could refer.