Questions tagged [tabular-model]

Tabular models are in-memory databases in SQL Server Analysis Services, an OLAP server bundled with SQL Server by Microsoft.

Filter by
Sorted by
Tagged with
0
votes
0answers
16 views

Help with the complex DAX measure

I am struggling with a DAX measure. Here is the fact and 2 dimension tables I have: factAction(dimAccountID, dimActionID, Date, ActionQty) dimAction(dimActionID, ActionCode, ActionDescription) ...
0
votes
2answers
524 views

StorageEngineUsed set to TabularMetadata. For databases in this mode, you must use Tabular APIs to administer the database

I am an administrator in SSAS. I have many data warehouse servers. In some servers I have SQL Server and SSAS on the same machine. I successfully backup the SSAS databases and even check if the ...
1
vote
2answers
974 views

The 'Database' with 'ID' = 'xxxxxxx' doesn't exist in the collection

I have a SSAS Tabular server with 30 database. I also have a scheduled process to backup all databases daily. When I run the process which is an SSIS package with script task using AMO, I get this ...
3
votes
4answers
4k views

The column 'Date Offset' in table 'Date' has invalid bindings specified

I'm trying to deploy a tabular model to a server using the "Analysis Services Deployment Wizard". When attempting to deploy,I get the below error. The JSON DDL request failed with the following ...
4
votes
2answers
5k views

SSAS Model Refresh - Not enough memory to complete this operation Error

We have started encountering an issue regarding the refresh of our tabular SSAS model. The tabular SSAS model has 38 tables within it. This process has been running without issue for over a year, ...
2
votes
1answer
418 views

SSAS Tabular model Date Dimension with Time possible?

I am in the process of building my first SSAS Tabular model and thought everything was going well, until trying to create a measure by DateTime. In my warehouse, I have a DIm_Time dimension, which ...
0
votes
1answer
228 views

Tracing tabular refresh errors

I have a tabular cube on an SQL Server 2017. The cube is refreshed with a full refresh command in a Server Agent job. The job runs on a schedule. When I check the history of the job I see that it ...
1
vote
1answer
871 views

Dynamic Partition on tabular model 1200 using visual basic 2015 in visual studio

I am using visual studio 2015, sql server 2016 and tabular model 1200. I am trying to create a dynamic partitions on the existing cube by creating SSIS package using script task and visual basic ...
0
votes
1answer
369 views

Link DAX OpenQuery Output to SQL Server Temp Table

I want to record measures from a Tabular model, as KPIs, and store the values in a table in SQL Server. I have created a linked server from my SQL Server instance to my SSAS instance. I have written ...
1
vote
1answer
793 views

How to move SSAS tabular instance databases?

We have a SQL Server 2012 SSAS tabular instance in our environment that is sitting in domain1. We need to move these SSAS databases in a different SQL server 2012 that is on domain2 which has no trust ...
2
votes
1answer
4k views

How do I tell which Edition and Version my SSAS Instance is running?

In SQL Server on the database engine, you can run a SQL query like this to get the server's version info like Edition and Version, and Update Level, etc. SELECT @@VERSION What is the MDX equivalent ...
0
votes
1answer
276 views

Multi condition DAX row filter

I am trying to convert the following SQL row level security function into a DAX filter within a Tabular model CREATE FUNCTION [Security].[fn_securitypredicate](@BrandID AS INT, @ChannelId AS INT) ...
1
vote
0answers
358 views

How make an SSAS Tabular model case sensitive?

I need to make my tabular model case sensitive. Currently my tabular model is case insensitive, how do I change my existing cube to be case sensitive?
1
vote
1answer
1k views

SSAS Tabular Cube partitioning - number of partitions

We ha a Fact table with 500 milions of rows (data from 10 years - 60GB). I've partitioned this table on database level and SSAS Tabular Cube level as well - one month per partition to improve the ...
2
votes
1answer
656 views

