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
-3 votes
0 answers
26 views

Joining two table together in mysql query. Please see image for explaination

I have two tables in mysql database. I have attached an image to explain my question.
Waseem's user avatar
  • 1
1 vote
1 answer
742 views

How to release SSAS memory without forcing restart

We have a production server with two SSAS instances, 1 for user querying and 1 with empty templates where we do new releases and (full) processing of the cubes (and then backup and restore processed ...
DBHeyer's user avatar
  • 11
0 votes
0 answers
39 views

Tabular Cube SSAS Enterprise - Ignoring "LowMemoryLimit"(And All Others)

I have a really big SSAS Tabular cube server, it's has about 1TB of available memory(x1e.8xlarge). I have allot of cubes on it, it's great, I want to add more, I've added a new one and unfortunately I'...
David Rogers's user avatar
0 votes
0 answers
34 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) ...
Steve's user avatar
  • 21
2 votes
2 answers
2k 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 ...
Marcello Miorelli's user avatar
2 votes
1 answer
669 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 ...
WadeH's user avatar
  • 540
6 votes
2 answers
17k 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, ...
grouchball's user avatar
0 votes
1 answer
926 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 ...
Zsombor Zsuffa's user avatar
0 votes
1 answer
978 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 ...
DimUser's user avatar
  • 382
1 vote
2 answers
3k 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 ...
user avatar
0 votes
1 answer
372 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) ...
Adrian S's user avatar
  • 326
3 votes
5 answers
11k 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 ...
Neil P's user avatar
  • 1,274
1 vote
0 answers
573 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?
Neil P's user avatar
  • 1,274
1 vote
1 answer
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 ...
Tomasz Wieczorkowski's user avatar
2 votes
1 answer
1k 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 ...
user avatar
0 votes
1 answer
792 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 ...
Neil P's user avatar
  • 1,274
1 vote
1 answer
234 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 - ...
Ondrej Svejdar's user avatar
5 votes
2 answers
25k 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 ...
Adrian S's user avatar
  • 326
1 vote
1 answer
945 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 ...
Harison's user avatar
  • 11
3 votes
1 answer
2k 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 ...
John G Hohengarten's user avatar
1 vote
0 answers
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 ...
Tomasz Wieczorkowski's user avatar
0 votes
0 answers
276 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 ...
DatumPoint's user avatar
1 vote
1 answer
113 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 ...
pmdci's user avatar
  • 681
1 vote
1 answer
1k 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 ...
Keith Rivera's user avatar
2 votes
1 answer
3k 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....
user avatar
2 votes
2 answers
7k 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 ...
John G Hohengarten's user avatar
3 votes
1 answer
3k 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 ...
Sabby's user avatar
  • 31
23 votes
1 answer
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(...
Taryn's user avatar
  • 9,676
1 vote
2 answers
3k 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 ...
jhowe's user avatar
  • 281
4 votes
1 answer
38k 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 ...
Ardalan Shahgholi's user avatar
7 votes
2 answers
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, ...
mmarie's user avatar
  • 834