SQL Server Performance

ROLAP Setting

Discussion in 'SQL Server 2005 Analysis Services' started by Manoj118, Apr 11, 2008.

  1. Manoj118 New Member

    Hi
    I am new to AS 05 . I want to create a cube with Storage Option as ROLAP so that i can get latest information from my cube. My cube has only one fact table made from view(which used three to four tables) and only one measure. I tried to create by rolap cube as storage option but data is not getting refreshed. whenever i have to see latest data i have to rebuild the cube . Plse help to use correct option so that i can get real time data.
    Manoj

  2. ranjitjain New Member

    HI,
    Read about storage option in Analysis server in more detail from BOL. If you are dealing with 2005, then read about Automatic MOLAP which will give you better performance and even the cube gets refreshed whenever fact data is changed.
  3. satya Moderator

Share This Page