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

SSAS Internal error: An Unexpected error occurred (file 'pfcre.cpp' function PFCREngine::SelectCartridge)

Has anyone seen this error before? If so, how did you fix it? I can't find anything on Google. Here is what I have done: I tried doing a Google search but practically nothing came up. I checked all of my permissions everywhere, and from what I can…
Chicken Sandwich No Pickles
  • 2,953
  • 8
  • 45
  • 92
7
votes
2 answers

Implementing IN /LIKE in MDX

I have a dimension called [Band] and it can have several different values: [Band].&[A]&[Under $400] [Band].&[B]&[$400 - $1,000] [Band].&[C]&[$1,000 - $2,500] [Band].&[D]&[$2,500 - $3,500] ... I'm trying to write a query where I can cut by a sublist…
MetaStack
  • 3,266
  • 4
  • 30
  • 67
7
votes
1 answer

How to specify connection string/impersonation user/password in SSAS CD deploy?

I've seen discussions that hover around this in the past but never a direct solution (or "you can't do that"). I manage a Jenkins CI/CD system. We build and deploy SSAS Tabular and Dimensional models. We run DevEnv to build it,…
Richard Schaefer
  • 525
  • 3
  • 13
  • 45
7
votes
1 answer

non-Windows OLAP desktop client?

Working with SSAS 2008 in an environment with mostly Mac desktops. Use DbVisualizer and Aqua Data Studio for writing relational queries, but need a native desktop app to write MDX queries and view results from OLAP sources. VMWare / Parallels is not…
kermatt
  • 1,585
  • 2
  • 16
  • 36
7
votes
1 answer

Configuring an MDX query on SSIS

Hi I am having troubles configuring the SSIS task to run an MDX query. The parse works fine but it doesn't allow me to display the different columns of the query to map it Here is the query i used: SELECT [Measures].[# Consumers] ON 0, …
Cherif Ghattas
  • 71
  • 1
  • 3
7
votes
1 answer

DAX FILTER function with multiple criteria

I have a DAX statement and I run it inside SSMS. my original statement is: evaluate(filter('rptLoan', [RemainingDays] <= 10)) and it works file. I want to add another criteria as below evaluate(filter('rptLoan', [RemainingDays] <= 10 and [CloseDt]…
user7577311
7
votes
0 answers

Font error when clicking Attribute Relationships tab in Dimension Designer in SSDT

I am new to SSDT and I'm following the Analysis Services Tutorial called Multidimensional Modeling (Adventure Works Tutorial). And I'm currently on Lesson 3, on the step Modifying the Customer Dimensions under the heading "Modifying Attribute…
ArmorCode
  • 739
  • 4
  • 15
  • 33
7
votes
4 answers

SS Analysis Services ( SSAS ) DB schema comparison tool?

Does anyone know of an SSAS specific tool that compares SSAS databases? Not their data, just schema and maybe partition definitions. When I say tool - something that knows about SSAS and has that business knowledge built into it.
Jeff Maass
  • 3,632
  • 3
  • 26
  • 30
7
votes
2 answers

SSAS Tabular on Azure?

I'm attempting to deploy an ssas tabular model (I don't know what I'm doing ) I have made multidimensional on SQL Server 2008 R2 with VS2013. I wanted to try Tabular in conjunction with power BI. So I set up a SQL Azure DB, I have Azure SQL database…
NebNerlo
  • 93
  • 1
  • 5
7
votes
1 answer

SSAS cube with multiple DB

I have 3 databases with the same structure, but different data, since they are from different clients. Now, I have an existing SSAS project. Its Data Source Views, Cubes and Dimensions can only use or access one DB. What I want is to be able to use…
Raii
  • 303
  • 1
  • 4
  • 15
7
votes
6 answers

SSAS DB not visible in Management Studio but can be seen in Excel

There is a SQL 2012 Analysis Server with some cubes. When I connect to it using Excel 2013 (DATA menu > From Other Sources > From Analysis Services), I can see the DB names in the dropdown. But when I connect to it with SQL Server Management…
NS.X.
  • 2,072
  • 5
  • 28
  • 55
7
votes
3 answers

Why to build a SSAS Cube?

I was just searching for the best explanations and reasons to build a OLAP Cube from Relational Data. Is that all about performance and query optimization? It will be great if you can give links or point out best explanations and reasons for…
MSU
  • 415
  • 3
  • 6
  • 13
7
votes
3 answers

How to add new Dimension Attributes to the existing dimension through BIDS

I have a customer dimension. While creating cube and defining dimensions the default attributes will come along with the cube creation. I want to add some more attributes after creating the dimensions. How to do this. I tried with "Add Business…
Searcher
  • 1,845
  • 9
  • 32
  • 45
6
votes
1 answer

Where is SSAS headed?

I was just wondering if I am one of the few people in the world actually using SSAS, or is it prevalent in IT? There are so few people posting SSAS questions and answers here. Right now I'm running into an issue creating a Data Mining Dimension…
Dave
  • 4,949
  • 6
  • 50
  • 73
6
votes
1 answer

How to Connect to Tabular Cube Server Using Credentials Provided in a ConnectionString?

Microsoft says: https://learn.microsoft.com/en-us/analysis-services/instances/connection-string-properties-analysis-services?view=asallproducts-allversions "When connecting over TCP to SSAS, the client library will impersonate the Windows user using…
Cody
  • 161
  • 7
1 2 3
…
99 100