SSAS Tabular QueryMode Confusion. Why Hybrid mode is useful?

I read couple of articles about QueryMode in Tabular. I finally noticed that hybrid modes (DirectQuery with In-Memory and In-Memory with DirectQuery) are NOT useful for my case. Actually they are not ...
0
votes
1answer
434 views

How to truncate an SSAS Tabular partition

I have a tabular cube with a large partitioned table. I'd like to truncate some of the partitions (freeing the memory space), but retain the metadata, so that I can quickly rebuild them if required ...
1
vote
1answer
146 views

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

I have an indexed datetime column - lets call it "CreatedDateUTC" in table "Entity" in MSSQL db. Column contains UTC datetime. User connecting to db has known timezone offset. I have another table - ...
5
votes
1answer
15k views

SSAS Tabular: ImpersonationMode that is not supported for processing operations

I have a SQL 2016 SP1 SSAS Tabular Instance. I've deployed a model with the following properties When I try to process the database or a table I get an error "The datasource contains an ...
3
votes
1answer
1k views

Stop, Start, or Restart a SSAS Tabular service instance in PowerShell with Invoke-Command and $variables

I'm working on some PowerShell commands / scripts to stop, or start, or restart a SSAS Tabular service instance using Invoke-Command and some $variables. The end goal is to eventually put this code ...
1
vote
0answers
1k views

Improve SSAS Tabular query performance

I'be build a Tabular Cube with FactTable and four dimensions. Fact table has about 2.500.000 of rows (and about 20 calculated measures on the cube level) and dimension tables from 5k-50k of rows. When ...
0
votes
0answers
266 views

Which SQL Server Agent job is processing my tabular model database

I have a server called SANDBOX with two SQL 2014 instances SANDBOX\00 and SANDBOX\01. It also has a tabular model instance SANDBOX\TABULAR. Agent jobs are disabled on SANDBOX\01. There is no agent (as ...
1
vote
1answer
53 views

SSAS 2016 tabular : Discrepancy on countrows between measures visual studio vs Excel

Is anyone aware of a SSAS (tabular) 2016 in which the number of records in a table are not fully shown in Excel? Say that when working in Visual Studio, a table has a rowcount of 740,000 records. We ...
2
votes
1answer
1k views

Remove Data From Memory when Using SSAS Tabular In-Memory Mode

I use SSAS Tabular in In-Memory mode. I also use partitions to divide my data. So I will have one partition per month. AFAIK, when using In-Memory mode, server keeps processed data in memory forever....
1
vote
2answers
2k views

SSAS tabular browse Excel relationships not working

I'm currently building an education data warehouse. I have three factless fact tables for distinct set of grades due to the fact I have no measures (I'm not aggregating anything), the grades are ...
3
votes
1answer
2k views

SSAS cube fact and dimension relationship

I have a cube that all the tables has one row per ID and have measure in all of them except for the calendar dimension. When I view the measures in excel from Table 1 with attributes from table 2, I ...
4
votes
1answer
36k views

SQL Server is configured to allow remote connections

I use SQL Server 2012 and SSAS Tabular Mode (My Instance Name Is MSSQLSERVER2012T) Then I download AdventureWorks Tabular Model SQL Server 2012 From This link I open it with Visual Studio 2010 and ...
23
votes
1answer
3k views

How to calculate/store Top 10 in a tabular model?

We have recently created an SSAS tabular model so our users can access it via PowerView. We have a measure on one of our fact tables to get the TotalActiveItems using a formula: TotalActive:=COUNTAX(...
7
votes
2answers
2k views

Calculated Measure to get only most current from one dimension on snapshot fact but keep other filters

I'm working on a tabular cube in SSAS 2012 SP1 CU4. I have 3 dimensions (Requisition, Requisition Status, Date) and 1 fact (Requisition Counts). My fact table is at the grain of requisitionKEY, ...