After I created a cube in BI Studio, I added more data to the fact table, modified dimension table, and refreshed DSV. I got Refresh Data Source View message ‘No changes have been found’, but I didn’t see the data that I just added in from cube browser.
(Database connecting and database structure didn’t change)
My questions:
- Is refresh DSV only for database structure change?
- Which step I was missing for refreshing cube data?
Thanks in advance.
Yes, refreshing is to pull database structure changes into the DSV. To get the new data, "Process" the cube.
You'll find that MSAS provides a rich set of capabilities and abilities to update the data. For now, always do a "Full Process", until you get more comfortable with the technology. Depending on the size of your cube, plan on spending a little time learning about incremental processing and partitions. For anything other than small cubes, expect to define / manage partitions are part of the definitions. The impact on performance is dramatic.
|||Thank you very much Dave.It is very helpful information.
No comments:
Post a Comment