Browse by Tags

Tagged Content List
  • 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: Creating Friendly Week Names in Power Pivot and SSAS Tabular Models with DAX

    Table of Contents Problem definition Solution Conclusion Problem definition Take a quick moment to think about why these two Pivot Tables might be different and what the problem is with the week names (Note: both of the Pivots Tables are unfiltered). Pivot Table A ...
  • Wiki Page: The Nine Data Mining 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 common usage. Decision Tree: is a popular data mining algorithm, used to predict discrete and continuous variables....
  • 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: 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: 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: Tutorial: Many-to-many Dimension Example for SQL Server Analysis Services

    Table of Contents About the Data Create data structures and insert data Create the cube in Analysis Services Next Steps This post describes the data discussed in this topic in Books Online: http://msdn.microsoft.com/en-us/library/ms365407.aspx If you are just learning about many-to-many...
  • Wiki Page: Incorrect Amounts for Linked Measures in Cubes containing Many-to-Many Relationships (SSAS Troubleshooting)

    Applies to: SQL Server 2012 and SQL Server 2014 | Analysis Services multidimensional models A linked measure evaluated in the context of a many-to-many relationship can produce incorrect aggregations, either NULL or double-counted values, when you add a new many-to-many that is unknown in the original...
  • Wiki Page: SQL Server Analysis Services Portal

    This article lists known TechNet Wiki articles about SQL Server Analysis Services (SSAS) . Table of Contents Unified Dimensional Model Security Performance Administration and Monitoring Tools Query and DDL Languages Data Mining Aggregations Troubleshooting Power Pivot See Also Additional...
  • Wiki Page: Analysis Services Event 0 Service Started

    Introduction The service started: 'MSSQLOlapService'. This event appears upon service restart, indicating the operation was successful. Event Details Applies to: SQL Server Analysis Services Version: SQL Server 2005, SQL Server...
  • 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: 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...
  • 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: 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: 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...
Page 1 of 1 (23 items)
Can't find it? Write it!