tabular-model Archives

How to emulate performant date dimension for SSAS model in tabular mode / direct query

By adminPosted on October 8, 2022

Question : I have an indexed datetime column – lets call it “CreatedDateUTC” in table “Entity” in MSSQL db. Column […]

By adminPosted on August 25, 2022

Question : I read couple of articles about QueryMode in Tabular. I finally noticed that hybrid modes (DirectQuery with In-Memory […]

By adminPosted on August 23, 2022

Question : I have a SSAS Tabular server with 30 database. I also have a scheduled process to backup all […]

By adminPosted on May 7, 2022

Question : I have a SQL 2016 SP1 SSAS Tabular Instance. I’ve deployed a model with the following properties When […]

By adminPosted on March 19, 2022

Question : I have a tabular cube with a large partitioned table. I’d like to truncate some of the partitions […]

By adminPosted on December 8, 2021

Question : I am using visual studio 2015, sql server 2016 and tabular model 1200. I am trying to create […]

By adminPosted on October 27, 2021

Question : I use SQL Server 2012 and SSAS Tabular Mode (My Instance Name Is MSSQLSERVER2012T) Then I download AdventureWorks […]

By adminPosted on July 24, 2021

Question : I have a cube that all the tables has one row per ID and have measure in all […]

By adminPosted on May 8, 2021

Question : I have a SSAS Tabular server with 30 database. I also have a scheduled process to backup all […]

By adminPosted on January 2, 2021

Question : I have an indexed datetime column – lets call it “CreatedDateUTC” in table “Entity” in MSSQL db. Column […]