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

learn more… | top users | synonyms

2
votes
0answers
8 views

Remove Data From Memory when Using SSAS Tabular In-Memory Mode

I use SSAS Tabular in In-Memory mode. I also use partitions to divide my data. So I will have one partition per month. AFAIK, when using In-Memory mode, server keeps processed data in memory forever....
2
votes
1answer
1k views

What causes “attribute key cannot be found when processing” errors?

I'm consistently getting variations on this error when I process the cube in my first SSAS project: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: '...
0
votes
0answers
29 views

Handling time-zones with separate date and time dimensions

I have separate date and time dimensions. My cube stores data in UTC+0. I would like to display my measure aggregated per date in UTC-5. Here is my code: with MEMBER [Measures].[UTC-5] AS ...
1
vote
0answers
14 views

SSAS - Applying Conversion Rates for Units of Measure

So I've been playing with this for the last day or so, and haven't been able to get an closer. I have a SSAS cube that has a measure group which displays total execution times for events in seconds. ...
1
vote
1answer
22 views

The following system error occurred: No mapping between account names and security IDs was done

While trying to Process a cube i go this error "Error 133 The following system error occurred: No mapping between account names and security IDs was done. 0 0" i know its some user which ...
1
vote
0answers
14 views

Adding Partitions to cube In SSAS via VS 2013

I am trying to add a new partition to my cube via SSDT 2013. I am using the Wizard and doing all stages that needed. After I click "Finish" nothing happens and I cannot see that a new partition has ...
0
votes
1answer
231 views

Analysis Services job step error: The specified file could not be decrypted

We have a daily SQL Server Agent Job that's failing intermittently. Between May 27th and Jun 16th, it has failed twice. The error message we receive (listed below) references "The file could not ...
1
vote
1answer
72 views

SSAS Cube for tracking changes in parent child relationship over time

I would like to build an SSAS cube which tracks how objects in a graph who's edges represent a "belongs to" relationship change over time (daily). There are two components to the change: which ...
1
vote
1answer
248 views

Is processing required dimensions enough or to process the entire cube?

I have four large dimensions and one of the dimension is not going to be changed, also the particular dimension didn't need to be processed. So, processing the three dimensions individually updates ...
1
vote
1answer
400 views

Why does SSAS keep restarting every few seconds?

We have a SQL Server 2005 Analysis Server which began restarting this weekend, seemingly without any external changes. The current state of the server is that as long as the SSAS service is enabled, ...
17
votes
3answers
6k views

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 ...
6
votes
1answer
106 views

Drillthrough action on semi-additive measure group

I have created a semi-additive (Last Non-empty) measure in a cube that I am developing. For that measure group I have created a drillthrough action. When I use that drillthrough action it is ...
1
vote
1answer
158 views

Can we have OLAP cubes with same OBJECT NAME and ID at different database?

I have olap database for both production and test. Fortunately I noticed that cube under both production and test olap database has the same object name and Id. But DataSource for production and test ...
1
vote
2answers
67 views

How to find the size, name and other details of Analysis server database?

How to find the size, name and other details of an Analysis Services database ? I have a Analysis Services server and I can see one database inside that. I want to know the size and other basic ...
0
votes
0answers
19 views

Interpreting FlightRecorder in SSAS

We recently noticed a drastic degradation of performance of our production SSAS Cube on our new server. The full processing of the cube went from 45 mins to 3hours+. I am tasked with identifying the ...
1
vote
1answer
24 views

How do I tell which Edition and Version my SSAS Instance is running?

In SQL Server on the database engine, you can run a SQL query like this to get the server's version info like Edition and Version, and Update Level, etc. SELECT @@VERSION What is the MDX equivalent ...
3
votes
1answer
39 views

After processing complete, SSAS DB slowly consumes all available space on disk, w. high memory use also

This problem is with an SSAS 2012 SP3 (11.0.6020.0) multi-dimensional server, hosting a single cube database, containing 1 cube and 16 dimensions. Aggregations have been designed using SQL Management ...
0
votes
0answers
15 views

