Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  olap
Tagged Content List

  • Wiki Page: Star Schema

    Overview In SQL Server Analysis Services (SSAS) , a star schema describes a common data model for relational data warehouses. In a star schema, there are two types of tables: fact tables and dimension tables. In general, a relational data warehouse is a historical repository of a business's...
    on31 Jul 2013

  • 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...
    on30 Jul 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...
    on30 Jul 2013

  • Wiki Page: Measure Group

    Overview Measures are the numeric values of the facts (transactions) that users analyze in an OLAP database. In SQL Server Analysis Services (SSAS) , measures that come from the same source table in the OLAP database's data source are grouped together in a container called a measure group...
    on22 Jun 2013

  • Wiki Page: Time Dimension

    Table of Contents Overview Population Script OLAP Development Overview Population Script OLAP Development
    on22 Jun 2013

  • Wiki Page: Perspective

    Overview In a SQL Server Analysis Services (SQL) database, a perspective is a limited view of a cube . Perspectives enhance a user's experience by limiting the cube's visible objects to those objects relevant to the user's work. For example, a business that sells products through brick...
    on22 Jun 2013

  • Wiki Page: Dimension

    Overview A dimension is a key component of a SQL Server Analysis Services (SSAS) database. In the Unified Dimensional Model that is the data model of an Analysis Services database, dimensions describe the data, and users browse, filter, and aggregate data by manipulating dimensions. Understanding...
    on11 Jun 2013

  • Wiki Page: SQL Server Analysis Services (SSAS) (pt-BR)

    Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/1175.sql-server-analysis-services-ssas.aspx Table of Contents Visão geral Análise serviços Wiki artigos 101 Modelagem Dimensional Segurança Desempenho Administração...
    on6 Jun 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...
    on29 May 2013

  • Wiki Page: Cube

    Overview In a SQL Server Analysis Services (SSAS) database, a cube is the container for the objects and data that users query: dimensions , measure groups , KPIs , and perspectives . A cube is analogous to a schema in a relational database: it brings together the metadata, data, and code related...
    on25 May 2013

  • Wiki Page: Grain (OLAP)

    Overview In SQL Server Analysis Services (SSAS) , the grain or granularity of a fact defines the level of detail recorded in the fact; it is determined by the dimension keys of the fact. If a fact references the key attribute of a dimension, then it records data at the most descriptive level of...
    on8 May 2013

  • Wiki Page: Problem Processing Mining Structure When DataSource is OLAP Cube

    Table of Contents Background Explanation Workarounds Discussion Background A customer recently experienced a problem when processing a data mining structure that is based on a cube: that is, the data source for the clustering model was queried from the Analysis Services cube rather than the underlying...
    on3 May 2013

  • Wiki Page: Snowflake Schema

    Overview In SQL Server Analysis Services (SSAS) , snowflake schema describes a popular data model for relational data warehouses. Similar to a star schema , a snowflake schema contains fact and dimension tables, with the fact table storing facts about business transactions and some columns...
    on2 May 2013

  • Wiki Page: Fact (OLAP)

    Overview In SQL Server Analysis Services (SSAS) data warehousing and OLAP/UDM solutions, a fact is a single record, usually representing a business transaction, at the lowest level of granularity recorded in the database. Facts are composed of dimension keys and measures ; the dimension keys reference...
    on1 May 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: SQL Server Analysis Services (SSAS)

    Table of Contents Overview Analysis Services Wiki Articles Dimensional Modeling 101 Security Performance Administration and Monitoring Tools Query and DDL Languages Data Mining See Also Other Languages Brazilian Portuguese (pt-BR) German (de-DE) Overview SQL Server Analysis Services (SSAS) is...
    on3 Aug 2012

  • Wiki Page: Tabela Fato x Tabela Dimensão (pt-BR)

    Nota de Migração : Este artigo foi migrado para o Portal Wiki em Português. O conteúdo será atualizado aqui http://social.technet.microsoft.com/wiki/pt-br/contents/articles/12577.tabela-fato-x-tabela-dimensao.aspx . BI(Business Intelligence) é um termo...
    on23 Jul 2012

  • Wiki Page: OLTP x OLAP (pt-BR)

    Nota de Migração : Este artigo foi migrado para o Portal Wiki em Português. O conteúdo será atualizado aqui http://social.technet.microsoft.com/wiki/pt-br/contents/articles/12576.oltp-x-olap.aspx . OLTP O OLTP (On-line Transaction Processing) captura as...
    on23 Jul 2012

  • Wiki Page: SQL Server Analysis Services (SSAS) (de-DE)

    Table of Contents Überblick Analysis Services Wiki Artikel Multidimensionale Modellierung Performance Administration und Monitoring Tools Abfrage und DDL Sprachen Data Mining Siehe auch Andere Sprachen English Português Überblick SQL Server Analysis Services (SSAS) ist Microsoft's...
    on30 Mar 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: Grupo de Medidas (pt-BR)

    Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/measure-group.aspx Visão Geral As medidas são valores numéricos dos fatos (operações) que analisam os usuários em um banco de dados OLAP. No SQL Server...
    on30 Mar 2012

  • Wiki Page: Measure Group (de-DE)

    Überblick Measures sind numerische Werte aus Fakten (Transaktionen), die ein Nutzer in einer OLAP Datenbank analysieren kann. Im SQL Server Analysis Services (SSAS) werden Measures, die aus der selben Quelltabelle der OLAP Datenbank kommen, in sogenannten Measue Groups zusammengefasst. ...
    on30 Mar 2012

  • Wiki Page: Snowflake Schema (pt-BR)

    Esse artigo foi originalmente escrito em : http://social.technet.microsoft.com/wiki/contents/articles/snowflake-schema.aspx Visão Geral No SQL Server Analysis Services (SSAS) , snowflake schema descreve um modelo de dados populares para data warehouses relacionais. Semelhante ao star...
    on30 Mar 2012

  • Wiki Page: Exibição de Fonte de Dados (pt-BR)

    Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/data-source-view.aspx Visão Geral No SQL Server Analysis Services (SSAS), o Data Souce View é um diagrama de um ou mais fontes de dados relacionais da fonte de dados da base de...
    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
Page 1 of 2 (38 items) 12
Can't find it? Write it!

Post an Article