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: Explore the Adventure Works Multidimensional Model by using Power View

    This topic is now available on Office.com See, Explore the Adventure Works Multidimensional Model by using Power View
    on19 Jun 2013

  • Wiki Page: Compare Analysis Services and PowerPivot

    NOTE : This page was translated from this Spanish version by St. Joseph Lopez . This article is available in other languages: Spanish More and more customers are getting to know about PowerPivot and seek more guidance on when to use it with SQL Server...
    on13 Jun 2013

  • Wiki Page: PowerPivot: Data Analysis Expressions (DAX) Language

    Table of Contents Types of DAX Functions Overview of DAX Where to Use Formulas Creating Formulas by Using the Formula Bar Tips for Using AutoComplete Basic DAX Syntax Using Multiple Functions in a Formula DAX Data Types Formulas and the Relational Model Introduction to Context Updating the Results of...
    on13 Jun 2013

  • Wiki Page: PowerPivot: Import Data from a SQL Server Database (Video)

    This video is third in a series about using PowerPivot to import data into an Excel workbook. In this video, Michele shows you how to import data from a SQL Server relational database. Tutorial video by Michele Hart , Microsoft SQL Server Technical Writer. View all the PowerPivot videos...
    on11 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: ID de evento do Analysis Services e descrições de eventos (pt-BR)

    Esse artigo foi originalmente escrito em: Analysis Services Event ID and Event Descriptions Essas IDs de evento e descrições de evento são para SQL Server Analysis Services (SSAS) , uma ferramenta do SQL Server . Aplica-se a: SQL Server 2005 (exceto quando indicado), SQL Server 2008, SQL...
    on6 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: Release Notes: Microsoft SQL Server 2012 with Power View for Multidimensional Models CTP

    Power View for Multidimensional Models is now available with SQL Server 2012 Service Pack 1, Cumulative Update 4. For more information, see Power View for Multidimensional Models on TechNet
    on3 Jun 2013

  • Wiki Page: Create a Power View Report with a Multidimensional Model Data Source

    This topic is now available on TechNet See, Create a Power View Report with a Multidimensional Data Source
    on3 Jun 2013

  • Wiki Page: Create a Shared Report Data Source Connection to a Multidimensional Model

    This topic is now available on TechNet See, Create a Shared Report Data Source Connection
    on3 Jun 2013

  • Wiki Page: Power View for Multidimensional Models Overview

    This topic is now available on TechNet See, Understanding Power View for Multidimensional Models
    on3 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: How to Use the SQL Server Data Mining Add-ins with PowerPivot for Excel

    Table of Contents Introduction Overview of Data Mining with the Add-Ins Installation Prerequisites Installing the Data Mining Add-ins Installing PowerPivot for Excel Performance and Memory Considerations for 32-bit vs. 64-bit Versions Technical Considerations Data Stores for the PowerPivot and Data Mining...
    on26 May 2013

  • Wiki Page: PowerPivot: Install the PowerPivot Add-In for Excel

    PowerPivot for Excel is a free download that significantly expands the data analysis capabilities of Excel. PowerPivot is made up of the Excel free add-in and the SharePoint server component. Video tutorial by Michele Hart , Technical Writer for Microsoft SQL Server. View all the PowerPivot...
    on25 May 2013

  • Wiki Page: PowerPivot Introduction Videos

    PowerPivot - A world of data on a single screen, in real time! Inviting viewers to discover the power and usability of Microsofts Business Intelligence tools, we present these fun and engaging animations to introduce you to Microsoft PowerPivot for Excel 2010. Trying to convince your boss to change...
    on25 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: Troubleshoot PowerPivot for SharePoint: Installation and Configuration

    This article consists of troubleshooting tips and techniques for working through installation and configuration problems for SQL Server 2008 R2 version of PowerPivot for SharePoint. Please update this page to include any new information or links that you think will be helpful to others. Click Sign...
    on24 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: 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: PowerPivot Licensing and Pricing

    This is a community article to provide up-to-date information about PowerPivot licenses and pricing. The common questions that this article addresses are the following: What is the PowerPivot price? What is the PowerPivot pricing? How much does PowerPivot cost? Where can I find information about...
    on1 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: SSAS Cube

    Cubes in SQL Server Analysis Services are sets of related measures and dimension s. Table of Contents Overview Development Usage Credits Overview A cube is used to analyze data. This activity targets the measues of the cube, which are grouped into measure groups. The dimensions are...
    on27 Apr 2013

  • Wiki Page: Event ID 4 - SQL-Server-Analysis-Services: An error occurred while starting the flight recorder

    Table of Contents Event Details Not enough disk space Service account has insufficient permissions Resources An error occurred while starting the flight recorder. Event Details Applies to: SQL Server Analysis Services Version: SQL Server 2005, SQL...
    on22 Apr 2013

  • Wiki Page: PowerPivot: DAX: Text Functions

    Data Analysis Expressions (DAX) includes a set of text functions that is based on the library of string functions in Excel, but it has been modified to work with tables and columns. Read more about the following text functions: BLANK CONCATENATE EXACT FIND FIXED FORMAT LEFT...
    on20 Apr 2013

  • Wiki Page: PowerPivot Help

    Looking for PowerPivot Help? Click below to find answers about PowerPivot: PowerPivot for Excel 2013 on Office Support: What's New Start It About PowerPivot Tutorial PowerPivot for Excel Help on TechNet Library: SQL Server 2012 SQL Server 2008 R2 PowerPivot...
    on20 Apr 2013
Page 2 of 4 (98 items) 1234
Can't find it? Write it!

Post an Article