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
16
votes
6 answers

deployment of adventureworks cube fails: 'user does not have permission to create a new object in 'GARY-PC' or the object does not exist

when I deploy adventure works cube it fails, and i get: user does not have permission to create a new object in 'GARY-PC', or the object does not exist. trying to process cube from adventureworks DW and having what seem like permissions issues (?).…
gnackenson
  • 707
  • 3
  • 9
  • 23
15
votes
0 answers

Force DAX SWITCH function to use strict (lazy) short-circuit evaluation

Set up: Similar to this question on a MSDN forum, I have a measure that switches between various other measures (some of them much more complex than others). The measure looks like this (my actual measure has more cases): VariableMeasure = VAR…
Alexis Olson
  • 38,724
  • 7
  • 42
  • 64
15
votes
1 answer

In OLAP cube wrong Grand Total when attribute is filtered

A user trying to check the Sales Amount per Salesperson. Sample data: Salesperson Sales Amount 001 1000 002 500 003 750 Grand Total: 2250 It looks fine, but we have the…
Infinity
  • 828
  • 4
  • 15
  • 41
15
votes
4 answers

View MDX query generated while browsing a cube in SSMS

In Sql Server Management Studio once I browse a cube I can drop column fields, row fields and filter fields. This displays the required data. I want to know if there is a way to view the MDX query being generated behind the scenes to display the…
stackoverflowuser
  • 22,212
  • 29
  • 67
  • 92
15
votes
3 answers

Media queries PX vs EM vs REM

Can anyone explain why my media queries break when converting them FROM px TO ems In the body of my document, I have included the following rule font-size: 62.5%, Therefore I would assume that I could convert my media query to FROM 650px to 65em?…
stckpete
  • 571
  • 1
  • 4
  • 13
15
votes
2 answers

Parser: The syntax for the ImpersonationInfo object is incorrect, If the ImpersonateAccount value is used for ImpersonationInfo

I am trying to deploy a cube for the first time on my PC. I have run SSMS as an Admin and made myself (Gary-pc\gary, using Windows authentication) an admin. Doing this got me past the error message user does not have permission to create a new…
gnackenson
  • 707
  • 3
  • 9
  • 23
14
votes
4 answers

Difference between tuple and set in mdx

What is the difference between tuple and set in MDX. How we can distinguish both and when we are using them.
Searcher
  • 1,845
  • 9
  • 32
  • 45
14
votes
4 answers

Analysis Services Only Windows Authentication

Is it true that Analysis Services ONLY supports windows authentication?
AJM
  • 32,054
  • 48
  • 155
  • 243
14
votes
3 answers

DAX formula to concatenate three columns

I am mew to DAX. How can I concatenate three different columns say First_Name, Middle_Name and Last_Name to a single column with a space in between using CONCATENATE function in DAX. At present I could concatenate only two…
user2107971
  • 215
  • 1
  • 4
  • 9
14
votes
9 answers

OLAP Cube deployment issues

I'm really new to this, so I am probably making a simple mistake. I need to make an OLAP cube using a remote database. After I set up the dimensions and measures and create the cube, I can not get the cube to launch to the local server. I keep…
Daniel Martin
  • 570
  • 1
  • 9
  • 18
12
votes
2 answers

How to make SSAS Dimension attribute data type as Numeric in Excel

I need to your help to change the dimension attribute data type in Excel sheet when connecting cube via excel and I have defined a column as "FLOAT" in Data warehouse and "DOUBLE" in Cube,but that attribute is always displaying as string in Excel…
Bhavani Rajakumar
  • 121
  • 4
12
votes
6 answers

In SSRS is there a way to copy formatting between cells?

I am developing several dozen reports in SSRS 2008 R2. I am finding the formatting of cells to be the most tedious and error prone part of the task. I know how to individually format each cell. Is there a way to copy the format of one cell to many…
gnackenson
  • 707
  • 3
  • 9
  • 23
12
votes
2 answers

What is the best approach to get from relational OLTP database to OLAP cube?

I have a fairly standard OLTP normalised database and I have realised that I need to do some complex queries, averages, standard deviations across different dimensions in the data. So I have turned to SSAS and the creation of OLAP cubes. However to…
dan
  • 5,664
  • 8
  • 45
  • 59
11
votes
1 answer

How to get the time between two TFS Work Item States in SSAS (or any other report)?

Is there a way in TFS's reports that you can get the amount of time taken for a work item to transition between states? Looking at the data in the Tfs_Warehouse database I can see that there is a record of every revision of a work item, and using…
DaveShaw
  • 52,123
  • 16
  • 112
  • 141
11
votes
2 answers

Power BI Slow with SSAS Multidimensional Cube

We are implementing Power BI with SSAS Cube Direct Query. For some reason, SSAS Power BI is extremely slow performance, however using SSDT SSAS Application or Power View or Excel is Much faster. I read that Power BI converts SSAS Multidimensional…
user11156893
1
2
3
…
99 100