Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [tabular-model]

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

From Books Online:

Tabular models are in-memory databases in Analysis Services. Using state-of-the-art compression algorithms and multi-threaded query processor, the xVelocity in-memory analytics engine (VertiPaq) delivers fast access to tabular model objects and data by reporting client applications such as Microsoft Excel and Microsoft Power View.

Tabular models have been available since SQL Server 2012.

31 questions
23
votes
1 answer

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(FILTER('Stats', ISBLANK([DeactDate]) = TRUE),…
Taryn
  • 9,746
  • 4
  • 48
  • 74
7
votes
2 answers

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, RequisitionStatusKEY, SnapshotDateKey. I have…
mmarie
  • 844
  • 7
  • 19
6
votes
2 answers

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, however for around a month now, we have not been…
grouchball
  • 191
  • 1
  • 1
  • 11
5
votes
3 answers

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 ImpersonationMode that is not supported for processing…
Adrian S
  • 326
  • 1
  • 5
  • 15
4
votes
1 answer

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 configure my Instance Name like this picture…
Ardalan Shahgholi
  • 457
  • 2
  • 8
  • 20
3
votes
5 answers

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 error: Failed to execute XMLA. Error returned: 'The…
Neil P
  • 1,294
  • 3
  • 20
  • 38
3
votes
1 answer

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 into an Agent Job for easy service restarting, but…
John G Hohengarten
  • 674
  • 1
  • 7
  • 18
3
votes
1 answer

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 have no issues, but when I view the measures from…
Sabby
  • 31
  • 1
  • 4
2
votes
2 answers

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 backups are healthy Recently, however, one of our…
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
2
votes
1 answer

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 has a DateTime column, with a row for every 5…
WadeH
  • 540
  • 4
  • 20
2
votes
1 answer

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 working the way I like. We have huge Tabular…
user71787
2
votes
1 answer

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. My concern is, if after a couple of years, my…
user71787
2
votes
2 answers

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 for querying an SSAS (Tabular or Multidimensional)…
John G Hohengarten
  • 674
  • 1
  • 7
  • 18
1
vote
2 answers

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 completely unrelated to each other hence why they're…
jhowe
  • 271
  • 1
  • 6
  • 19
1
vote
1 answer

Azure Analysis Service Tabular Cube - How To Impersonate A User in SSMS

Test Cube, Test User, connect to it(Azure Analysis Service) in SSMS, right click the cube, browse, click on "Impersonate": And you will see a series of prompts that are specific to a on-premise implementation of AD, so local users, local groups(In…
David Rogers
  • 215
  • 2
  • 10
1
2 3