Questions tagged [tabular-model]

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

5 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
260 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
954 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
14 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
69 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
240 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 ...