Top "Ssas" questions

SQL Server Analysis Services (SSAS) is part of Microsoft's SQL Server system.

SSAS One to Many Dimensional Relationship

Question in SSAS for y'all. I am attempting to define a One to Many relationship in an OLAP SSAS cube …

sql ssas relationship dimensions primary-key-design
Why to build a SSAS Cube?

I was just searching for the best explanations and reasons to build a OLAP Cube from Relational Data. Is that …

sql-server-2008-r2 ssas cube olap-cube
How to sum a calculated measure?

I have a fairly complex calculated measure that works perfectly for each row of data from a cube. However, I …

ssas mdx data-warehouse olap ssas-2008
Can't get filter to work with multiple conditions

I'm trying to make a MDX query for use with SSRS later on. To start with the basic query that …

filter ssas ssms mdx
How do I use MySQL as data source in Microsoft SQL Server Analysis Services?

I have installed the latest .net connector, I can add MySQL databases as Data Sources, I can even browse through …

mysql view ssas
How to execute a MDX query of SQL Analysis Server in C#

I want to execute a SQL Analysis Query in C#. I have successfully connected to Analysis database using the below …

c# sql-server ssas analysis adomd.net
MDX Column Alias for use in SQL

I'm trying to query our SSAS cubes and return the values into a SQL view for use as parameters in …

sql tsql ssas mdx olap-cube
SSAS Tabular Model Error: Object reference not set to an instance of an object. While trying to add tables to the tabular model

I'm trying to create my first SSAS Tabular model. I'm following the steps mentioned in following tutorial: https://msdn.microsoft.…

ssas ssas-2012 ssas-tabular
Filtering a Dimension Relative to a CurrentMember in MDX

I'm having a bit of trouble accomplishing something that I think should be relatively straightforward in MDX. I would like …

ssas mdx olap ssas-2008