Microsoft Dynamics Axapta Technical,Functional Coverage

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.

Get current user id str s;   ;   s = curuserid();   print "Current user ID is " + s;   pause; Field id to field Name str name;   tableid _tableId;   fieldid _fieldid;   ;   _tableId = tablename2id("Address");   _fieldId = fieldname2id(_tableId, "Name");   name = fieldid2pname(_tableId, _fieldid);   print name;   pause; To get next month of given date   date d;       ;       d = nextmth(today()); //For example, NextMth(29\02\1996) returns the date '29\03\1996', but NextMth(31\01\1996) returns the date '29\02\1996' (leap year).       print "Next month is " + date2str(d, 2, 2, -1, 2, -1, 4);        pause; To delete string from string str s;   ;   s = strdel("TESTstring", 5, 6);   print s;   pause; Find string using strfind int i;   ;   i = strnfind("test", "s", 3, 4);   print "i = " + int2str(i); scan string from string using strscan int i;   ;   i

Round function use to rounding the real or decimal values . Rounds off the decimal figure specified by arg to the nearest multiple of the decimal figure specified by decimals. example of round function Round(124.45,5.00) returns the value '126.00'. Round(7.55,1.05) returns the value '7.45'.

OuterJoin Selects records from the main table whether they have matching records in the joined table. Each match returns a result set of the main table record and joined table record joined together as one record. If there is no match, the fields from the joined table will be empty. ExistsJoin Selects a record from the main table only if there is a matching record in the joined table. As soon as a matching record is found, the main table record is returned. The record in the joined table is never retrieved. NotExistsJoin Select records from the main table that do not have a match in the joined table. Passive The query on the joined data source is only executed when the form is opened. A later change in the controlling data source does not change the view. Delayed The query on the joined data source is executed every time that the controlling data source is changed.The query execution is delayed to avoid the fetch of data, if the controlling data source is changed multiple

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.

1. Open Internet Explorer. 2. Enter the URL of the ReportServer virtual directory: If SSL is used the use the following URL. https://ServerName:PortNumber/reportserver(https://ServerName:Po rtNumber/reportserver). If SSL is not used then use the following URL. http://ServerName:PortNumber/reportserver(http://ServerName:Port Number/reportserver). 3. Enter the URL of the Reports virtual directory: If SSL is used the use the following URL. https://ServerName:PortNumber/reports(https://ServerName:PortNu mber/reports). If SSL is not used then use the following URL. http://ServerName:PortNumber/reports(http://ServerName:PortNum ber/reports).