Browse by Tags

Tagged Content List

Wiki Page: SSAS Error: Error loading Metadata: No cubes were found

Ed Price - MSFT

Applies to: SQL Server Analysis Services (all supported versions) This error can occur if you deliberately or accidentally set a cube's Visible property to False . When developing a cube, you might have occasion to hide a dimension. If the dimension is not selected, you can inadvertently hide...

on16 Sep 2013
Wiki Page: The Nine DataMining Algorithms in SSAS

Maheshkumar S Tiwari

SQL Server Analysis services includes nine algorithms. In addition, SSIS includes two text mining transformations. the list below summarize the nine SSAS algorithms and their commun usage. Decision Trees: is the most popular DM algorithm, it is used to predict discrete and continuous variables...

on3 Sep 2013
Wiki Page: Event ID 0: SQL Server Analysis Services: "The service cannot be started: <servicename>"

Balaji M Kundalam

Table of Contents Event Details M Maximum entries in the event log prevent service startup Installation error prevents service from starting Other reasons why the service fails to start Resources The service cannot be started: 'MSSQLOlapService'. Event Details Applies...

on31 Aug 2013
Wiki Page: Connecting to SSAS Cube using Silverlight

Naomi N

Some time back when I was watching a presentation of a third party reporting product, I saw some nice animated charts. I wanted to create something similar to those charts and when I checked on SSRS, unfortunately what I wanted isn't possible with SSRS. So I moved into Silverlight Charts and I...

on30 Aug 2013
Wiki Page: Data Source View

Richard Mueller

Overview In SQL Server Analysis Services (SSAS), a data source view is a diagram of one or more relational data sources for the SSAS database. Developers use components from the data source view to construct the SSAS database's objects (e.g. dimensions and measure groups ). SSAS uses the data...

on30 Jul 2013
Wiki Page: Unified Dimensional Model

Richard Mueller

Table of Contents Definition Components Community Resources See Also Other Languages Brazilian Portuguese (pt-BR) German (de-DE) Definition The Unified Dimensional Model (UDM) is the model for data in a SQL Server Analysis Services (SSAS) database. The UDM is unified because it combines data...

on30 Jul 2013
Wiki Page: SQL Server Analysis Services (SSAS) Troubleshooting Articles

Ed Price - MSFT

The following links go to key troubleshooting articles in the MSDN Library, support articles, and to videos. All these links are for SQL Server Analysis Services (SSAS). Analysis Services Stops Accepting New Connections –Processing commit locks hurt Error from AS client tools - "Property...

on2 Jul 2013
Wiki Page: How to Solve the SSAS Cube Browser Error by Using Drag and Drop

Ed Price - MSFT

How to solve SSAS cube browser error and doing some drag and drop. Summary: This is in an example of correcting the error in a Cube in SSAS. Problem: In our situation there was a problem when we browser a cube and drag any field it show some error. The query could not be processed: 0 XML for...

on2 Jul 2013
Wiki Page: Role (OLAP)

Ed Price - MSFT

SQL Server Analysis Services enforces OLAP security through roles. A user can access OLAP data if the user's name has been added to a role with access to OLAP data. If the user's name has not been added to a role, the user will not have access to OLAP data, regardless of any configurations...

on29 May 2013
Wiki Page: How to Process and Deploy an SSAS Cube

Peter Geelen - MSFT

Summary This is in an example of deploying and processing a Cube in SSAS. Problem In our situation there was a problem when we deploying and processing a cube it show some error. Errors and Warnings from Response Internal error: The operation terminated unsuccessfully. OLE DB...

on14 May 2013
Wiki Page: SSAS Design Patterns

Aalam Rangi

Table of Contents Books Articles / Blog Posts Cube Build/Design Patterns Other Articles Case Studies This is a stub page for SQL Server Analysis Services (SSAS) design patterns. Having a collection of design patterns in one wiki will cut down on estimation, development and maintenance of SSAS projects...

on14 Apr 2013
Wiki Page: KPI

Richard Mueller

Overview In SQL Server Analysis Services (SSAS) , a key performance indicator (KPI) is a metric that a business uses to measure its success and progress. The metric is compared against a goal to determine its position relative to that goal and its velocity (trend). For example, a business might...

on7 Feb 2013
Wiki Page: SSAS: Explaining the State Transitions Viewer for Sequence Clustering

Ed Price - MSFT

Original article (before edits) by Allan Mitchell , SQL Server MVP and principal consultant at Konesans Limited in the UK. You can find Allan’s website at www.SQLIS.com . NOTE : Alternatively, you can download a Word file of this whitepaper at TechNet Gallery . This is for several potential...

on25 Nov 2012
Wiki Page: SSAS: Explaining the GetClusterCharacteristics Stored Procedure for Sequence Clustering Models

Ed Price - MSFT

Original content by Allan Mitchell , SQL Server MVP and principal consultant at Konesans Limited in the UK. You can find Allan’s website at www.SQLIS.com . NOTE : Alternatively, you can download a Word file of this whitepaper at TechNet Gallery . This is for several potential reasons: (1...

on25 Nov 2012
Wiki Page: Unified Dimensional Model (de-DE)

Horizon_Net

Table of Contents Definition Komponenten Quellen Siehe auch Andere Sprachen English Português Definition Das Unified Dimensional Model (UDM) ist ein Datenmodell in SQL Server Analysis Services (SSAS) Datenbanken. UDM vereint dabei Daten von verschiedenen relationalen Datenbanken in einen...

on30 Mar 2012
Wiki Page: Data Source View (de-DE)

Horizon_Net

Überblick In SQL Server Analysis Services (SSAS) ein Data Source View ist eine Sammlung von einer oder mehren relationalen Datenbanken für die SSAS Datenbank. Entwickler nutzen Komponenten vom Data Source View um SSAS Datenbank-Objekte (z.B. Dimensionen und Measure Groups) zu erstellen...

on30 Mar 2012
Wiki Page: Role (OLAP) (pt-BR)

Fernando Lugão Veltem

Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/8790.role-olap.aspx SQL Server Analysis Services impõe segurança OLAP através de funções ou roles. Um usuário pode acessar dados OLAP, se o nome do usuário...

on29 Mar 2012
Wiki Page: SSAS

Ed Price - MSFT

SSAS is an acronym for SQL Server Analysis Services .

on24 Jan 2012
Wiki Page: PowerPivot and Azure on Cloud

MCSD_MVP

NOTE : This article needs more work. Please add information as you can. In today's world every one needs business intelligence to analyze data - sometime you do not now know -where your data is, it may be residing somewhere in legacy system or in ERP or in any management system, so if you want...

on29 Nov 2011