Top "Ssas" questions

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

"Duplicate attribute key" error when attribute is not a key

I am getting the following error when processing a Dimension: Errors in the OLAP storage engine: A duplicate attribute key …

ssas
SQL Server 2012: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000

I am using Analysis services in Microsoft SQL Server 2012 on Windows 7. I tried to create Mining models and process it. …

sql-server ssas
ssas attribute key cannot be found even though it exists and is not due to duplicates

I was trying to rebuild my cube after making some changes the other day to the table/column names in …

process ssas runtime-error cube
How to get total of top 10 sales in SSRS 2012

I am taking Top 10 of Sales Volume grouped by Product categories in SSRS 2012. I need the total of these top 10 …

visual-studio-2012 reporting-services ssis ssas
SSAS MDX WHERE clause syntax - filtering multiple values from the same hierarchy

I'm quite new to data warehousing and MDX queries, and I realize that I'm probably not using the MDX syntax …

sql-server ssas mdx where-clause olap
DAX formula to concatenate three columns

I am mew to DAX. How can I concatenate three different columns say First_Name, Middle_Name and Last_Name …

concatenation ssas dax
SQL Server Analysis Services - Do I have it?

Hi I have access to SQL Server at work and I've heard some interesting things that can be done with …

sql-server ssas
OLAP Cube deployment issues

I'm really new to this, so I am probably making a simple mistake. I need to make an OLAP cube …

sql connection ssas olap cube
deployment of adventureworks cube fails: 'user does not have permission to create a new object in 'GARY-PC' or the object does not exist

when I deploy adventure works cube it fails, and i get: user does not have permission to create a new …

sql-server ssas
List dimension members with MDX query

Is there a way to list dimension members without fetching default Measure for each member?

mdx ssas