Skip to main content

Posts

Showing posts with the label cube

Processing Olap Cubes in axapta

Processing Olap Cubes Manually Go to ..All Programs > Microsoft SQL Server 2005 > Click on SQL Server Management studio Connect with Analysis Services 1. Process Full Database Databases > Right click on OLAP Database > Click on Process 2. Process Single cube Databases > Olap database > Cubes > Right click on single cube > Process After click on process, “Process database” window will appear. Set Process Options as Process Full. Click on OK, processing will start. processing Olap Cubes Automatically To process OLAP cube automatically ensure that SQL server agent is started. Go to ..All Programs > Microsoft SQL Server 2005 > Configuration Tools > Click on SQL Server Configuration Manager SQL Server Configuration Manager > SQL Server 2005 Services > Ensure that SQL Server Agent is in Automatic start mode and in Running state. If it is not then right click on service and start it. SQL Server agent will start. Create XMLA query