Stack Overflow
Stack Overflow

Questions tagged [ssas]

SQL Server Analysis Services (SSAS) is part of Microsoft's SQL Server system. It provides Online Analytical Processing (OLAP) and Data Mining functionality. Not to be confused with Syntactically Awesome Style Sheets (SASS).

SQL Server Analysis Services (SSAS) is part of Microsoft's SQL Server system. It provides Online Analytical Processing (OLAP) and Data Mining functionality.

Initially released as part of SQL Server 7 it was further refined in SQL Server 2000. There were major changes from SQL 2000 to 2005 but since then (SQL2008 & SQL2008 R2) there have been incremental improvements. In SQL Server 2012, a new Tabular Model has been introduced.

You can find more information here: Wikipedia Analysis Services and here: Microsoft Analysis Services

5658 questions
53
votes
16 answers

"Duplicate attribute key" error when attribute is not a key

I am getting the following error when processing a Dimension: Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_Orders', Column: 'Project', Value: 'client service stuff'. The attribute is…
Dave
  • 4,949
  • 6
  • 50
  • 73
38
votes
9 answers

Pentaho vs Microsoft BI Stack

My company is heavily invested in the MS BI Stack (SQL Server Reporting Services, -Analysis Services and -Integration Services), but I want to have a look at what the seemingly most talked about open-source alternative Pentaho is like. I've…
Tomas
  • 3,384
  • 2
  • 26
  • 28
31
votes
10 answers

How to learn MDX

I am currently learning OLAP & MDX after many years of relational database development. Any tips on getting started in MDX? What are the best books and resources to learn MDX?
Craig
  • 1,327
  • 1
  • 13
  • 15
30
votes
5 answers

ssas attribute key cannot be found even though it exists and is not due to duplicates

I was trying to rebuild my cube after making some changes the other day to the table/column names in the fact and dimension tables. The process cube action kept returning the following error message: The attribute key cannot be found when…
JM Hicks
  • 1,282
  • 1
  • 11
  • 22
27
votes
8 answers

SQL Server 2012: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000

I am using Analysis services in Microsoft SQL Server 2012 on Windows 7. I tried to create Mining models and process it. I am getting the following error while processing it. OLE DB error: OLE DB or ODBC error: Login failed for user 'NT…
Manoj G
  • 1,776
  • 2
  • 24
  • 29
24
votes
1 answer

Designing dimension hierarchies: Natural or Unnatural

I'm using Analysis Services and when designing dimensions I'm never sure how far to go to build natural hierarchies. What I mean is I've added in all the genuine attribute relationships. So most hierarchies are natural anyway but the most commonly…
Craig
  • 1,327
  • 1
  • 13
  • 15
22
votes
2 answers

What is Multi Dimension OLAP CUBE and give example cube with more than 3 dimensions

As I am new to SSAS, have been reading an article on Multi-Dimension OLAP Cube and struggling to understand Cube concepts, It has been said that Although the term "cube" suggests three dimensions, a cube can have up to 64 dimensions. Could you…
rmdussa
  • 1,549
  • 10
  • 27
  • 50
21
votes
1 answer

gitignore file for SQL Server project: SSIS / SSAS / SSRS?

There's a git ignore pattern for all the Visual Studio projects on GitHub: gitignore/VisualStudio.gitignore. But I'm working specifically for SQL Server Business Intelligence solution in VS, and it seems that files like *.ispac are not ignored. Is…
Mincong Huang
  • 5,284
  • 8
  • 39
  • 62
19
votes
1 answer

Purpose and effect of SSAS hierarchies?

Firstly, I feel comfortable with what a hierarchy is in terms of the concept and how it impacts the design of a DW's star schema. I have some dimensions with lots of attributes, and I could create lots of hierarchies within SSAS. I would like a…
AaronLS
  • 37,329
  • 20
  • 143
  • 202
19
votes
5 answers

Different approaches to accessing SSAS

I’m interested in knowing some different approaches for retrieving data from Analysis Services, to use in either objects in code, or for end-user reporting. I’ve used two different approaches in the past, one was using ADOMD to pull results and put…
Meff
  • 5,889
  • 27
  • 36
18
votes
2 answers

Sql Server Services - Overview anyone?

In Short I am thoroughly confused by the array of SQL Server services available, and am having a hard time finding a brief primer. The Scoop I am a long time ASP.Net developer who has happily been churning out ASP.Net applications for years. These…
James
  • 7,877
  • 7
  • 42
  • 57
18
votes
4 answers

List dimension members with MDX query

Is there a way to list dimension members without fetching default Measure for each member?
Žygimantas
  • 725
  • 3
  • 7
  • 13
18
votes
2 answers

SSMS Change Connection for Query Editor Window

Normally when I want to change the connection for a Query Editor Window in SQL Server Management Studio, I can select a new connection from the menus at the top - Query > Connection > Change Connection. However, when I am working on cubes with an…
JumpingJezza
  • 5,498
  • 11
  • 67
  • 106
17
votes
3 answers

Extracting raw data from a PowerPivot model using Python

What seemed like a trivial task turned into a real nightmare when I had to read in some data from a PowerPivot model using Python. I believe I've researched this very well over the last couple of days but now I hit a brick wall and would appreciate…
akavalar
  • 491
  • 1
  • 6
  • 14
16
votes
1 answer

Connect with .net core to SSAS

I'm trying to connect Microsoft SQL Server Analysis server ( SSAS ) from .net core. At first I tried using Microsoft.AnalysisServices.AdomdClient, but it's not compatible with .net core. Is there a way to reach SSAS and fetch some data in any other…
John Smith
  • 427
  • 6
  • 17
1
2 3
…
99 100