What is the use of process option in Analysis service Database,Cube,Dimension seperately?If we process database alone,it will process the cube and dimensions inside of that right?
Yes, processing the database will process the cube and dimensions. If it is working well for you, you should continue. You can process the other objects independently for a variety of reasons. Sometimes you want to only process an update for a dimension which does not require a cube process. Or you want to control processing in a specific order if your server can't handle processing in parallel. Maybe you only want to process one cube in a database rather than all cubes in a database, or maybe you want to process a single partition in a cube rather than the entire cube. These other options are there so that you can decide precisely what to process, whether it is a complete process or an update/add/incremental process, and sequencing of processing so that you can manage your hardware resources appropriately.