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
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.
SQL Server 2005 Analysis Services Operations Guide What is Business Intelligence? How to obtain complete tools suite to test? SQL Server OLAP - back to basics for Cube access from front-end application? The above blog links should get you information requried.
