Blank error when trying to create cube file from excel PivotTable

Oleg Kaverin 1 Reputation point
2020-12-17T18:10:47.343+00:00

From an excel pivotTable connected to a SSAS cube I tried to create offline cube file, choose minimum measures and one dimension and chose location for storage, but when pressing Finish when the progress starts I get an blank error with a red X and :

49254-1111.gif

How to create an offline file?

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,249 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points
    2020-12-18T02:08:13.977+00:00

    Hi,

    Are you trying to create an offline cube for Multidimensional OLAP or Tabular cube ?

    If this is multidimensional cube, try check the user permission see if it has access to the cube and check if you could create .cub file with other measure or user account.

    If you are trying to create .cub file with SSAS Tabular model, unfortunately it is currently not support. The OLAP Offline feature in Excel is just for Multidimensional Cube. I

    Regards,
    Lukas


    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.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November

    1 person found this answer helpful.