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

I'm using SQL Server 2014 with FileTables to store a large number of documents in different formats. The iFilters are working great, and everything is getting indexed with FTS + Semantic Search. Now ...

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

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

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

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

We are using OLAP in our Project. 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 in ...

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

I have started studying for the MCSE BI exam. I would like to have both the multidimensional and tabular modes available for studying/practice purposes. I have a SQL Server 2014 Developer Edition with ...

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

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

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

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

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

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