Post reply

drill Up,drill Down in ssas

  • August 3, 2011 at 1:07 am

    #255151

    Please explain how to use drill up,drill down and roll up operations in ssas with examples

  • August 4, 2011 at 4:20 am

    #1363523

    Drill up and down refers simply to clicking the plus signs on dimension items that open up to more detail. For example, by clicking on the plus sign by 2011, you open it up to the 4 Qtrs. If you click on the plus sign by one of the quarters, you open it up to the months.

    This differs from drill through, which allows a user to see the rows that make up a data point. If you google "SSAS drill through", you will get instructions on what to do.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply