Stack Overflow
Stack Overflow

Questions tagged [ssas-tabular]

The SQL Server Analysis Services (SSAS) tabular model is an in-memory, column store relational data warehouse constructed with tables which can have multiple columns of data. SSAS Tabular is geared for fast querying and high data compression. The Tabular Engine is the same one used in Power BI, Azure Analysis Services, and Excel Power Pivot.

869 questions
1
vote
0 answers

Change dimension values based on date selected on filter

I am unable to achieve the next DAX. I have 2 tables: Revenue and Type. I want to display: "latest type", at the selected FY in a filter. (That is, if FY 20 is selected, the type shall be the one valid on 31-May-2020). Revenue table: Type…
Chicago1988
  • 970
  • 3
  • 14
  • 35
1
vote
0 answers

How to apply role for KPIs on SSAS Tabular Model

I have a problem with applying roles for KPIs on SSAS Tabular Model, I created some KPIs but I cant set any roles for them so everyone can see them when they connect to the model using excel even apply "Hide From Client Tools" option. How can I…
Shahab Abdollahzadeh
  • 37
  • 4
1
vote
0 answers

Date Table created with M is imported as an Expression

I am using SSAS Tabular 2019 and I have had no problem in loading my views or tables, but this time instead of loading a Date table from SQL Server I created my own Date table using custom M code, but it appears that the date table is being imported…
AntrikshSharma
  • 629
  • 1
  • 3
  • 12
1
vote
0 answers

SSAS Memory in use by Offline_

I am using an excel workbook to check the memory usage of my SSAS with this DMV query: Select * from $System.discover_object_memory_usage After putting this in a pivottable it shows most memory is used by 3 objects/models called:…
ElmerBruin889
  • 15
  • 5
1
vote
1 answer

Issue in Partition in SSAS tabular model with DirectQuery Mode

I am trying to create a sample partition to a tabular model database in DirectQuery mode, and I got the following error after setting the filter and trying to import: "Failed to save modifications to the server: Error returned: 'A table that has…
Techchamp Pgm
  • 137
  • 11
1
vote
0 answers

Deadlock error in Azure Analysis Services

I have just implemented Christian Wade's "Automated Partition Mangement" solution in my company. https://azure.microsoft.com... But I got an error message when I run the process full of all tables. I have this error message Exception message:…
Lidou123
  • 155
  • 3
  • 15
1
vote
1 answer

Edit SQL Query in SSAS Tabular Model

I have created a local instance of a Tabular model using Visual Studio's SSAS Project Template. Still a little new to this, but I have used an OLEDB connection to import data using a SQL Query. The table is imported successfully, but I want to make…
Clifford Piehl
  • 483
  • 1
  • 4
  • 11
1
vote
1 answer

Power BI - DAX - table variable - use column for further computation

I am using DAX language in Power BI Desktop. I have a tricky situation where I am trying to use the column name generated from a table variable. Table 1: SourceTable Table 2: ReferenceTable I need to develop a calculated column in SourceTable…
user3812887
  • 439
  • 12
  • 33
1
vote
1 answer

Intermittent error: DAX expression with SSAS on prem server

I am currently working at updating Tabular model hosted on-prem on a SASS server version 13.0. The tabular model is version 1200. We have complex logic created in our measures that allow us to define counting rules or to filter depending on…
Remi
  • 21
  • 4
1
vote
1 answer

Does SSAS Tabular have support for aggregated tables?

Power BI has introduced support for aggregated tables. https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations Does SSAS Tabular have this feature?
CleanBold
  • 1,551
  • 1
  • 14
  • 37
1
vote
0 answers

Transactional Fact Table

I have Accounting fact table and all financial transactions are posted in it. For One attribute, source system can have three type of values (General Ledger/Customer Account/Limit ).These are three separate dimensions in the model. For Fact table,…
Ali
  • 11
  • 1
1
vote
2 answers

"The server could not be contacted." error while deploying Model to SSAS

I am able to deploy model to SSAS from SSDT but when i try to deploy to SSAS with http enabled SSAS seerver by following below…
Myn m
  • 43
  • 8
1
vote
2 answers

Using MDX in SSAS tabular get first 10 days of each month

I am trying to dynamically get the dates, starting from begging of month to current date using SSAS Tabular - DAX, I have tried many date functions but I couldn't end up with solution, so is there any idea to share pls ?
Melvin
  • 51
  • 4
1
vote
0 answers

How to refresh metadata of existing table in ssas tabular cube

I have build one SSAS tabular cube and today new columns are added to Fact table of my cube. How to refresh metadata and get those columns in the cube step by step.
lakshman
  • 41
  • 5
1
vote
0 answers

SSAS Standard Edition Tabular Model Process - Low Memory Error

This is the environment I work with: Microsoft SQL Server 2017 Standard Edition (64-bit) One database engine instance with 3 databases One Analysis Services instance with 4 databases (Tabular model, average size of each database 3.9 gb) Database…
rkapukaya
  • 77
  • 1
  • 8
1 2 3
…
57 58