Connect MSSQL DB with SSAS

I am trying to build a BI system using SQL Server 2008. I have installed and created the database. I have also installed SSAS but I can't seam to find a way to connect my database as a Data Source ...
1
vote
0answers
44 views

How to backup SSIS packages and CUBE Projects from Visual Studio 2013.5?

I'm using VisualStudio 2013.5 to develop SSIS, SSDT and SSAS Cubes (multidimensional and tabular model). I would like to ask you is there a possible to backup SSIS packages and SSAS cubes from ...
0
votes
1answer
99 views

SSAS (Analysis Services) 2014 - Cumulative Update 1 for SP1

I just recently applied CU1 for SQL Server 2014 SP1 (http://support.microsoft.com/en-us/kb/3067839) to my development workstation and one PROD server. Analysis Services continues to report itself as ...
2
votes
1answer
80 views

SSAS and SQL Server on the same server

I have a server that is primarily used for SSAS, heavy processing, however I have SQL Server on it alongside SSAS, but I don't want sql server to hold ssas back. I have set the SQL Server MAX memory ...
1
vote
1answer
63 views

SSAS Hierachies duplicates when browsing

The dimensions in the cube are giving us duplicates, there is no error while processing the cube, but when the cube is browsed we could see duplicates. There is a hierarchy in our dimension, the ...
2
votes
1answer
47 views

Monitor number of records returned in a long-running SELECT statement during SSAS processing

On a SQL Server 2014, I have an SSAS tabular model which is querying a relational clustered columnstore table (with 800 mio. records), when the model is being processed. The query is just a simple ...
2
votes
1answer
58 views

How to find out ALL the users that can connect to SSAS?

I have an user called mycompany\aives that is not listed in the list of administrators in the SSAS, not belong to any of the AD (active directory) groups listed there, however, he can connect to ...
3
votes
1answer
119 views

How to check the health of a SSAS database? And of its backups?

regarding backups of the SSAS databses, based on the following behaviour: Backup on an empty SSAS database hangs Is there a way to check whether or not the SSAS backup is healthy? I would accept ...
2
votes
1answer
347 views

How to verify a SSAS Backup and how to perform Integrity Checks in SSAS?

I have a procedure to backup SSAS Databases that is working successfully. I also delete the SSAS backup files that are older than 2 days. What I am looking forward to implement is: 1) How to verify ...
2
votes
3answers
67 views

Cannot create SSRS subscription for a report using SSAS as datasource

My questions is : how should I config SSRS subscription a report, which consumes SSAS datasource. I already googled and lookup stackoverflow a lot and still couldn't make it work. Problems: I ...
0
votes
1answer
228 views

Problems attaching a SSAS database

I am attaching a SSAS database that I have just moved to a different drive following the below link: Attach and Detach Analysis Services Databases First I had to grant permissions on the new drive ...
0
votes
1answer
22 views

Problem with Processing Dimensions with Multiple Facts

I have a cube built in SSAS that uses 3 facts and 8 dimensions. Some of the dimensions are shared across 3 facts. When I process one of the dimension, it tries to process the underlying measure ...
1
vote
0answers
58 views

How can I reduce OLEDB wait type in a SSAS linked server connection?

I have recently created a linked server to one of my SSAS servers. when I go ahead and open the catalogs, to see which ssas databases I have there, I use the following procedure: create procedure ...
1
vote
1answer
475 views

How can I pass the server name as parameter for a XMLA script?

I have a PROCEDURE sp_backupSSAS - it backups SSAS databases. it works fine. I had previous problems with it, but they were sorted out here: routine to backup ssas databases fails with: The XML for ...
1
vote
0answers
30 views

SSAS - what could I monitor in SSAS to fine tune its memory settings?

This question is a follow up from the SSAS - what could be a good starting point for memory settings? What and how can I monitor the server resources in order to best identify the settings that I ...
0
votes
0answers
141 views

Backup storage file corruption: file not found. Possible cause of this error is corruption of backup file

