Stack Overflow
Stack Overflow

Questions tagged [ssas]

SQL Server Analysis Services (SSAS) is part of Microsoft's SQL Server system. It provides Online Analytical Processing (OLAP) and Data Mining functionality. Not to be confused with Syntactically Awesome Style Sheets (SASS).

SQL Server Analysis Services (SSAS) is part of Microsoft's SQL Server system. It provides Online Analytical Processing (OLAP) and Data Mining functionality.

Initially released as part of SQL Server 7 it was further refined in SQL Server 2000. There were major changes from SQL 2000 to 2005 but since then (SQL2008 & SQL2008 R2) there have been incremental improvements. In SQL Server 2012, a new Tabular Model has been introduced.

You can find more information here: Wikipedia Analysis Services and here: Microsoft Analysis Services

5658 questions
6
votes
6 answers

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 the data from Business Intelligence Studio. The problem is that I cannot create a datasource view, or if I do create one without tables,…
coldilocks
  • 61
  • 1
  • 2
6
votes
1 answer

SSAS dimension source table changed - how to propagate changes to analysis server?

Sorry if the question isn't phrased very well but I'm new to SSAS and don't know the correct terms. I have changed the name of a table and its columns. I am using said table as a dimension for my cube, so now the cube won't process. Presumably I…
Phil Gan
  • 2,813
  • 2
  • 29
  • 38
6
votes
4 answers

Managing Team Development with SSAS, TFS, & BIDS

I am currently a single BI developer over a corporate datawarehouse and cube. I use SQL Server 2008, SSAS, and SSIS as my basic toolkit. I use Visual Studio +BIDS and TFS for my IDE and source control. I am about to take on multiple projects with an…
Kevin D. White
  • 1,213
  • 11
  • 11
6
votes
3 answers

Where can I download a ascmd.exe?

I need to execute MDX query from command line (MS AS 2005). I have heard, that there is a program named ascmd, which can do this. Unfortunately, when I went to codeplex page I found that page supposed to deliver an ascmd doesn't work. Please help if…
michal
6
votes
3 answers

Best Practise to populate Fact and Dimension Tables from Transactional Flat DB

I want to populate a star schema / cube in SSIS / SSAS. I prepared all my dimension tables and my fact table, primary keys etc. The source is a 'flat' (item level) table and my problem is now how to split it up and get it from one into the…
alex25
  • 621
  • 5
  • 19
6
votes
3 answers

SSAS with Kerberos delegation gets connection timeout error

I have a situation where clients connecting to my webservice(that exists on another server) must access SQL Server databases and SSAS servers. It must use the credentials of the client that is calling the service when accessing the SQL Servers and…
TheWommies
  • 4,922
  • 11
  • 61
  • 79
6
votes
1 answer

JSON Result From SSAS Cube

I am new to working with Business Intelligence/Analysis Services and MDX queries. I am developing a web app that pulls/embeds reports from a report server (SSRS reports build upon this cube data), however the result is slow and the resulting look is…
scniro
  • 16,844
  • 8
  • 62
  • 106
6
votes
10 answers

SSAS cube processing error about column binding

This is an error message I get after processing an SSIS Cube Errors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being truncated. However, it gives me no indication of…
Raj More
  • 47,048
  • 33
  • 131
  • 198
6
votes
4 answers

Combining Relational and OLAP data in an MDX Query

I have an SSAS 2008 cube that is being used to house end of day financial data from the stock market. The cube is only processed once a day after the market closes, so it never has any information about the current intraday trading data. I also…
mclark1129
  • 7,532
  • 5
  • 48
  • 84
5
votes
9 answers

Excel Pivot Table Row Labels Not Refreshing

To all, I have an Excel spreadsheet pivot table that is linked to an SSAS data source. The employee counts are aggregated and return the following values: Row Label Count North America 7 South America 2 Europe 5 Asia …
Mr_Do
5
votes
2 answers

DateAdd Column caused an overflow

After executing the following query I am getting an error Adding a value to a 'datetime' column caused an overflow. I have no idea why this is happening as it worked smoothly for a couple of weeks. I am just trying to ADD Dates here and compare…
ace_mccloud
  • 497
  • 1
  • 8
  • 25
5
votes
0 answers

Find Number of times a particular character appears in a string using MDX query

In the Microsoft SSAS, I have a dimension column that contains multiple values separated by the special character | in a single row as below. Example value of a row: Image|Video|Audio| Requirement: So, I need to count the number of values present in…
Sathish G
  • 91
  • 3
5
votes
1 answer

Multiple dimensions conditions in SSAS MDX query not working

I Am having the following data in my SSAS cube. My need is to get the value of the measure based on two conditions with two different dimensions using the MDX. In this example data, I need to get the Reseller Sales Amount value where the value…
TAMILARASAN R
  • 225
  • 1
  • 6
5
votes
1 answer

IIF() function not working properly while using multiple times in single MDX query

I need to get the aggregated values based on two conditions using single MDX query Am having below data I have created two calculated functions using IIF() function in a below query WITH MEMBER [Measures].[Expression1] AS…
TAMILARASAN R
  • 225
  • 1
  • 6
5
votes
2 answers

Tabular Cube - Excel Filtering Doesn't Function At Node Level

I have the issue described in this post. I have two cubes with the same data backing them, one a Multi-Dimensional cube, the second a Tabular cube. If I connect to the cubes with excel and drag the top level of a hierarchy(in this example "Company"…
David Rogers
  • 2,601
  • 4
  • 39
  • 84
1 2 3
…
99 100