Questions tagged [tabular-model]
Tabular models are in-memory databases in SQL Server Analysis Services, an OLAP server bundled with SQL Server by Microsoft.
32 questions
0
votes
0
answers
10
views
SSAS 2019 Tabular processing returns “Success” with 0 rows when using Snowflake via ODBC (MSDASQL)
I’m migrating an on‑prem SSAS 2019 Tabular model from SQL Server (local) to Snowflake. The model is deployed, and I’ve added a new legacy data source via 64‑bit ODBC. Processing a table in SSMS ...
- 101
0
votes
0
answers
51
views
SSAS Processing Sanity check: Am I using partitions effectively?
I have been rebuilding a DataWarehouse and lately I have been focusing on decreasing processing times. This is using MS SQL Server 2022. I have been implementing partitions on some of the larger ...
- 1
1
vote
1
answer
101
views
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-...
- 215
1
vote
1
answer
2k
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 ...
- 11
0
votes
0
answers
51
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)
dimDate(...
- 21
2
votes
2
answers
3k
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 ...
- 17.3k
2
votes
1
answer
798
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 ...
- 540
6
votes
2
answers
20k
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, ...
- 191
0
votes
1
answer
1k
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 ...
0
votes
1
answer
1k
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 ...
- 382
1
vote
2
answers
4k
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 ...
user71787
0
votes
1
answer
414
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)
...
- 326
3
votes
5
answers
12k
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 ...
- 1,294
1
vote
0
answers
606
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,294
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 ...
