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...
    on20 Sep 2013

  • Wiki Page: Custom MDX Query for Excel Filters

    More Often we may want to write custom Filters for Cube Data retrieved through Excel. You can achieve it through VBA or simply by adding few iterations on Excel. We can Achieve Custom calculations by simply adding OLAP PIVOT TABLE Extension to EXCEL . A common scenario would be building a 13 week...
    on20 Sep 2013

  • Wiki Page: Using Claims Authentication across the Microsoft BI Stack

    Applies to: SQL Server Analysis Services (SSAS), SQL Server Database Engine, SQL Server Reporting Services (SSRS), PowerPivot for SharePoint, SharePoint 2010 and 2013, Excel Services, PerformancePoint Services, Excel, PowerPivot for Excel, Power View This post is for Solution Architects who are...
    on18 Sep 2013

  • Wiki Page: Calendar Analytics for PowerPivot: Feature Requests & Changes

    This wiki article exists is to capture feature requests, design changes, and bug fix requests for Calendar Analytics. Please leave a comment with your feature or design change requests (or add them by using the Edit tab). For bugs, please check http://social.technet.microsoft.com/wiki...
    on17 Sep 2013

  • Wiki Page: Analysis Services (SSAS) Error Messages

    Applies to: SQL Server Analysis Services This page links to error message content on the WIKI, but feel free to add links to other web pages that provide error message help. Errors on this page are listed alphabetical order. Some errors are also raised as events, in which case they also appear in...
    on16 Sep 2013

  • Wiki Page: Event ID 0: SQL Server Analysis Services: "The service cannot be started: <servicename>"

    Table of Contents Event Details M 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...
    on31 Aug 2013

  • Wiki Page: PowerPivot Overview

    Microsoft’s Analysis Services product team (in the SQL Server division) has developed a new product that provides self-service BI (Business Intelligence) functionality for users of Microsoft Office. This product is generally referred to as PowerPivot , and it consists of both a client-side component...
    on29 Aug 2013

  • Wiki Page: PowerPivot Measures

    This article shows you how to create a measure based on data in the Data Analysis Expressions (DAX) sample workbook. The workbook includes bike-related data from the AdventureWorks database. For information about where to get the sample workbook, see Get Sample Data for PowerPivot in the TechNet Library...
    on21 Aug 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...
    on16 Aug 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...
    on13 Aug 2013

  • Wiki Page: Analytics for Twitter: Known Issues

    This Wiki article documents some known issues with version 1.3 of Analytics for Twitter. Click here to download the latest version of Analytics for Twitter. Analytics for Twitter is being refreshed for Office 2013. For updates & status please visit the Analytics for Twitter 2013...
    on8 Aug 2013

  • Wiki Page: Currency Conversion in SSAS 2012 (Multidimensional & Tabular)

    Types of Currency Conversion As defined by the Business Intelligence Wizard in Multidimensional, there are 3 types of currency conversion. One-to-many . In this case we store the transactions (for example in the data warehouse) in a single base currency. Even if they originally took place in...
    on6 Aug 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...
    on31 Jul 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...
    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: Calendar Analytics for PowerPivot: Known Issues 2

    This Wiki article documents some known issues with version 1.0 of Calendar Analytics. There is a new Wiki article for version 2.0 Calendar Analytics. The new Wiki article outlines new features, bug fixes, and Office 15 compatibility in version 2.0 found here: http://social.technet.microsoft...
    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: Analytics for Twitter 2013

    Analytics for Twitter 2013 (version 1.2) is now available for download at http://extendedresults.com/products/twitteranalytics/ This version has been enhanced to utilize twitter's version 1.1 api for downloading user profile images and was built for Office 2013 with PowerView. As a reminder...
    on17 Jul 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...
    on2 Jul 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 ...
    on2 Jul 2013

  • Wiki Page: PowerPivot Glossary

    Microsoft SQL Server PowerPivot provides features that span many technology areas, from relational databases, to analytics, to Web publishing. This article provides definitions for some PowerPivot terms and provides links to related content in the TechNet Library. Add words and tweak the definitions...
    on25 Jun 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: Understanding Multidimensional Model Objects in Power View

    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 subject to change in future releases...
    on19 Jun 2013
Page 1 of 4 (98 items) 1234
Can't find it? Write it!

Post an Article