Ben Zenick was interviewed during SAS Global Forum 2009 on his Government Section Keynote, "Doing More with Less."  Click here to view on SAS SGF blog.

Click here to view and/or download the SGF 2009 presentation.

ABSTRACT

This paper will address the use of MDX to develop custom calculations in OLAP that aren’t easy to implement or apply in reports based on standard tables. Have you ever attempted to apply if/else logic directly into an OLAP cube that will allow the engine to make certain decisions? Have you had difficulty applying Advanced Time Period Manipulation in an OLAP structure; like Year to Date or Rolling Year to Dates? Can you apply different calculations to a measure based on a certain level in a hierarchy? How can you deliver Non-Additive calculations in OLAP? This paper will address these questions as well as the following information custom options for cube building, using external aggregation tables, advanced MDX topics, and Cube display options.

ABSTRACT

The face of the nation is changing today more than ever. This change is requiring government organizations to “tighten the belt” even more than they have in the past while maintaining or increasing the level of service to their constituents. In a time where the government work force is aging, talent is difficult to retain, budgets are smaller, and organizations are asked to address a variety of additional issues; more than ever, government is being forced to “Do More with Less.”