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: SQL Server Samples Readme

    The SQL Server 2012 samples provide a variety of databases and files that you can use to learn about new and existing features. This article is the consolidated Readme for each sample in the SQL Server 2012 release. It provides prerequisite information, installation instructions, and links to the...
    on21 May 2013

  • Wiki Page: "Deserialization Failed" and other errors when using SQL Server Analysis Services (SSAS) systems and databases in a multi-version environment

    Scenario: IT running multiple versions of SSAS databases, servers, client libraries, and management tools from SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 This article explores some of the errors and behaviors you might encounter when running multiple versions of SSAS in the same environment...
    on14 May 2013

  • Wiki Page: DAX Resource Center

    Table of Contents You can contribute! Introduction to DAX Microsoft DAX Documentation Most Valuable Resources Samples DAX formulas in measures DAX functions Credits Welcome to the DAX Resource Center Wiki - your one stop shop for all things DAX This Wiki includes articles, whitepapers, videos...
    on14 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: 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: 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...
    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: Power View for Multidimensional Models Overview

    Microsoft SQL Server 2012 with Power View for Multidimensional Models CTP Important: This article refers to a pre-release version of Power View for Multidimensional models. Information provided in this article is without warranty and is subject to change in future releases...
    on1 May 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...
    on29 Apr 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: Analytics for Twitter 2013

    Analytics for Twitter 2013 (version 1.1) is now available for download at http://extendedresults.com/products/twitteranalytics/ This version has been enhanced to utilize twitter's version 1.1 api and was built for Office 2013 with PowerView. As a reminder, you can download the Office 2010...
    on25 Apr 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: 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: Analysis Services Event ID and Event Descriptions

    These event IDs and event descriptions are for SQL Server Analysis Services (SSAS) , a SQL Server tool. Applies to: SQL Server 2005 (except where noted), SQL Server 2008, SQL Server 2008 R2, SQL Server Code-named“Denali”. For more information about specific event errors, look it up on ...
    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

  • Wiki Page: PowerPivot: Grouping By Dates (Months, Quarters, Years, etc.) in PivotTables

    Note: Here's a more current topic about working with Dates in PowerPivot . For more information, read: The PowerPivot for Excel 2010 overview. or The PowerPivot for Excel 2013 overview. When you create a PivotTable that is based on Excel data, you can group the data in the...
    on5 Apr 2013

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

    Microsoft SQL Server 2012 with Power View for Multidimensional Models CTP Creating a Power View report using a multidimensional model as a data source is no different than creating a report based on a PowerPivot workbook, or an Analysis Services Tabular model. Power View reports are created...
    on2 Apr 2013

  • 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: Release Notes: Microsoft SQL Server 2012 with Power View for Multidimensional Models CTP

    Microsoft SQL Server 2012 with Power View for Multidimensional Models CTP Last updated: 11/29/12 This Release Notes document describes known issues you should understand before you install or troubleshoot SQL Server 2012 with Power View for Multidimensional Models.This Release Notes document...
    on6 Mar 2013

  • Wiki Page: Kerberos for Microsoft BI - With Delegation and SPN references for SQL, SSRS, SSAS, and SharePoint

    Here are the articles that can help with Kerberos, delegation, and getting Integrated Windows Authentication working with the Microsoft BI stack. What is the Microsoft BI stack? http://www.microsoft.com/bi lists SQL Server, SharePoint and Office as part of the Microsoft BI stack. Historically...
    on5 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
Page 1 of 4 (95 items) 1234
Can't find it? Write it!

Post an Article