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
11
votes
4 answers

Changing SQL Server DB from tabular to multidimensional

I have following problem: When I try to deploy my SSAS project (with cube, dimensions and all that jazz) to sql-server, it throws error saying that You cannot deploy the model because the DB deployment server is not running in multidimensional…
Krzysztof Piszko
  • 1,355
  • 3
  • 12
  • 17
11
votes
1 answer

Process update is taking longer than Process full

I have a cube which has few big dimensions. It is currently taking 2 hours to Process Full. I have now partitioned the cube and followed below strategy: Process Update dimensions Process data Partition (only needed partition) Process index…
Zerotoinfinity
  • 6,290
  • 32
  • 130
  • 206
11
votes
2 answers

Using Entity Framework with an SSAS Cube

Is it possible to use Entity Framework (any version, including, and preferably 4.0) to query an SSAS cube (preferably SSAS 2008)?
CodeMonkey1313
  • 15,717
  • 17
  • 76
  • 109
11
votes
2 answers

OLAP - Calculate run-off triangles, sample data and cube included (PostgreSQL/Mondrian)

Reality description: We do have a list of projects. In every project there is a lot of accounts. You can do a lot of actions on every account. I do have the following dimensions and fact table defined (simplified): Dimensions and attributes: …
Tomas Greif
  • 21,685
  • 23
  • 106
  • 155
10
votes
4 answers

When installing SSAS, should you install the version that corresponds to the version of SQL Server installed, or go with the newest version of SSAS?

I am currently running SQL Server 2014 and need to install SSAS. Is it best to match the version of SSAS to the version of SQL Server installed or is it recommended that the newest version of SSAS be installed? I figure the SQL Server environment…
user7560542
  • 527
  • 1
  • 5
  • 14
10
votes
1 answer

How to execute a MDX query of SQL Analysis Server in C#

I want to execute a SQL Analysis Query in C#. I have successfully connected to Analysis database using the below code: Server DM_Server = new Server(); Database AS_Database = new Database(); DM_Server.Connect(//SQL Analysis Server Connection…
Quest
  • 444
  • 1
  • 6
  • 18
10
votes
7 answers

No QUARTER() in DAX? Really?

While building a Calendar table with PowerQuery for a PowerPivot model in Excel 2013 I use its Date.QuarterOfYear function to get the number of the quarter. Building the same thing in SSAS Tabular requires some workarounds. There's no equivalent…
erop
  • 1,510
  • 1
  • 14
  • 27
10
votes
3 answers

SQL Server Analysis Services - Do I have it?

Hi I have access to SQL Server at work and I've heard some interesting things that can be done with SQL Server Analysis Services. How do I know whether analysis services is running? Is it installed by default on the server? Would it be installed…
Dave
  • 103
  • 1
  • 1
  • 4
9
votes
1 answer

Calculated Member for last-child in non-time dimensions?

In a SSAS cube, how do I create measures that are aggregated as LastChild for a non-time dimension? The source data has many versions of the same business record on any given day. The time dimension has a granularity of DATE, not seconds &…
Mark
  • 9,320
  • 6
  • 57
  • 70
9
votes
2 answers

SSAS Measure Group EstimatedSize EstimatedRows

The properties panel in SSDS for a Measure Group has two properties I'd like to learn more about: EstimatedRows and EstimatedSize. There seems to be little documentation on either of these. I did find that I can run the Aggregation Design Wizard and…
Mike Smith - MCT
  • 1,166
  • 1
  • 9
  • 15
9
votes
1 answer

Do Clustered Columnstore Indexes Affect SSAS Query End User Performance

Do Clustered Columnstore Indexes affect SSAS Performance querying for the end-user, and how could to fix this? Read an article below here how Sort order affects SSAS query customer user performance. Is there any way to resolve this issue? Would…
user11156893
9
votes
1 answer

SSAS interview questions

For interview purpose what questions can we expect from SSAS prespective. a) Entry/Beginners level (1-6 months) b) Intermediate c) Advance Thanks
user372724
9
votes
5 answers

Is there anywhere a Java library available that supports exactly the format strings of Excel?

For a Java application that drags data together from some sources and does some calculation itself, we want to offer users the possibility to use their own format strings, and would prefer the format string syntax they know from Excel (e. g. "$…
Frank
  • 2,628
  • 15
  • 14
9
votes
2 answers

MDX equivalent to LIKE

In SQL I like to search a column for matches of a particular string using something like this: SELECT t.attributeNAME FROM myTable t WHERE t.attributeNAME LIKE '%searchString%' I might like to use that in a temp table and then use the result in…
whytheq
  • 34,466
  • 65
  • 172
  • 267
9
votes
3 answers

How to get total of top 10 sales in SSRS 2012

I am taking Top 10 of Sales Volume grouped by Product categories in SSRS 2012. I need the total of these top 10 but it shows the complete total. I cant do it on dataset level as I need the complete dataset for other parts in the report. I tried the…
KrazzyNefarious
  • 3,202
  • 3
  • 20
  • 32
1 2
3
…
99 100