Browse by Tags

Tagged Content List
  • Wiki Page: SSAS Error: Error loading Metadata: No cubes were found

    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...
  • Wiki Page: The Nine DataMining Algorithms in SSAS

    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...
  • Wiki Page: Event ID 0: SQL Server Analysis Services: "The service cannot be started: <servicename>"

    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...
  • Wiki Page: Connecting to SSAS Cube using Silverlight

    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...
  • Wiki Page: Data Source View

    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...
  • Wiki Page: Unified Dimensional Model

    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...
  • Wiki Page: SQL Server Analysis Services (SSAS) Troubleshooting Articles

    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...
  • Wiki Page: How to Solve the SSAS Cube Browser Error by Using Drag and Drop

    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...
  • Wiki Page: Role (OLAP)

    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...
  • Wiki Page: How to Process and Deploy an SSAS Cube

    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...
  • Wiki Page: SSAS Design Patterns

    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...
  • Wiki Page: KPI

    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...
  • Wiki Page: SSAS: Explaining the State Transitions Viewer for Sequence Clustering

    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...
  • Wiki Page: SSAS: Explaining the GetClusterCharacteristics Stored Procedure for Sequence Clustering Models

    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...
  • Wiki Page: Unified Dimensional Model (de-DE)

    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...
  • Wiki Page: Data Source View (de-DE)

    Ü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...
  • Wiki Page: Role (OLAP) (pt-BR)

    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...
  • Wiki Page: SSAS

    SSAS is an acronym for SQL Server Analysis Services .
  • Wiki Page: PowerPivot and Azure on Cloud

    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...
Page 1 of 1 (19 items)
Can't find it? Write it!