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

learn more… | top users | synonyms

0
votes
0answers
12 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
1answer
108 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 ...
3
votes
1answer
52 views

Wich is the most efficient/easy way for end-user to get data from Analysis database?

I know that you can quey a cube by connecting from excel to Analysis database and using formulas like cubevalue() or cubemember(). I also know that after converting the power pivot to formulas you can ...
3
votes
2answers
852 views

Run a PowerShell script on a different server - from inside a SQL Server job

I have a procedure to backup SSAS Databases. That is working as a charm. Now my server is filling up with SSAS backups and I would like to delete the backup files that are older than 2 days. to ...
1
vote
2answers
485 views

Huge Analysis Services log file: msmdsrv.log

I've just discovered our prod analysis services is writing to a log that is 1.6 GB in size. I was able to get a copy of the log file saved off to an alternate location and open it in WordPad ...
0
votes
1answer
2k views

Linked Server from SQL Server to SSAS not working - what is missing?

I have a SQL Server 2012 Standard edition sp1 that has ssas also installed. From this server I create a linked server to a ssas server called BIREPLON1, but when I try to access it, I get the error ...
1
vote
1answer
1k views

routine to backup ssas databases fails with: The XML for Analysis request timed out before it was completed

I have developed my own stored procedure, that through a LINKED SERVER, backups the SSAS databases according to a table value parameter. the code for the stored procedure is below. the problem: it ...
0
votes
0answers
145 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
1answer
170 views

SSAS / MDX Query - Need row total

I would like to add an additional row that will display the Total order count for all the different Customers in the Customer Dimension. Below is the query that I have been trying to modify. SELECT ...
1
vote
0answers
214 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, ...
0
votes
1answer
183 views

Cube Processing vs Database Processing

We have a SSAS database (SQL Server 2012 Enterprise) with 4 cubes in it. 1 of the cubes is significantly bigger than the other 3. We want to process the 3 smaller cubes at regular intervals during the ...
21
votes
1answer
2k views

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: ...
0
votes
0answers
61 views

KPI behavior (Calculate member)

I have create the following tendency (IIF([Measures].[Age]=TRUE,1,0)+ IIF([Measures].[Idle]=TRUE,1,0)+ IIF([Measures].[Labor]=TRUE,1,0))/3 My issue is that in excel if I use this (or the kpi) the ...
1
vote
1answer
845 views

SSAS : An error occurred when instantiating a metadata object

Aside from installing SSAS, I have no experience using it. Our developers are saying that it is no longer possible to create a new aggregation, whatever the cube. The error occurs when hitting ...
0
votes
0answers
79 views

Setup for Availability Group with Analysis Services

We currently have one server with the Database Engine, SSAS, SSRS and SSIS all running on it. We are moving to a two server Availability Group setup. Currently I am not too worried about resources ...
3
votes
2answers
2k views

MDX calculated member to band a measure

I am trying to add a calculated member to an MDX query which will create a set of "Age Bands" for people in my database. I have a measure which contains the age of each person. I have started with ...
1
vote
2answers
399 views

Analysis Service Connection String

I use sql server 2012, and have multi cube. I can connect to my created cube from Excel (Data Tab\Connections) with windows authentication. How can set permission to SQL Server user on my cube. and ...
1
vote
0answers
350 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 ...
0
votes
2answers
535 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
623 views

Dealing with measure groups of different granularity

Let's say I have a simple data warehouse with the following fact tables: FactPurchase: one row per property purchased, with purchase amount, value, etc. FactMonthlyStatus: one row per property, per ...
1
vote
0answers
130 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, ...
6
votes
3answers
1k views

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 ...
2
votes
1answer
25k views

SQL Server is configured to allow remote connections

I use SQL Server 2012 and SSAS Tabular Mode (My Instance Name Is MSSQLSERVER2012T) Then I download AdventureWorks Tabular Model SQL Server 2012 From This link I open it with Visual Studio 2010 and ...
2
votes
0answers
588 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
546 views

Wrong aggregation of Measures in Analysis Service in combination with UNION and DESCENDANTS

Update: When I tried to provide a simple example which reproduces the issue I found the leveller in my database which introduces this issue. Therefore I did an update to this question in order to ...
1
vote
0answers
406 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 ...
0
votes
1answer
497 views

Data Warehouse - Slowly Changing Dimensions with Many to Many Relationships

As an example, let's say I have a fact table with two dimensions and one measure FactMoney table ProjectKey int PersonKey int CashAmount money The two dimensions are defined like this: ...
0
votes
1answer
569 views

Kerberos Authentication Issue

I'm getting these errors when testing a linked server from SQL Server 2012 to SSAS 2012 (both servers are Windows 2012 and clustered) "An error was encountered in the transport layer" and "The peer ...
2
votes
1answer
651 views

Script out XMLA for all databases

I have several SSAS databases. I only want to script out the XMLA for them on a nightly basis. This will be a second tier backup in addition to the regular backups we have. How do I auto-generate ...
2
votes
0answers
2k 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
2answers
4k views

MDX Crossjoin filtering on different hierarchies from the same dimension is very slow

I have an MDX query that was written by an MDX novice that is excessively slow (the query, that is, not the MDX novice). And I am also an MDX novice. Here is the query: SELECT NON EMPTY ( ...
1
vote
1answer
626 views

Get Results from DMV Query into SQL Server Table

today I began to troubleshoot an issue that I was asked to resolve, and for the first time I found myself querying in the SSAS database. I obtained a very useful set of results (who was connecting to ...
1
vote
0answers
431 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 ...
7
votes
2answers
963 views

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, ...
8
votes
2answers
7k 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 ...
10
votes
3answers
635 views

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 ...
4
votes
3answers
3k views

How can I dynamically back up all SSAS databases on a given instance?

I want to dynamically back up all the databases on a given SSAS instance using a SQL Agent job (which would most likely involve executing an SSIS package). It is imperative that this is a dynamic ...
2
votes
1answer
185 views

Backup on an empty SSAS database hangs

I created an SSIS package to iterate through all databases on an SSAS instance. It grabs the DatabaseId using AMO in a vbscript, then generates the XMLA to backup each database. Most databases ...
2
votes
1answer
105 views

Debugging SSAS Timeouts

I have a drill-through problem apparently related to security. Users in one role are seeing timeout failures when trying to invoke a drill-through action. They have permission on the action through ...
2
votes
0answers
46 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 ...
4
votes
1answer
298 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
0answers
173 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 ...
4
votes
1answer
486 views

Time as a measure

Is it possible to have times as measures in a cube? We're trying to view employee start times by day, aggregating as an average over time, but even with a No Aggregation measure type I'm getting an ...
1
vote
0answers
325 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 ...
3
votes
1answer
107 views

Analysis service database security at application level

I have got a SSAS Cube, we have written an windows application which would issue MDX queries to access the data from the cube and show it in the reports . This windows application is a licensed ...
2
votes
1answer
381 views

SSAS Drillthough Limit

There is a limit of 10,000 rows that can be returned for a drillthrough rowset in recent version of SSAS. I'm concerned about the risk of of returning partial results without warning if the selection ...
1
vote
0answers
196 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 ...
5
votes
1answer
5k views

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 ...
2
votes
0answers
15 views

Real-Time SSAS cube status notification [duplicate]

Possible Duplicate: Real Time SQL Server Analysis Services Cube Processing Report I would like to know if there is a way to generate a report to determine which SQL Server Analysis Services ...