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

learn more… | top users | synonyms

3
votes
0answers
175 views

Date dimension changes between Test and Production Server

I have a cube deployed into a Test environment and Production environment. I've noticed something strange happen with the date dimension. When deployed into our test environment, the Date Key comes ...
2
votes
0answers
630 views

How to make SSAS Commit Write take less time

We're using SQL Server Analysis Server 2012 (Enterprise) and have a process to update the cube during the day. This process is running pretty well until it gets to the final part of processing where ...
2
votes
0answers
3k views

MDX: How do I combine/merge/union two Measures dimensions with calculated members?

I am trying to combine two dimensions in an MDX query. SELECT NON EMPTY ( [XXX].[YYY].children ) ON ROWS, NON EMPTY { [Measures].[Dimension1A], [Measures].[Dimension1B], ...
2
votes
0answers
47 views

How to remove leaf member values?

I have a dimension hierarchy that is related to multiple fact tables with different granularities. In the case of one fact table, it relates to the middle level of a three level hierarchy. When you ...
2
votes
0answers
269 views

Semi-additive measures for other dimensions

I am looking for a way to do semi-additive aggregations on a non-time dimension. The model I am working with is similar to a snapshot inventory warehouse. Specifically I am analyzing processes ...
2
votes
0answers
834 views

Finding Microsoft.AnalysisServices.Xmla dll in SQL Server 2008 R2

I'm not able to find Microsoft.AnalysisServices.XMLA.dll that I need to import using Microsoft.AnalysisServices.Xmla; I have found some articles and answered questions for SQL Server 2005 and 2012. ...
2
votes
0answers
182 views

MDX Block Calculation Optimisation

I have a query I'm trying to optimise. I have read an article here http://web.archive.org/web/20100823233821/http://www.biblogs.com/2008/03/30/optimizing-countfilter-expressions-in-mdx/ about ...
1
vote
0answers
6 views

Grant read/read-write access to SSAS cubes

I have a requirement to grant read access on SSAS cubes to one windows group and read/write access to another group. I have multiple SSAS cubes on my server. The question is: What minimum rights ...
1
vote
0answers
16 views

Migrating SQL 2012 Analysis Services to another server

We have a SQL Server 2012 installation that was built on...let's say a compromised Windows installation. It's had so many installs/uninstalls done on it that nothing runs consistently, and we're ...
1
vote
0answers
64 views

how to pass the “file path” as a parameter in powershell?

I have recently added a SQL Server JOB on SERVER-A that goes to SERVER-B and backups all the SSAS databases. This seems to be fine. However when I want to delete backups older than 3 days, using ...
1
vote
0answers
37 views

How do I check the status of an SSAS Cube that is currently processing?

When you process a cube through SSMS by right-clicking and selecting "process" it will display a window with the current status of each of your processing objects. In my current project I am using a ...
1
vote
0answers
15 views

Process dimension task is querying the wrong column!

I'm in the process of building a new data warehouse and I am starting out by building a few dimensions. I have created a fairly typical "Date" dimension and that seems ok. Now I am trying to create ...
1
vote
0answers
215 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: ...
1
vote
0answers
55 views

MDX query is SLOWER with warm cache

I have a MDX query that executes faster on cold cache than warm cache. If I ran the same MDX query after restarting SSAS it takes 14 seconds. All subsequent runs of the same statement then take 50 ...
1
vote
0answers
60 views

Database backup hangs both in SSMS and XMLA

I am using SQL Server Analysis Services 2008 R2 Service Pack 3. My database was recently upgraded from Analysis Services 2005 and since that time I have been unable to do a backup either from SSMS or ...
1
vote
0answers
30 views

Datamining using holidays

My setup: I am currently running a SQLServer 2012 database paired with a SSAS. My database features sales per store at specific times. My goal: I am interested in predicting future sales (amounts) ...
1
vote
0answers
233 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, ...
1
vote
0answers
375 views

How to get usage based optimization working on SSAS?

I have set up the configuration for SSAS to log the usage into the database, since the table did not exist I let it do that. However SSAS created the table OlapQueryLog under the schema of the SSAS ...
1
vote
0answers
136 views

Design The Cube Dimension for Group/Member OR “Many to Many” type relationship

I am looking for the right approach how to implement group/member like relationship in the cube dimension. i have attached the smaller version of my tables currently I have. Table-1 is SecurityTable, ...
1
vote
0answers
423 views

Error 7373 connecting to SSAS 2008 only from one machine

Within the last week, I've gotten the following error when trying to use a linked server in SSMS (tried 2008 and 2012) to connect to a SSAS 2008 R2 instance on our cluster: Cannot set ...
1
vote
0answers
436 views

SSRS switch statement

I have a report with a variable number of columns. I can hide columns with the ismissing function based on an expression like Iif(Fields!Site.ismissing, true, false). However, the hidden columns still ...
1
vote
0answers
3k views

An error was encountered in the transport layer - SSAS 2012 from Excel 2013

When connecting to an SSAS 2012 tabular model from Excel 2013 (Data... From Other Sources... From Analysis Services... fill in Server Name... click Next), I get the error: An error was encountered ...
1
vote
0answers
337 views

How to aggregate calculated measures involving dimension attributes?

The business case is as follows - I have a cube of sales transactions and a dimension of parts. One of the attributes of a part is the current cost, which is non-aggregatable. A user needs to model ...
1
vote
0answers
202 views

How to model Week Commencing / Week Ending scenario

I’m reasonably new to data warehousing and I’m struggling to get a feature of my time dimension working. I’d like to model a Week Commencing and Week Ending type of scenario. I’ve created a DimTime ...
1
vote
0answers
182 views

Configuring SQL Server 2008 R2 Change Data Capture with SSAS

I'm completely new to SQL Server Analysis Servers (SSAS) so you'll have to excuse my ignorance. I've been running through the MSDN SSAS tutorial get a handle on how to use SSAS. We have SQL Server ...
0
votes
0answers
22 views

SSAS bridge table with Slowly changing dimensions

I am designing a datamart using the basic principles of Kimball for use in SSAS. I have a many many to many attribute relationships (multi-valued dimension objects), however I have a few questions: ...
0
votes
0answers
73 views

Handle Duplicate entries in Fact table in Data Cube

We have been constructing data cube for our project in which we are facing a problem like 1 to many relationship in the dimension tables and making entries in fact table (duplication). ...
0
votes
0answers
62 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 ...
0
votes
0answers
24 views

How to avoid processing for a dimension when we process the cube?

I have a dimension and a measure group whose data is only historical data and will never get changed. So, as I process the cube everyday it's getting processed along with it and it may be degrade the ...
0
votes
0answers
65 views

Cannot Deploy SSAS Package into VM / TCPIP

I'm sure that this is just a simple settings problem but I just don't get my head around it. I installed SQL Server 2014 incl SSAS in a VM on Server 2012 (using HyperV in win 8.1) and have VS Data ...
0
votes
0answers
88 views

Scale-Out Query Server: SQL Server 2012/2014 Enterprise vs BI Edition

Was reviewing the Features Supported by the Editions of SQL Server (2012, 2014) and noticed what appears to be a mistake, but I'm just not certain and looking for confirmation. For 2012/2014, there ...
0
votes
0answers
38 views

Problem running SQL Server 2014 SSAS in an SSIS package

I have a SQL Server 2014 AlwaysOn environment setup with 3 nodes. It is a QA environment. I have a user who is trying to run an SSIS package against an SSAS cube. He can manually run the process in ...
0
votes
0answers
57 views

Join two tables and count a column using mdx

I am trying to join the two tables as below Table1 --------------------------- Product| StoreType| Store --------------------------- 1 | 10 | X ...
0
votes
0answers
43 views

Disk space requirements for SSAS database backup

Can anyone advise how I can gauge the disk space required to backup a SSAS database? I have a database that is as per SSMS estimate 146GB in size. The contents of the data folder amount to 143GB and ...
0
votes
0answers
47 views

SSAS, Last Non empty broken

I have a straight-forward account fact table containing dimensions for Date, AccountOwner In SQL my fact table has column bookings (that can be negative for outgoing money and positive for incoming ...
0
votes
0answers
94 views

Why is MDX Moving Average Calculation Inconsistent in Excel?

This question hurts my brain to talk about. Hopefully I can explain it properly. I have the following calculation defined in my cube: CREATE MEMBER CURRENTCUBE.[Measures].[52 Week Comp Net Sales ...
0
votes
0answers
40 views

Does Position Of Cube Dimension Matter While Adding it as Measure

I've created a cube on the Adventure Works Database. And when tried to process the Cube i get error Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: ...
0
votes
0answers
111 views

Array of string in MDX

I have a dimension attribute that has composite key, such as CalendarQuarter in this post. This means my attribute members will have members that can be written as: ...
0
votes
0answers
27 views

How do I manage environment specific connections for SSAS projects?

I am using SQL Server 2012 and I am responsible for implementing release automation for our SQL, SSIS, and SSAS projects. SSIS projects have project parameters and you can link those to SSISDB ...
0
votes
0answers
85 views

SSAS - Many to many Relationship with Slowly Changing Dimension Type 2

I'm trying to solve the following scenario: I have a "Zone" dimension, a "Tile" dimension and a "Position" facttable. Within the facttable the duration of a hit on a tile is saved. The Many to Many ...
0
votes
0answers
11 views

SSAS firewall / restricted direct database use

We want to open ports 2382 / 2384 for users in AD group A (they are supposed to read SSAS data via a sharepoint frontend only). That can be easily done with the windows server firewall, I guess. ...
0
votes
0answers
25 views

What known strategies, if any, can I use to validate a Slowly Changing Dimension?

I have a customer dimension in our data warehouse (SSAS 2014 Multidimensional). It is set up as a Type II SCD, with just Start and End Date fields to track changes. (null end date = current). As our ...
0
votes
0answers
30 views

Is it a good idea to use SSAS to predict hourly transactions?

So I've been working on this for quite some time but I run into so many obstacles that I am beginning to wonder if I am using the right tool for the job. My problem is pretty simple: I have several ...
0
votes
0answers
148 views

User-mapped Error processing SSAS cubes

I'm receiving the following error message intermittently whilst attempting to process an SSAS cube. I've changed the SSAS memory parameters as per this link, but am still intermittently recieving ...
0
votes
0answers
27 views

Extremely high memory usage for datacube with 25k records

I have a system with 16GB memory (8 allowed for SSAS) and limiting it to looking at 25k rows of orders. I have 4 dimensions. Date, Customer Data, Sales Person, and Orders (has just ID and date) I have ...
0
votes
0answers
64 views

Which is the best way for selecting dimension attributes while creating a dimension?

I'm a newbie to SSAS OLAP so please apologize me if it was a silly question but surely I need suggestions. I would like to make clear some concepts which was confusing for me. Let us consider five ...
0
votes
0answers
24 views

Efficient settings for linked server to SSAS database

We are using OPENQUERY scripts to run MDX from sql-server. We're experiencing efficiency issues when we first run these queries each morning. The linked server objects which link to our SSAS ...
0
votes
0answers
13 views

create siblings ssas

If you have a parent-child dimension how can the power users easily create new level in the hierarchy? In SSAS is the posiblity to enable WriteBack and easy create new child and new sibling. Can you ...
0
votes
0answers
152 views

Problem in Incorporating filters into Data Warehouse design

While implementing a data warehouse (proof of concept) I have a requirement to incorporate a user level save-able filter on dimensions. The requirement is a proof of concept so I have the liberty to ...
0
votes
0answers
148 views

How to design the table and its relationship?

I am having a problem designing a Dim and Fact Table for the following problem. I want to display my data in PivotGrid as below : First table shows that if i search a person, anyone related to ...