Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ssas]

SQL Server Analysis Services, an OLAP server bundled with SQL Server by Microsoft since version 7.0

SSAS (SQL Server Analysis Services) is an OLAP server bundled with SQL Server by Microsoft since SQL Server 7.0. It is not available separately. The query language used by SSAS is MDX (Multidimensional Expressions); queries can be issued through a web service API called XML/A (XML for Analysis).

Originally purchased from a third party (Panorama) SSAS is now developed by Microsoft.

353 questions
40
votes
2 answers

What does a DBA have to know about SSAS?

I've seen a lot of material covering the business aspect of SSAS, but not really much about the important aspects of administration and management. From the point of view of administering an instance of SQL Server Analysis Services, what does a…
ivanmp
  • 2,302
  • 3
  • 23
  • 35
23
votes
1 answer

How to calculate/store Top 10 in a tabular model?

We have recently created an SSAS tabular model so our users can access it via PowerView. We have a measure on one of our fact tables to get the TotalActiveItems using a formula: TotalActive:=COUNTAX(FILTER('Stats', ISBLANK([DeactDate]) = TRUE),…
Taryn
  • 9,466
  • 3
  • 41
  • 74
23
votes
2 answers

What are Measures and Dimensions in Cubes

I'm very new to Microsoft Sql Server Business Intelligence and Analysis Service(but I'm programming for years with SQL Server).Can any one describe Measures and Dimensions in Cubes in Simple words(If it's possible with images)? thanks
Arian
  • 439
  • 1
  • 3
  • 9
18
votes
3 answers

Dynamically Define a Range in a Dimension

I have an issue that I face every time I decide to build a cube, and I haven't found a way to overcome it yet. The issue is how to allow the user to define a range of things automatically without having the need to hardcode them in the dimension. I…
AmmarR
  • 2,756
  • 3
  • 22
  • 32
17
votes
2 answers

Recalculate Time Dimension in BIDS

I'm using BIDS to create a cube in SSAS 2008 r2. I used the wizard to create a time dimension. Part of that configuration is selecting a date range. After creation, I realized that I needed a wider date range than I originally specified. I did find…
JNK
  • 17,718
  • 5
  • 56
  • 97
11
votes
3 answers

Is backing a website by a SQL Server 2012 OLAP cube considered reasonable?

I have been tasked with architecting a solution for a large retail chain. They want to allow each of its 1.2 million customers to log on to a web site to see the distribution of recent purchases (current month, previous month, year-to-date) over…
Rune
  • 213
  • 1
  • 4
11
votes
2 answers

How to balance SQL Server memory with SQL Server Analysis Services memory

We have many systems that have the same configuration One Server (virtual or physical) Running SQL Server (SQL) and SQL Server Analysis Server (AS) multiple cores 16gb RAM Each night the SQL Server will do about 2-3 hours processing, followed by…
Preet Sangha
  • 887
  • 4
  • 11
  • 22
10
votes
3 answers

Datawarehouse Design: Combined Date Time dimension vs. Separate Day and Time dimensions and timezones

We are just starting design for a new data warehouse and we're trying to design how our date and time dimensions will work. We need to be able to support multiple timezones (probably at least GMT, IST, PST and EST). We were initially thinking that…
Matt Palmerlee
  • 357
  • 1
  • 5
  • 11
10
votes
1 answer

Medians, Modes, Percentiles and OLAP

I'm newbie trying to wrap my head around OLAP, and I have a few questions. Question 1: Can an OLAP cube store medians, modes, percentiles? Question 2: Can an user-written MDX query return a summary of row-level data? (ex: % transactions > $100). Or…
Tommy O'Dell
  • 285
  • 1
  • 2
  • 7
10
votes
1 answer

MDX Query for RANK regardless of hierarchy

I'm hoping to add a calculation to my SSAS Cube (SSAS 2012) that will show the relative rank of whatever the current member is against all other members in that grouper, without specifying the groupers in advance. For example, say I have a…
JNK
  • 17,718
  • 5
  • 56
  • 97
9
votes
2 answers

Configure SQL Server Analysis Services (SSAS) to run on same IP as SQL Server instance

TL;DR I would like to add SQL Server 2014 Analysis Services to a specific instance of SQL Server and to configure it in such a way, that the Analysis Services (SSAS) and future Reporting Services (SSRS) will only pick up requests on the…
John K. N.
  • 14,660
  • 9
  • 40
  • 93
7
votes
3 answers

Cube processing either takes too long or fails

I have a SSAS Cube with 35 dimensions and 10 measures. Some of the dimensions are quite large in size. In almost all dimensions data either get updated and inserted. Measures have high volume of data. When I run from SSMS (by right click on SSAS…
Zerotoinfinity
  • 731
  • 3
  • 11
  • 27
7
votes
2 answers

Calculated Measure to get only most current from one dimension on snapshot fact but keep other filters

I'm working on a tabular cube in SSAS 2012 SP1 CU4. I have 3 dimensions (Requisition, Requisition Status, Date) and 1 fact (Requisition Counts). My fact table is at the grain of requisitionKEY, RequisitionStatusKEY, SnapshotDateKey. I have…
mmarie
  • 824
  • 7
  • 19
7
votes
2 answers

How to simplify SSAS deployment from DEV to PRO environment

Here is my issue: In my company, there is a team of developper who creates cubes, dimensions(...) in SSAS in a DEV environment (let's call it SSASDEV). This environment is bounded to a SQL Server database in DEV (let's call it SQDEV). My job is to…
el_grom
  • 133
  • 2
  • 2
  • 4
7
votes
1 answer

Dynamic Dimension Security

I have a cube in SSAS 2012 with about 30 dimensions, one of which is Company. The Company dimension contains a list of companies, of which there are several hundred in the cube. Our security model requires that users have visibility only to those…
JNK
  • 17,718
  • 5
  • 56
  • 97
1
2 3
…
23 24