i am creating one SSAS Cube with Data source and Data source view (database which is in database engine)and retrieving data from Cube using MDX query's/excel and update the cube using SSIS package or proactive caching

It sounds as if you don't yet have a framework. I would suggest that you start with "The Data Warehouse Toolkit" by Ralph Kimball for a good overview. "The Microsoft Data Warehouse Toolkit" would be another good suggestion for a beginning overview.