I backup my SSAS cubes called "BI LIVE" and restore it to a specific location on a different server. I am using sql server 2014. This is where you can see the routine I use to run the backups: How ...
2
votes
1answer
195 views

Update OLAP Cube data

We are using OLAP in our project and we are facing a scenario where we need to update the cube with real time data on daily basis. I need some suggestions about an optimal way for updating the data ...
5
votes
1answer
126 views

SSAS - what could be a good starting point for memory settings?

I have received the following alert regarding memory settings of SSAS: Alert: SSAS 2014: Invalid TotalMemoryLimit Configuration Source: MSSQLSERVER Path: SASBI01Alert time: 9/15/2015 5:38:50 PM ...
6
votes
1answer
82 views

Designing a dimensional DB off a normalized source that already implements SCD's

I have built an SSIS ETL to integrate various data sources (one from MySQL, two from SQL Server) into a single SQL Server relational and normalized database, which I've called [NDS]. The SSIS ETL ...
0
votes
1answer
32 views

SSAS Partitioning update questions

I am looking into automating my SSAS cube builds using SSIS and/or scripts and have a few questions. I have a cube with yearly partitions and a Date Dim that has attribute indicators by day for "...
3
votes
1answer
23 views

Formatting a Measure in SSAS cube

I have a measure that show number in millions / billions. The formatting of the number for now is like this : "$#,##0.0;-$#,##0.0" I would like to format the number to show something like this: ...
1
vote
1answer
31 views

What if the lowest granularity level can legitimately be null?

I have a normalized database that I'm going to be using as a source for a dimensional data store; one of the facts I'm collecting is Orders, the normalized schema looks roughly like this: However ...
3
votes
1answer
114 views

Two facts, two dimensions, one query, one cube, can it be done and how?

I have four tables, two Facts and two Dimensions. Below I've listed the relevant columns of these tables, and the results I would like to see in the Cube. Fact Order table ---------------- SK_Order ...
10
votes
2answers
14k views

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 ...
1
vote
2answers
901 views

SSAS tabular browse Excel relationships not working

I'm currently building an education data warehouse. I have three factless fact tables for distinct set of grades due to the fact I have no measures (I'm not aggregating anything), the grades are ...
2
votes
1answer
80 views

Analysis Services Project: Data Source per Enviroment

I'm trying to configure a multi dimensional analysis service project, so that each developer of a team can configure his/her own data source (oracle). Changing the deployment target is easy, but how ...
0
votes
0answers
105 views

SSAS MD dimension joins to same table twice (but processing fails as attribute has 2 names for same ID)

My cube has a product dimension, and each product has an "availability" status attribute. In the database, SellableItemAvailabilityId in DimSellableItemVersion (which contains products) joins to Id in ...
1
vote
2answers
77 views

Ordering of a dimension in sql server datawarehouse

Built and deployed a simple cube with a date dimension. The dimension has things like day of month. How do i sort it? it always shows in the reports as 1, 10, 11, 12, ... 19, 2, 20, 21 Design. ...
3
votes
2answers
198 views

Cube with 2 measure groups (with different relationships to dimensions) returns too many dimension members in reports

I have a cube that contains stock-take data from retail operations. It has 2 measure groups - one containing the number of stock units counted in each stock-take batch (which is related to the Product,...
4
votes
1answer
1k views

How can I get the measures of the last month with MDX?

I would like to get the values of the measures of the previous month. That's what I have: SELECT [Measures].[Recuent distinct] ON ROWS, TAIL(NonEmptyCrossJoin([Dim Date].[Calendar].[Month ...
1
vote
1answer
59 views

Permissions Error on Member that doesn't exist

My team built an SSAS cube a year or two ago; it was the second cube we've built. We rolled it out to a few teams who have been using it without any issues. Today, I sat down with a new user to set up ...
15
votes
2answers
2k views

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 ...
1
vote
1answer
43 views

Question regarding Excel connection to SSAS cube

Looking for a way to change the connection in an existing spreadsheet from old SSAS server to the new SSAS server without losing the data in the spreadsheet. Hardware refresh has made this change ...