Questions tagged [tabular-model]

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

6 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
279 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
0answers
970 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
54 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 ...
0
votes
0answers
15 views

what is the Usage of Tabular mode in SSAS? Should I use Tabular to see Excel data

I have 3 excel files each around 56896 KB. Users use the data in excel for some reference. Now they use the Excel Manually, since Excel has exceeded its size, when they search it hangs up. What is ...
0
votes
0answers
77 views

mdx tabular 2017 model, calculated member with solve order fails

In tabular 2017 (compatibility level 1400) my query gets this error: Query Error - MdxScript(Model) (3, 38) Calculation error in measure 'Fact Order'[Sum of Quantity]: The expression invokes an ...
0
votes
0answers
251 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 ...