Data Otaku

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

Posts
  • Data Otaku

    Test

    • 0 Comments
    Test
  • Data Otaku

    Provision an HDInsight Cluster with Tez as Default Hive Execution Engine

    • 0 Comments
    There is a lot you can do with Hadoop but I primarily use it to store data I want to loosely explore. This means that I focus on working with data via Hive and the easiest way for me to bring up a cluster for this kind of work is to fire up Azure HDInsight...
  • Data Otaku

    Presenting Actuals and Forecast Concurrently in a Write-Enabled Cube

    • 0 Comments
    I have written a series of entries on writeback applications and wanted to add this last entry highlighting a common cube design challenge associated with these. Quite often with write enabled cubes, we enter forecasted data for future periods. When those...
  • Data Otaku

    UPDATED: Getting the Timeline Filter (Slicer) in Excel 2013 to Work with an Analysis Services OLAP Cube

    • 0 Comments
    In Excel 2013, there is a new Timeline filter (slicer) that allows you to easily select a range of dates over which you want to filter your data. The feature is very slick. Here's an picture: I wanted to use this slicer in an Analysis Services demo...
  • Data Otaku

    Writeback Application Code Samples

    • 1 Comments
    In order to help folks get started with writeback applications, I'm posting here an Analysis Services database, it's associated data source, and three sample Excel applications demonstrating different forms of writeback. By downloading these, you assume...
  • Data Otaku

    Managing Writeback Cubes

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services . In presenting on the topic of writeback applications with Analysis Services, there are a few administrative questions that seem to come...
  • Data Otaku

    Writeback to a Regular Dimension

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services . In the post on writeback to a parent-child dimension , writeback was implemented using the ALTER CUBE MDX statement. If you attempt to...
  • Data Otaku

    Writeback to a Parent-Child Dimension

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services . Writeback to a parent-child dimension is handled using the ALTER CUBE MDX statement. This statement identifies the cube along with the...
  • 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

    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

    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

    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...
  • 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

    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 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

    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

    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

    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

    Creating Your First FileTable in SQL Server Denali CTP3

    • 4 Comments
    With SQL Server Denali CTP3 now available , I'm starting to explore some of the new Database Engine capabilities. One that caught my attention is the FileTable . The FileTable builds upon FileStream storage which allows BLOB data to be stored as individual...
  • Data Otaku

    Virtualizing the SharePoint 2010 Database-Tier

    • 0 Comments
    Over the last few months, I’ve had a number of conversations with customers regarding the virtualization of SQL Server for the database-tier of SharePoint Server 2010 deployments. Historically, administrators have been hesitant to virtualize SQL...
  • Data Otaku

    Securing the Data Warehouse

    • 1 Comments
    After completing a series of posts on Building Secure Database Applications , the question of how the practices and features highlighted apply to data warehouses arose. In a traditional database application, the database is a behind-the-scenes element...
  • Data Otaku

    Regulate Network Connectivity

    • 2 Comments
    SQL Server accepts client connections over specific network protocols and (for lack of a better term) associated channels. The combination of network protocol, a channel, and the type of communication taking place over it is managed from within SQL Server...
  • Data Otaku

    Monitor & Enforce Security Policies

    • 0 Comments
    Once a security policy is defined, it then needs to be monitored and enforced to ensure compliance. SQL Server provides two features for this: policy-based management and audit. Policy-Based Management Introduced with SQL Server 2008, policy-based...
  • Data Otaku

    SQL Injection Demo

    • 0 Comments
    The purpose of this post is to demonstrate a simple SQL injection attack. For information on securing a database against SQL injection, please review this post . NOTE Implementing an actual SQL injection attack against a system for which you have not...
Page 1 of 2 (38 items) 12