Data Otaku

A seemingly random collection of data- and database-related posts

June, 2012

Posts
  • Data Otaku

    Building a Writeback Application with Analysis Services

    • 3 Comments
    Recently, I delivered a presentation at the 2012 PASS SQL Rally titled Building a Writeback Application with Analysis Services. Based on feedback from that session, I’ve decided to address this topic in my blog, making this information accessible...
  • Data Otaku

    Understanding Allocations

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services . In my previous entries on this topic, I’ve been writing data to the Score measure at the intersection of an individual project and...
  • Data Otaku

    A Simple Demonstration of What-If Analysis

    • 0 Comments
    NOTE This is the second of a series of entries on the topic of Building a Writeback Application with Analysis Services . To demonstrate writeback with Analysis Services, I’ll leverage a simple model built around a project selection process that...
  • Data Otaku

    Introducing Dimension Writeback

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services . Up to this point, we’ve focused exclusively on the update of measures using cell writeback. When we need to insert, update or delete...
  • Data Otaku

    Building a Custom Writeback Application

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services . If you have not read the other posts in this series, you will want to read A Technical Review of the Simple Demonstration before proceeding...
  • Data Otaku

    Building a Write-Enabled Cube

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services . To build a writeback application, you need a write-enabled cube and an application with which to interact with it. I’ll cover the...
  • Data Otaku

    Allocation across a Parent-Child Hierarchy

    • 0 Comments
    NOTE This is part of a series of entries onthe topic of Building Writeback Applications with Analysis Services . A parent-child hierarchy consists of members with which values are associated at various levels. A frequently cited example of such a hierarchy...
  • Data Otaku

    Sidebar: The Other What-If Analysis Options in Excel

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building a Writeback Application with Analysis Services . What-if analysis against Analysis Services is just one form of what-if analysis supported by Excel. Other forms focus on spreadsheet...
  • Data Otaku

    Understanding What-If Analysis

    • 0 Comments
    NOTE This is the first of a series of entries on the topic of Building Writeback Applications with Analysis Services . Business analysts frequently encounter questions focused on the impact of potential change: What if we raised our parts and...
  • Data Otaku

    A Technical Review of the Simple Demonstration

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building a Writeback Application with Analysis Services and makes direct reference to a previous post containing a simple demostration of what-if analysis . In the simple demonstration of writeback...
  • Data Otaku

    Sidebar: The MS IT Pattern for Custom Writeback Applications

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building a Writeback Application with Analysis Services . Writeback to cubes through Excel applications is used extensively within Microsoft to support a number of our internal processes, including...
Page 1 of 1 (11 items)