Failed to build the OLAP cubes

• ramana3327

  SSCoach

  Points: 19572

  More actions

  May 20, 2022 at 3:44 am

  #4035973

  Hi,

  We installed default standalone SSAS in tabulator mode (SQL 2017 license). When they run build the cube, it failed with below error

  Failed to build the OLAP cubes. ERROR: Failed to create the olap database: Error: Database DBName has compatibility level larger than 1103 with StorageEngineUsed set to InMemory. Tabular databases with compatibility level at 1200 or above must use Storage Engineused set to TabularMetadata.

  we didn’t change any settings while installing. Where & what to change the SSAS storage engine type

   

• Site Owners

  SSC Guru

  Points: 80338

  More actions

  May 21, 2022 at 4:10 am

  #4036548

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.