Sign in
 

none
SSAS INDEX

 > 

    Question

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hello,

    What is Index in SSAS Cube? Are these index degrade the cube processing ? How these index work in cube ?

    Regards,

    Sanjeewan


    blog:My Blog/

    Hope this will help you !!!
    Sanjeewan


    Thursday, December 19, 2013 3:47 PM
    |

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Sanjeewan,

    When we talk of processing a cube, there are two parts to it, processing data which rebuilds dimensions with attribute store, hierarchy store and fact data store and processing indexes which creates bitmap indexes and defined aggregation.

    ProcessIndexes - Applies to dimension, cube, measure group, and partition. It requires that the object must already have its "data" built; otherwise, it raises an error. ProcessIndexes preserves the data and rebuilds the "indexes". For dimensions, it builds the bitmap indexes. For partitions, it builds the aggregation data and bitmap indexes. ProcessIndexes is recursively applied to all descendants of the object as well. 

    Reference:
    Different Kinds of SSAS Processing
    Bitmap index

    Regards,

    Charlie Liao
    TechNet Community Support

    Friday, December 20, 2013 5:38 AM
    |
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Any expert commen please


    blog:My Blog/

    Hope this will help you !!!
    Sanjeewan

    Friday, December 20, 2013 5:36 AM
    |
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Sanjeewan,

    When we talk of processing a cube, there are two parts to it, processing data which rebuilds dimensions with attribute store, hierarchy store and fact data store and processing indexes which creates bitmap indexes and defined aggregation.

    ProcessIndexes - Applies to dimension, cube, measure group, and partition. It requires that the object must already have its "data" built; otherwise, it raises an error. ProcessIndexes preserves the data and rebuilds the "indexes". For dimensions, it builds the bitmap indexes. For partitions, it builds the aggregation data and bitmap indexes. ProcessIndexes is recursively applied to all descendants of the object as well. 

    Reference:
    Different Kinds of SSAS Processing
    Bitmap index

    Regards,

    Charlie Liao
    TechNet Community Support

    Friday, December 20, 2013 5:38 AM
    |
    Moderator