Background info: Hardware is much less expensive than consultant billing hours. I am a developer, not a hardware guy. I have been asked by an IT department for the SSAS system requirements. The server ...

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 ...

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 ...

After spend almost decade in OLTP world I got the courage to try to build my first CUBE.
I installed VS2012 and created Business Intelligence -> Analysis Services.
I did build Data Source Views, Cube ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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, ...

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 ...

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 ...

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 ...

We have set up our Microsoft 2012 Analysis Server as per Microsoft's best practice guide found here:
http://technet.microsoft.com/library/Cc966449
In particular, we're looking at how to swap from AS2 ...

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 ...

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, ...

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 ...

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 ...

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 ...

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 ...

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 ...