Forum Discussion
Is there a way to write table data into the SSAS tabular model?
Hello!
No, OLAP cubes are not designed for DML operations (insert, update, delete). In traditional data warehouse or data mart scenarios you need to have a database (SQL Server for example) and schedule ETL loads to update the data frequently in the SQL database. After that, you can schedule jobs to process the OLAP cubes, that is, update the data according to recent modifications made to the SQL database.
Hello!
No, OLAP cubes are not designed for DML operations (insert, update, delete). In traditional data warehouse or data mart scenarios you need to have a database (SQL Server for example) and schedule ETL loads to update the data frequently in the SQL database. After that, you can schedule jobs to process the OLAP cubes, that is, update the data according to recent modifications made to the SQL database.