Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  SQL Server Analysis Services
Tagged Content List

  • 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...
    on14 May 2013

  • 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...
    on1 May 2013

  • 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...
    on1 May 2013

  • Wiki Page: Event ID 0 - SQL-Server-Analysis-Services:The service cannot be started: : <servicename>

    Table of Contents Event Details 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 to:...
    on22 Apr 2013

  • 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...
    on14 Apr 2013

  • 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...
    on7 Feb 2013

  • 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...
    on25 Nov 2012

  • 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...
    on25 Nov 2012

  • 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...
    on23 Nov 2012

  • Wiki Page: How to Solve 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...
    on2 Aug 2012

  • 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...
    on30 Mar 2012

  • Wiki Page: Data Source View (en-US)

    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 Mar 2012

  • 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...
    on30 Mar 2012

  • 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...
    on29 Mar 2012

  • Wiki Page: SSAS

    SSAS is an acronym for SQL Server Analysis Services .
    on24 Jan 2012

  • 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. The...
    on14 Jan 2012

  • 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...
    on29 Nov 2011
Page 1 of 1 (17 items)
Can't find it? Write it!

Post an Article