Zencos is featured in SAS video for North Carolina Dept. of Commerce EDIS project. The project was recognized as one of InfoWorld 100 awards celebrating IT projects that use technology in smart, innovative, creative ways to meet business and technical objectives Click here to view on NC Dept. of Commerce Site.

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.