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
0
votes
1 answer

Default Processing in SSAS Cube not processing the data

I have a SSAS Cube build in Tabular Mode, when I am processing it with "Default" option changes in the data is not processing. According to this link Processing Options in SSAS should process the changed in the data. Also I am processing the cube…
BIDeveloper
  • 767
  • 3
  • 14
  • 28
0
votes
0 answers

SQL Query Performance with an nvarchar(500) where the MAX(LEN(column)) < 30

I have a table with many columns defined as nvarchar where the defined length is very much larger than the actual max length of the data stored in it. I know that being a nvarchar, storage isn't a problem. But I am curious if there is a hit on…
Bill T
  • 1
  • 1
0
votes
1 answer

Do Not Execute another SQL Server Agent Job unless the other finishes the execution properly

My requirement is to run SSIS package from SQL Server agent job, I have 3 SSIS packages 2 packages loading the data to SQL Table and 3rd package processing the cube. I have created a 2 SQL Server Agent Job, one to run the package which is loading…
BIDeveloper
  • 767
  • 3
  • 14
  • 28
0
votes
1 answer

Dax Ratio across fact tables

I have two star schemas that share a few dimensions: Staff Star Schema. This contains a fact table that has the grain of "staff role". so for every role a person held in the college there is a row, with a start and end date of that role. Students…
JD_Sudz
  • 194
  • 1
  • 12
0
votes
1 answer

MDX,how to flatten the result of Descendants function

I have a hierarchy with 5 level,I use Descendants() to retrieve all lower level of a member.But i end up with a one column result where i like to have a result with one column for each level.So on each row i repeat the parent,grand parents etc of…
Vincent Diallo-Nort
  • 77
  • 12
0
votes
1 answer

How to count orders with condition A and B in dax

I have a table with order number and product code. One order can have multiple lines. I would like to count the number of orders which have BOTH product code A AND product code B. My table looks like this: OrderNumber ProductCode Order1 …
RunW
  • 269
  • 1
  • 2
  • 12
0
votes
1 answer

How to manage attribute permissions on SSAS Tabular model

We have a Tabular model with several Fact tables and several Dim tables. We would like to manages roles so that specific roles will not be able to see members of a certain attribute within a dimension. So in an HR cube with a "Work Hour" measure - i…
OrenHenig
  • 80
  • 3
  • 9
0
votes
1 answer

SSIS package to automate the reprocessing

This is a very unique problem that I have run into. Let me start by giving you the details: We have parent package(lets call it A) designed for processing cubes both partial and full processing. Now this package calls two other packages (say B, C)…
Dennyc
  • 63
  • 12
0
votes
1 answer

SSAS Tabular Date Filter Across Role Playing Date Dimensions

Using an accumulating snapshot fact, I multiple role-playing date dimensions in my Tabular Cube. Users would like to be able to see when ANY of the date events occurred during a given period (as opposed to ALL of the date events which is quite…
Stephen Lloyd
  • 733
  • 8
  • 21
0
votes
0 answers

Reprocess tabular cubes after failure using Informatica

So we process the SSAS tabular cubes every night and the other night the processing of the cube failed. Now what I want to do is implement a system that would trigger an automatic reprocess after failure. Is there a way to do that in SSAS Tabular?…
Dennyc
  • 63
  • 12
0
votes
2 answers

Reprocess SSAS tabular cube after failure

So we process the SSAS tabular cubes every night and the other night the processing of the cube failed. Now what I want to do is implement a system that would trigger an automatic reprocess after failure. Is there a way to do that in SSAS Tabular?
Dennyc
  • 63
  • 12
0
votes
1 answer

SQL Server Analysis Services: Can't choose tabular mode

I already tried both, installing a new instance and adding a SQL Server Analysis Service Feature to an existing one. Both possibilities lead to one view: Choosing between multidimensional/data mining mode and tabular mode not possible I can't choose…
NETDev
  • 128
  • 6
0
votes
1 answer

How to create a relationship in an SSDT model based on multiple columns?

I am creating a model for Sqlserver Analysis Services (tabular mode) using SSDT. My core measures are in a table with a combined key on UserId and WeekId. I have relations to other tables on UserId and on WeekId. Now I want to add another relation,…
Teun D
  • 5,045
  • 1
  • 34
  • 44
0
votes
0 answers

PowerPivot is not pulling all the records from Tabular Model

I have been facing an issue with many PowerPivot models. The Tabular Model is the source for my PowerPivot model and I have around 1.2 million records in my Tabular model. Every time the Tabular Model is successfully refreshed and processed. I'm…
Rama krishna Paala
  • 1
0
votes
2 answers

Creating a calculated column (not aggregate) that changes value based on context SSAS tabular DAX

Data: I have a single row that represents an annual subscription to a product, it has an overall startDate and endDate, there is also third date which is startdate + 1 month called endDateNew. I also have a non-related date table (called table…
Ross
  • 3
  • 3
1 2 3
…
57 58