Best Performance: Data Centric Cube (very detailed) Tabular cube or Pivot reading a View

Ismail Cassiem 226 Reputation points
2021-09-09T11:02:35.897+00:00

Good day,

I have a data set of 2million records, however finance users setup OLAP Tabular via Excel with lots of attributes to see detail
they don't filter down the view, they like seeing all Age records for current day vs history day snapshot

or should i scrap the cube, make users think its a cube but have pivot connected to View

i think performance wise it will be better than tabular cube as the cube struggles when viewing 5000 rows, But the view option doesn't allow for calculations but knowing the audience they going to setup multiple templates with the goal analytical view in PowerBI performance is going to be key

Thoughts or better ideas please?

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,244 questions
0 comments

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,851 Reputation points
    2021-09-10T07:48:55.227+00:00

    Hi @Ismail Cassiem ,

    According to your question, are you trying to improve Excel's Cube Performance? If yes, please refer to Improving Excel's Cube Performance.

    And also, you could use Excel 2016 to get faster OLAP PivotTables. Please refer to Faster OLAP PivotTables in Excel 2016 and Excel 2016 PivotTable MDX Changes Lead To Big Query Performance Gains.

    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
  2. Ismail Cassiem 226 Reputation points
    2021-09-10T18:56:04.667+00:00

    Hi,

    How do i upgrade to 2016, is there just an install i can send to users or is there a serial key involved?

    but our company is looking to go 0365 ?

    Regards

    0 comments
  3. Ismail Cassiem 226 Reputation points
    2021-09-11T16:31:12.397+00:00

    Other version of excel is not option now, how now?

    0 comments
  4. Ismail Cassiem 226 Reputation points
    2021-09-11T16:44:29.88+00:00

    Hi,

    1. I have o365 account but i dont want the web excel, how do i active o365 windows or 0365 16/19 windows?
    2. if i have o365 web or 0365 19 with no click install would this improve the performance as the links?

    Please help

    131199-excel.jpg

  5. Ismail Cassiem 226 Reputation points
    2021-09-13T16:24:48.667+00:00

    Hi, Thank You for helping

    I installed the o365 office suite install from web that contains Excel19 but there's not much difference in performance for cube

    i read that 0365 Click-To-Install (ProPlus) must be installed and not the default link and that Excel16 Click to install is faster than o365 excel19

    please how do i convert the install to click-to-install proplus because olap pivots are not faster

    ?

    0 comments