Microsoft Dynamics Axapta Technical,Functional Coverage

Complete the following procedure to update dimension usage. 1. Click the Dimension Usage tab. Note: Dimension usage between a dimension and a measure group will be removed automatically if the dimension or the measure group has been removed. 2. Modify dimension usage, if necessary. You must modify dimension usage if a dimension was changed in such a way that it affects how a measure group relates to the dimension. For example, if you removed a dimension attribute, you may need to modify the dimension usage. To modify the dimension usage between a dimension and a measure group, do the following: a) Select the field that intersects the dimension and the measure group and click the expansion button located in the field. b) In the Define Relationship window, specify the relationship between the dimension and the measure group. Typical changes may include modifying the relationship to remove columns that do not exist or changing columns that join the dimension to the measur

1. Click the Calculations tab. 2. Review each calculated measure and perform one of the following actions appropriate to your scenario: Modify the calculated measure so that it does not have a dependency on a base measure that was removed. Delete the calculated measure if it can no longer be supported without the base measure that was removed. 3. Review each calculated measure and look for currency conversion queries. Verify that each measure and dimension used in a currency conversion query still exists. Warning: Currency conversion queries are executed at run time. If one of the measures or dimensions used in a currency conversion query has been removed, currency conversion will not be performed. Data will be displayed in the originating currency with no indication given to the user.

Synchronize the OLAP database 1. Open your Microsoft Dynamics AX client (Start > Programs > Microsoft Dynamics AX 2009 > Microsoft Dynamics AX 2009).  2. Open the OLAP Administration form (Administration > Setup > Business analysis > OLAP > OLAP Administration).  3. Click the OLAP servers tab.  4. Enter the name and a description of the server that is running Analysis Services. (This information may be already entered for you.)  5. Select the check box for the OLAP server.  6. Click the OLAP databases tab.  7. In the Database name field, enter Dynamics AX. (This information may be already entered for you.)  By default, the OLAP database that stores the Microsoft Dynamics AX cubes is named Dynamics AX.  8. Select the check box for the OLAP database.  9. Click the Advanced tab.  10. Select the Synchronize OLAP Database with OLTP Schema check box.  11. Select the Enable logging check box. Data will be recorded in a log file. Specify an existin

Update the OLTP database with BI data 1. Open your Microsoft Dynamics AX client (Start > Programs > Microsoft Dynamics AX 2009 > Microsoft Dynamics AX 2009). 2. Open the OLAP Administration form (Administration > Setup > Business analysis > OLAP > OLAP Administration). 3. Click the Advanced tab. 4. Select the Update BI Data check box. 5. Click Update Databases to update the OLTP database with currency conversion information and time dimensions. 6. CONFIGURING THE DEFAULT OLAP CUBES

1. Install Reporting Services 2. Configuring Reporting Services in SQL server Start Report server… Set Service account.. Set report server url … Set Report server database… Set Report manager directrory.. set Execution account (.net business connector account)… 3. Configuring Reporting Services in Dynamics ax Set report server URL properly Create folder for dynamics Validate report server Set Default server. 4. Install reporting extension using setup and run following Report Deployment wizard Path.. Select Reports for deployment Provide olap database connection.. Eg. Data source is Server name and Initial catalog is Olap database name

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

Create a domain account specifically for Analysis Services. The account must: Be a dedicated account (used only for Analysis Services). Have minimal access to network resources. Have read access to the Microsoft Dynamics AX online transaction processing (OLTP) database. After you create the domain account, complete the following procedure to configure Analysis services to run as this account. 1. Open the Services window (Start > Administrative Tools > Services). 2. Right-click the SQL Server Analysis Services (MSSQLSERVER) service and click Properties. 3. In the properties window, click the Log On tab. 4. Select the This account option. 5. Enter the name and password for the domain account that you created. 6. Click OK.

Microsoft SQL Server Analysis Services Select the option to install Analysis Services when running the SQL Server installation wizard. For detailed instructions, see the SQL Serverdocumentation. Microsoft SQL Server client tools Select the option to install the client tools when running the SQL Server installation wizard. For detailed instructions, see the SQL Server documentation. SQL Server Management Studio is installed with the client tools. SQL Server Management Studio is used to administer and process OLAP cubes.

QueryName querySource; OLAPDatasourceRange DSRange; OLAPDatasourceRelation DSRelation; OLAPDatasource datasource; OLAPDatasourceField DSField; Query query; QueryBuildDataSource buildDatasource, parentBuildDataSource; int i,dim, parentIndex; int dsCount; boolean newDim; DictTable dictTable; QueryBuildDataSource ds; QueryBuildRange br; Range _rangeStr; DictTable dictTable1; DictField dictField; ; querySource = 'Bbde'; query = new Query (querySource); dsCount = query.dataSourceCount(); buildDatasource = query.dataSourceNo(1); dictTable = new DictTable(buildDatasource.table()); print dictTable.name(); pause; br = buildDatasource.range(1); dictTable1 = new DictTable(br.table()); dictField = new DictField(br.table(),br.field()); // br.value(strfmt('%1',mkdate(6,6,2008))); _rangeStr = br.toString(); print br; print br.field(); print _rangeStr; pause;