Top "Ssas" questions

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

MDX: IIf condition on the value of a dimension is always false

I am trying to produce a different output in a column dependent on whether the value of a dimension [Scenario].[…

sql-server ssas mdx ssas-2008 iif
How to change the date format on SSAS 2012

I have deployed an SQL Server 2012 on a Windows Server en-us. Now my dates on Analysis services are in the …

sql-server ssas ssas-2012
Analysis Services Only Windows Authentication

Is it true that Analysis Services ONLY supports windows authentication?

sql-server sql-server-2005 ssis ssas analysis
How do I define a Calculated Measure in MDX based on a Dimension Attribute?

I would like to create a calculated measure that sums up only a specific subset of records in my fact …

sql-server ssas olap mdx
SSAS dimensions hierarchies: A duplicate attribute key has been found when processing

I am completely new to SSAS an I am trying to deploy a simple cube with only one dimention comprised …

ssas olap cube
Sql Server Services - Overview anyone?

In Short I am thoroughly confused by the array of SQL Server services available, and am having a hard time …

sql-server reporting-services reporting ssas business-intelligence
Using DateDiff in SSAS MDX

I would like to write a KPI in SSAS which gives me back the average of all the employee's age. …

ssas mdx kpi
AdomdClient missing

I would like to add AdomdClient Reference to a C# Project, but it is not in the reference list. The …

c# ssas adomd.net
SSAS DB not visible in Management Studio but can be seen in Excel

There is a SQL 2012 Analysis Server with some cubes. When I connect to it using Excel 2013 (DATA menu > From …

sql-server ssas ssms