Deleting Specific Rows from a Tabular Table

Question

How can I delete specific rows from an AAS Tabular table? I basically want to do the equivalent of DELETE/FROM/WHERE in SQL.

Answer 1

Hi @james.h.robinson.csm@gmail.com ,

Thanks for posting the query.

Analysis services is not equivalent to relational database and it is used to develop semantic data model on data sources to use for ad-hoc data analysis. Unlike the SQL Server database engine, which supports online transaction processing (OLTP) of data in a relational database, the Analysis Services engine supports online analytical processing (OLAP) of data stored. You can not delete selected data from a tabular cube as you can do it in a database engine with SQL but partitions can be used to separate data that needs less processing or less used from the frequently modified data. This helps in avoiding any overhead due to the data that is less modified like historical data. Also, it can be dynamically done as in attached references.

Ref: ssas-tabular-data-delete-options, ssas-tabular-dynamic-partition

Hope this helps! Please let us know for further queries and we will be glad to assist.