locked
Making buckets in SSAS? Possible? RRS feed

  • Question

  • Hello,

     

    Is it possible to make buckets in SSAS? If yes, could you explain how to do it.

     

    Thanks!

    Friday, April 25, 2008 1:40 PM

All replies

  • You can make buckets by discretizing an attribute of your dimension :

     

    When you explore your dimension structure, you can see the properties of any attribute. Then you have to configure the DiscretizationBucketCount and the DiscretizationMethod fields for the attribute you want to discretize.

     

    You can find a description of differents discretization methods here :

    http://msdn2.microsoft.com/en-us/library/ms174512.aspx

     

    Hope this helps

    Friday, April 25, 2008 2:02 PM