Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [ssas]

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

79 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
0answers
165 views

Using the Schema Generation Wizard to regenerate a previously-generated schema

Lately, I've been trying to clean up a group of projects that my company received from an outside contractor. Among them is an SSAS cube, with an associated data warehouse. The contractors generated ...
5
votes
1answer
5k 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: '...
4
votes
1answer
681 views

Should I snowflake or duplicate it across my facts?

I'm building up a data warehouse to be used by SSAS to create cubes on, and I'm debating between two possible schemas. In my warehouse, I've got two different fact tables that tracking daily changes ...
3
votes
1answer
300 views

OLAP linked server fails connection test

I am trying to create a new linked server to an Analysis Services database and I would like to use this linked server to import data into a SQL Server table. example: SELECT * into raw.example ...
3
votes
0answers
5k 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], [Measures].[...
3
votes
0answers
221 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
43 views

Query to get Object_ID and Dimension_Name from DMV

I am looking for a DMV query which contain Dimension_Name and Object_ID together. I have System.mdschema_dimensions to get the Dimension Unique name and System.discover_object_activity to get the ...
2
votes
0answers
965 views

SSAS different results between database process-full and dimension process-update

I have an Analysis services database with several cubes in it. We have a nightly job that extracts data from our source database to some staging tables, and another that performs a "Process Full" of ...
2
votes
0answers
600 views

MDX calculation of an Average Over Time with delta update on the fact table

I am having a problem creating this MDX calculation : Average Price of products over time knowing that my fact table gets price updates incrementally; In order to calculate the average price of ...
2
votes
0answers
8k views

How to check the status of an SSAS cube while it is processing

When one processes an analysis services cube in Sql Server Management Studio, by right clicking on the cube name in the GUI and selecting the "process" option, a GUI pops up and displays the status of ...
2
votes
1answer
476 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 object ...
2
votes
0answers
2k 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
1answer
65 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
488 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
1k 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
247 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
50 views

Does anyone deployed a succesful SSAS on docker?

I'm trying to create a docker image that contains MS SQL server, analysis services, and restore a db (bak) and a cube (abf). The Sql server part is the easy stuff, and I imagine that the restore will ...
1
vote
0answers
27 views

Error while trying to process dimension in SSAS

I am getting the below error when I try to process my dimension in Analysis services from SQL Server Management Studio. Errors in the OLAP storage engine: The attribute key cannot be found when ...
1
vote
0answers
82 views

My Fact table has data weekly but it is not visible in SSAS cube

I have my fact table that has data in weekly basis, so I am mapping with Week dimension to pull records in Piviot table. My ssas cube doesnt show all data that is in fact. Should I add any specific ...
1
vote
0answers
64 views

SSAS error - invalid attempt to read when reader is closed

I'm trying to run my SSAS project but I got an error. I'm using a MySQL database as my data source. I can connect and build the view, but when I create a dimension and I try to run it get this error:...
1
vote
0answers
368 views

connection to remote Analysis Services from SSMS

On my company local SQL Server instance I was able to add a linked server to a remote AS instance (in Management Studio > Server Objects). I was also able to connect using Data Tools, as well with ...
1
vote
0answers
213 views

How to improve performance of SSRS report using Cubes as data source?

I am trying to build an SSRS report with SSAS as the data source. It has 4 cascading parameters. I used the SSRS Query designer to generate MDX because I am not very familiar with Cubes/MDX. It works ...
1
vote
1answer
3k views

Can't deploy SSAS Tabular Model in Visual Studio

I am following the SSAS Tabular Model Tutorial by Microsoft using the Adventure Works DW. I've imported the DW in SQL Server Management Studio to my local server. I've connected to the DW from Visual ...
1
vote
0answers
111 views

Proactive caching vs. nightly cube reprocess

I'm working with an SSAS cube that's fully reprocessed every night by an SSIS job. My current goal is to get data into the cube with less latency, and to do so I'm looking at implementing proactive ...
1
vote
0answers
21 views

Tier Dimension based on measure value

I have a case where i need to have a dimension based on measure value. example : the fact table is linked to date dimension through DateID, and what i want to add is another dimension for Tier, but ...
1
vote
2answers
54 views

Is it ok to install a SSAS 2016 instance next to a SQL Server 2014 instance?

Should I expect any problems installing a SQL Server Analysis Services 2016 tabular instance next to a SQL Server 2014 database engine? (e.g. due to an update of some shared components) I'm mostly ...
1
vote
0answers
144 views

Permission error while browsing the Dimension when Dimension Security is defined on one of the attribute

I am using SSAS SQL Server for dimension modelling, and the dimension is defined as below: Dimension Name: Department Dimension Attributes: Location DepartmentCode DepartmentType I have ...
1
vote
0answers
209 views

Reduce RAM required to process OLAP cube

I have a cube which I have created by using (in Visual studio) New Project -> Import from Server (Multidimensional and data mining). This cube is indeed created from the metadata of an already ...
1
vote
0answers
328 views

Problem with creating SSAS Roles using Powershell

I'm using powershell to (mass) delete and create roles in SSAS. Deleting is done like this : $rolecount = $db.Roles.count for ($i = 0; $i -lt $rolecount; $i++) { Write-host ($db.Roles....
1
vote
0answers
38 views

SSAS 2016 and XMLA: Problem retreiving “MDSCHEMA_ACTIONS” Rowsets under specific scenario

I'm developing a Web client that uses XMLA over HTTP calls to communicate with a SSAS 2016 Cube. When my client's user clicks on a cell in a pivot grid that is based on this cube, I would like to ...
1
vote
0answers
287 views

How make an SSAS Tabular model case sensitive?

I need to make my tabular model case sensitive. Currently my tabular model is case insensitive, how do I change my existing cube to be case sensitive?
1
vote
0answers
61 views

Incorrect hierarchy relationship while joining with parent-child tables

I have two tables with 1:M relation in my DB: GROUP (GroupId, GroupName, AccountId) USER (UserId, UserName, GroupId, AccountId) and ACCOUNT (AccountId, AccountName). I added all needed links from ...
1
vote
0answers
241 views

Unable to establish linked server connection to SSAS 2008 R2 server

I'm interested in gathering some DMV data from our SSAS cubes and store it on our management box. When I create the linked server for this effort I run into an error establishing the connection. ...
1
vote
0answers
774 views

SSAS 2012 role fails to start in a Win 2012 cluster

I started a thread in MSDN SSAS Forum. Please see this and help me understand the problem. I have never seen this sort of issue before. I'll try to explain the issue here as well. I got SQL Server ...
1
vote
0answers
306 views

Move SSAS database to another server without detach-attach

We take drive level snapshots of our source server every day, so we have copies of the folder OLAP\DATA. We are trying to restore a database from 10th March and 11th March to a destination server ...
1
vote
0answers
981 views

Improve SSAS Tabular query performance

I'be build a Tabular Cube with FactTable and four dimensions. Fact table has about 2.500.000 of rows (and about 20 calculated measures on the cube level) and dimension tables from 5k-50k of rows. When ...
1
vote
0answers
130 views

SQL Server installation error: other instance on drive has filepath over 260 characters

I'm a first-time poster here so apologies for any etiquette lapses, but here is my question... I am attempting to install SQL Server 2012 Enterprise Edition Database Engine onto a SAN drive called E: ...
1
vote
0answers
111 views

SSAS 2014, Relation OLAP - Poor performance, high resource usage, what did I do wrong?

Let me start with the background, I was working on a project that needed a back end that was scalable and fast. Having worked quite a bit with SSAS, I thought I'd try SSAS's in memory solution, ...
1
vote
0answers
117 views

users have access to ssas tabular instance without giving them a role

I have created a ssas tabular model. Testing the row level security base on a user I found out that it didn't work. I tested it on an user which is not known in the SQL database and analysis ...
1
vote
0answers
407 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 ...
1
vote
0answers
223 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
2k 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
31 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
70 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 ...
1
vote
0answers
187 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
47 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
1k 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
217 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
748 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
872 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 ...