Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

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

  • Wiki Page: SSAS Aggregation File Could Not be Opened (-1 Error)

    Applies to: SQL Server 2012 SP1 (build number 11.0.3000 and later) and SQL Server 2008 R2 SP1 (build 10.50.2500 and later), using Analysis Services cubes having aggregation designs on a partition Aggregation indexing has been disabled in recent service packs, causing an error to occur when an aggregation...
    on7 Mar 2013

  • Wiki Page: Tutorial: Optimize a Sample PowerPivot Model for Power View Reports (SQL Server 2012 Release Candidate 0)

    Important: This version of this tutorial was last updated for SQL Server 2012 Release Candidate 0. For the most up-to-date version of this tutorial, see: Tutorial: Optimize a Sample PowerPivot Model for Power View Reports See Also Power View (SSRS) Tutorial: Create...
    on2 Mar 2013

  • Wiki Page: PowerPivot: DAX: Operator Reference

    The Data Analysis Expressions (DAX) language uses operators to create expressions that compare values, perform arithmetic calculations, or work with strings. Original article (before wiki edits) was written by Jeannine Takaki , Microsoft SQL Server Analysis Services Technical Writer. ...
    on28 Feb 2013

  • Wiki Page: PowerPivot: DAX: Filter Functions

    The filter and value functions in Data Analysis Expressions (DAX) are some of the most complex and powerful, and differ greatly from Excel functions. The lookup functions work by using tables and relationships, like a database. The filtering functions let you manipulate data context to create dynamic...
    on20 Feb 2013

  • Wiki Page: PowerPivot: DAX: Logical Functions

    Logical Data Analysis Expressions (DAX) functions act upon an expression to return information about the values or sets in the expression. For example, you can use the IF function to check the result of an expression and create conditional results. Read more about the following logical functions...
    on20 Feb 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: Como determinar que puerto esta utilizando SQL Server 2012 Analysis Services

    Un inconveniente común ahora entre muchos clientes que han implementado SQL Server Analysis Services en su versión 2012, es el cambio dinámico de puertos, típicamente estábamos acostumbrados a tener un puerto fijo en SSAS en versiones anteriores del producto, a partir de SQL Server 2012 y específicamente...
    on31 Jan 2013

  • Wiki Page: QuickStart: Learn DAX Basics in 30 Minutes

    By: Owen Duncan, MSFT This QuickStart is for users new to PowerPivot or tabular model projects authored in SQL Server Data Tools. It is meant to give you a quick and easy introduction on how you can use Data Analysis Expressions (DAX) to solve a number of basic data modeling and analytical problems...
    on10 Jan 2013

  • Wiki Page: SSRS 2008 R2 Atom Data Feeds for PowerPivot

    This article focuses on a new feature of SQL Server Reporting Services 2008 R2: enabling data feeds to be exported from a report and consumed in the new SQL 2008 R2 PowerPivot client. With the release of SSRS 2008 R2, we now have a new rendering extension to render Atom data feeds from SSRS reports...
    on24 Dec 2012

  • Wiki Page: Install PowerPivot for SharePoint on a Domain Controller

    This is a 4-part PowerPivot video series: How to install a system and get it up and running in a standalone demo system environment. All four videos are on this page. Table of Contents Part 1: Installing a Domain Controller and PowerPivot Part 2: Creating User Accounts Part 3: Installing the SharePoint...
    on24 Dec 2012

  • Wiki Page: PowerPivot Survival Guide

    This is a list of external (non-wiki) resources for PowerPivot . To add to or rearrange the list, just click the Edit tab on the top of this page. In this article, you can find links in the following categories: Overviews Adding and Maintaining Data -- includes importing data and refreshing...
    on25 Nov 2012

  • 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: PowerPivot for SharePoint Architecture

    This article is a video tour of the architecture you'll work with when using PowerPivot for SharePoint. There are four videos in this series, and you can watch them all on this page. This series is presented by Lee Graber , Senior Software Developer, Microsoft SQL Server Analysis Services. The...
    on20 Sep 2012

  • Wiki Page: Calendar Analytics for Office 15

    This Wiki article is intended to document new features for Calendar Analytics 2.0 This version is intended to fix bugs and add support for Office 15. Please add comments with any suggestions you may have. As a reminder, you can download Calendar Analytics 1.0 here .
    on3 Sep 2012

  • 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: PowerPivot: DAX: Statistical Functions

    Data Analysis Expressions (DAX) provides many functions for creating aggregations such as sums, counts, and averages. These functions are very similar to aggregation functions used by Microsoft Excel. Read more about the following statistical functions: AVERAGE AVERAGEA AVERAGEX COUNT...
    on8 May 2012

  • Wiki Page: PowerPivot: DAX: Date and Time Functions

    The Date and Time Functions in Data Analysis Expressions (DAX) are similar to date and time functions in Microsoft Excel. However, DAX functions are based on the datetime data types used by Microsoft SQL Server. DAX also includes a set of time intelligence functions that enable you to manipulate data...
    on4 May 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 3 of 4 (98 items) 1234
Can't find it? Write it!

Post an Article