Tuesday, April 24, 2012

Service Tax Hotfix for INDIA localization (KB2554055)


Service tax patch affects only GLP and SYP layer.
When we run the axupdate.exe, it asks for a configuration file.
Then it auto run itself.
Even if it is successfully installed,
It always skips to import the following few classes:
  1.       InventCostInputAmount
  2.       InventLedgerConflictMessage
  3.       InventLedgerConflictMessageTest
  4.       BlackListTransfer_IT

Then we need to go to the extracted files of that patch and find the XPOs related to GLP and SYP layer.
From these XPOs Select only the above selected classes and Import them.
You may find few errors related to the following classes:
  1.          InventUpd_Physical
  2.           InventQuarantineUpdStartUp
  3.           InventMovement

Error may say that InventUpd_Physical is not a class.
Double click that error and locate the Class.
You will find that there are some changes in the class in usr layer.
Just export and import the class.
It will solve all the related errors too.
In addition to these above classes you may get errors in following classes too:
  1.        TaxSalesQuotation
  2.        TaxSales

Similarly here also you need to just export and import the Tax Sales class to resolve the related errors.
Hope it helps!!!

Monday, April 23, 2012

Re Indexing of Database by Scheduling


Open studio management >> Go to Maintenace Plans Right click and select “Maintenance Plan Wizard”





    Enter the name and description of reindexing process 


   Select Rebuild Index option



   Select the database name on which you have to run Indexing process








   Select newly created maintenance plan , right click it and select “Modify” option

   
    Select the scheduling option which is having calendar symbol you will get following window


   You can Disable/Enable the reindixing  Job from Jobs node in SQL Server Agent.





Monday, April 16, 2012

Go To Main Table on Custom Field On Form

While customizing some of the forms in Dynamics Ax 2009 i come across to create a "Go To Main Table" functionality on the custom field placed on the form.
To Execute this i used following code at the design part (field>> methods>>jumpref method)

Code :


public void jumpRef()
{
    Args        args;
    FormRun     fr;
    ;

    args = new Args(formstr(SheCRTermMaster)); //TableName
    args.lookupField(fieldNum(SheCRTermMaster, TermID)); //Fields of Table
    args.lookupField(fieldNum(SheCRTermMaster, Description));
    args.lookupValue(this.text()); //Optional

    fr = ClassFactory.FormRunClass(args);
    fr.init();
    fr.run();
    fr.detach();
}

Saturday, April 14, 2012

Management Reporter for Microsoft Dynamics ERP known issues



Management Reporter 2012 for Microsoft Dynamics ERP
486022 - DataMart provider does not calculate the Begining Balance correctly with BB Row Modifier
488159 - Designer crashes when you click some building block groups window buttons when application service is not available
488281 - Missing Account Analysis - Tree with @ANY does not show missing values
485632 - Missing Account Analysis - switching all (no filter) to single value after manual refresh can crash
485641 - Missing Account Analysis may crash after switching building block group
488213 - Designer crashes when user opens a report definition set to a company that the user does not have access to
488299 - MR role is incorrect after integration if the AX user has multiple roles that have different MR permissions
488201 - AX 2009 attribute filtering is not working for financial and account level for account category
488300 - Viewer crashes when you try to edit charts or comments deleted by another user
488193 - Entering incorrect logon information when you configure SL provider causes Configuration Console to crash
487079 - Entering incorrect logon information when you configure AX 2012 provider causes Configuration Console to crash
488146 - Attribute selection on Account Type or Account Category returns no data for Account when Account has no matching type/category
471771 - Double-Line together with other line formats can cause layout issues with other elements in the report
484633 - MR with Dynamics GP AA may miss data if multiple currenies are used
475203 - Dynamics GP AA report fails when AA budget and only AA dimensions are used
488364, 488370, 488371, 488286 - Dynamics AX user integration and multiple AOSs
484670 - Unchecking “Display reports with no active rows” option in Management Reporter does not suppress the printing of reporting units
484025 - IF THEN ELSE calculations do not work when specifying a result column in the THEN part of the calculation
485552 - Font color is ignored with Rolling Forecast Headers
482066 - Unable to use X:BASE for defining periods


Management Reporter for Microsoft Dynamics ERP 2.0.1700.66 (SP2 Update)
484938 - MR Performance with Dynamics AX decreases with the use of Trees.

Management Reporter for Microsoft Dynamics ERP 2.0.1700.31 (SP2)  Microsoft Forecaster Data Transfer Tool 2.0.0.0
476528 - Forecaster Data Transfer Tool throws incorrect syntax error when a database exists with a hypen character.
483850 - The Generate Report button hangs (unresponsive) when report has multiple rows.
482131 - The company calendar couldn't be retrieved from Dynamics AX 2009 when multiple years have closing periods in the same year.
484501 - Unable to run reports for companies other than the default company for Dynamics AX 2009.
483621 - Unposted data will show incorrectly with Dynamics GP for YTD columns
484631 - Wildcards in ranges return incorrect data for Dynamics AX 2012.
484460 - Unable to load the calendar in Dyanmics AX 2012 if more than one period is in the same month.
480002 - Some attribute filters with transaction detail return zero for totals with Dynamics AX.
483478 - When using CPO in a "Financial Dimension + Worksheet" link the CPO will only return results for the first column.
475151 - Error logging into a company when an AA dimension has the same name as an account segment in Dynamics GP.
472368 - Error logging into a company when a User Defined field has the same name as an account segment in Dynamics GP.
470555 - When you run the Migration Wizard in Validate Only mode, cached credentials prevent validation.
470284 - Explicit dimensions are not written to the XBRL instance document.
470005 - The Designer must be restarted for style changes to take effect.
427786 - XBRL notes and footnotes are not written to the XBRL instance document.


 

Microsoft Forecaster Data Transfer Tool 2.0.0.0
476528 - Forecaster Data Transfer Tool throws incorrect syntax error when a database exists with a hypen character.

Thursday, April 12, 2012

Management Reporter Errors and Resolutions


JUST FIND YOUR ERROR BELOW.......

Symptoms :

When you start Microsoft Management Reporter (MR) you receive one of the following error messages: "A connection to the server could not be established.  Check the server address and try again or contact your system administrator." or "Can't connect to the Management Reporter server.  Do you want to specify a different server address?"
To troubleshoot Management Reporter connection problems you need to click OK to this message and then click Test Connection to get an additional error message.  You also need to go to Event Viewer to get additional information on the error.  In Event Viewer click Windows Logs and then click Application.  Under the Source column look for Management Reporter Report Designer or Management Reporter Services.
Here is a list of errors received when you click Test Connection and the possible associated error(s) seen in Event Viewer.  Find your error in the list and use the appropriate Cause\Resolution sections.
  • "Connection attempt failed.  There is a version mismatch between the client and the server.  Contact your system administrator."

      • See Cause 1
  • "Connection attempt failed.  Server is unable to connect to the database.  Contact your system administrator." If you check the Event Viewer, you may find the following error messages:
    • Message: Microsoft.Dynamics.Performance.Common.ReportingDatabaseConnectivityException: Database user lacks sufficient permission to run this application. ---> System.Da Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'pGetSchemaVersion', database 'ManagementReporter', schema 'dbo'.
    • Message: Microsoft.Dynamics.Performance.Common.ReportingDatabaseConnectivityException: Database user lacks sufficient permission to run this application. ---> System.Da Data.SqlClient.SqlException: The SELECT permission was denied on the object 'SecurityPrincipal', database 'ManagementReporter', schema 'dbo'.
      • See Cause 2
  • "The version of the database is incorrect.  Install the correct version of the database."
      • See Cause 2
      • See Cause 13
  • "Connection attempt failed.  User does not have appropriate permissions to connect to the server.  Contact your system administrator."
      • See Cause 3
  • "A connection to the server could not be established.  Check the server address and try again or contact your system administrator."
Note Servername is a placeholder for your actual server name and 4712 is a placeholder for the actual port selected during the MR install. 
If you check the Event Viewer, you may find the following error messages:
    • Message: System.ServiceModel.ServerTooBusyException: The HTTP service located at http://servername:4712/InformationService.svc is too busy. ---> System.Net.WebException: The remote server returned an error: (503) Server Unavailable
      • See Cause 4
    • Message: System.ServiceModel.Security.SecurityNegotiationException: SOAP security negotiation with 'http://servername:4712/SecurityService.svc' for target 'http://servername:4712/SecurityService.svc' failed. See inner exception for more details. ---> System.ComponentModel.Win32Exception: The Security Support Provider Interface (SSPI) negotiation failed.
      • See Cause 5
      • See Cause 12
      • See Cause 13
      • See Cause 17
    • Message: System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://servername:4712/InformationService.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it
      • See Cause 6
    • Message: System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://servername:4712/InformationService.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
      • See Cause 10
    • Message: System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://servername:4712/InformationService.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---> System.Net.WebException: The remote server returned an error: (404) Not Found
      • See Cause 13
    • Message: System.ServiceModel.EndpointNotFoundException: Could not connect to http://servername:4712/InformationService.svc.  TCP error code 10061: No connection could be made because the target machine actively refused it
      • See Cause 6
    • Message: System.ServiceModel.ProtocolException: The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (text/xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly.
      • If the error also included "Detailed Error - 500.24 - Internal Server Error"
        • See Cause 7
      • If the error also included "Detailed Error - 500.19 - Internal Server Error"
        • See Cause 8
      • If Event Viewer also includes a Warning about ASP.NET saying "A configuration error has occurred."
        • See Cause 15
    • Message: System.ServiceModel.Security.MessageSecurityException: The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was ''. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized.
      • See Cause 8
    • Message: System.ServiceModel.Security.MessageSecurityException: An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail. ---> System.ServiceModel.FaultException: An error occurred when verifying security for the message.
      • See Cause 9
    • Message: System.TimeoutException: The request channel timed out attempting to send after 00:00:40. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout. ---> System.TimeoutException: The HTTP request to 'http://servername:4712/InformationService.svc' has exceeded the allotted timeout of 00:00:39.9660000. The time allotted to this operation may have been a portion of a longer timeout. ---> System.Net.WebException: The operation has timed out
      • See Cause 10
    • Message: System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
      • See Cause 11
    • Message: System.ServiceModel.Security.SecurityNegotiationException: The caller was not authenticated by the service. ---> System.ServiceModel.FaultException: The request for security token could not be satisfied because authentication failed.
      • See Cause 12
    • Message: System.ServiceModel.ProtocolException: The remote server returned an unexpected response: (405) Method Not Allowed. ---> System.Net.WebException: The remote returned an error: (405) Method Not Allowed.
      • See Cause 14
    • ISAPI Filter 'C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_filter.dll' could not be loaded due to a configuration problem. The current configuration only supports loading images built for a AMD64 processor architecture. The data field contains the error number. To learn more about this issue, including how to troubleshooting this kind of processor architecture mismatch error, see http://go.microsoft.com/fwlink/?LinkId=29349.
      • See Cause 16

    • Message: Microsoft.Dynamics.Performance.Common.ReportingServerNotFoundException: The server could not be found. Make sure the server address is correct.
      • See Cause 10
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Cause :

Cause 1
The Management Reporter Client installed is a different version than the MR Server.  See Resolution 1 in the "Resolution" section.
Cause 2
The Identity user of the Management Reporter Application Pool does not have the GeneralUser and public roles to the Management Reporter SQL Server database.  See Resolution 2 in the "Resolution" section.
Cause 3
The user trying to run MR has not been setup as a user in MR and therefore cannot connect.  See Resolution 3 in the "Resolution" section.
Cause 4
The Management Reporter Application Pool is not running. See Resolution 4 in the "Resolution" section.
Cause 5
The computer is not connected to the domain where Management Reporter is installed.  See Resolution 5 in the "Resolution" section.
Cause 6
The Management Reporter Web Site is not running.  See Resolution 6 in the "Resolution" section.
Cause 7
The Management Reporter Web Site has ASP.NET Impersonation enabled.  See Resolution 7 in the “Resolution” section.
Cause 8
The Anonymous User of the Management Reporter Site in IIS does not have access to the Management Reporter install folder (by default this will be: C:\Program Files\Microsoft Dynamics ERP\Management Reporter).  See Resolution 8 in the “Resolution” section.
Cause 9
The time on the client and server are more than five minutes different (differences in time zones are permitted).  See Resolution 9 in the "Resolution" section.
Cause 10
The port used during the MR installation is not set up as an exclusion within the Firewall software.  See Resolution 10 in the "Resolution section.
Cause 11
The Encrypt connection option was selected during the install but SSL was not configured.  See Resolution 11 in the "Resolution" section.
Cause 12
The computer is having problems communicating or authenticating with the domain.  See Resolution 12 in the "Resolution" section.
Cause 13
ASP.NET is not allowed in IIS.  See Resolution 13 in the "Resolution" section.
Cause 14
WCF HTTP Activation is not installed on the MR Server.  See Resolution 14 in the "Resolution" section.
Cause 15
Version conflicts between WCF and .NET.  See Resolution 15 in the "Resolution" section.
Cause 16
ISAPI filter being used is 32-bit but the Operating System is 64-bit.  See Resolution 16 in the "Resolution" section.
Cause 17
MR Services are being run as a Domain user and WCF Authentication is failing when using the UPN (User Principal Name). See Resolution 17 in the "Resolution" section.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Resolution :
Resolution 1
Check the Management Reporter Client install on the workstation and also check the Management Reporter Server install on the server.  To check the version in Management Reporter, click Help, and then click About Management Reporter. The MR Client install needs to be the same version as the MR Server install.
Resolution 2
Check the Identity user is Internet Information Services Manager:
  • In IIS 7:
    • Expand the server name and then click Application Pools.
    • Make a note of the user in the Identity column for the Management Reporter Application Pool.
  • In IIS 6:
    • Expand the server name and then expand Application Pools.
    • Right-click Management Reporter and click Properties.
    • Click the Identity tab and make a note of the user.
Change the Identity user's permissions in SQL.
  • Open Microsoft SQL Server Management Studio.
  • Expand the Security folder and then expand Logins.
  • Right-click the user that was listed as the Identity user and select Properties.
  • Click User Mapping and select the Management Reporter database.
  • In the Database role membership section, mark GeneralUser and public.
  • Click OK.
Resolution 3
Setup the user receiveing the connection error within MR.
  • Run MR as a user that is setup as an MR administrator.
  • In MR click Go and then click Security.
  • Add the user who is receiving the connection error.
Note If it is not known what user(s) exist in MR you can run 'select * from SecurityUser' against the ManagementReporter database to find out.
Resolution 4
Start the Management Reporter Application Pool.
  • In IIS 7
    • Expand the server name and then click Application Pools.
    • Check the Status of the Management Reporter Application Pool.
    • If it is not started, right-click the Management Reporter application pool and then click Start.
  • In IIS 6
    • Expand the server name and then expand Application Pools.
    • Click Management Reporter and verify that it is started.
    • If it is not started, right-click the Management Reporter application pool and then click Start.
Note Once these steps are completed and you get the same error, repeat these steps to check the Application Pool.  If it is stopped, the password of the Identity account is incorrect and needs to be reset.
Resolution 5
Management Reporter will only function while connected to the domain used during the install. Even if all MR server components are on one computer, that computer still needs to be connected to the domain you were using when you installed MR.
Note  This means that Management Reporter will not work when demonstration laptops are not physically connected to the domain or not connected using a VPN connection.
Resolution 6
Start the Management Reporter Web Site.
  • In IIS 7
    • Expand the server name and then expand Sites.
    • Right-click the Management Reporter Site, point to Manage Web Site and then click Start.
  • In IIS 6
    • Expand the server name and then expand Web Sites.
    • Right-click the Management Reporter Site (or Default Web Site) and then click Start.
Resolution 7
Disable ASP.NET Impersonation.
Note This only applies to IIS 7.
  • In IIS 7, expand the server name and then expand Sites.
  • Click the Management Reporter Site and then double-click Authentication under the IIS category.
  • Right-click ASP.NET Impersonation and then click Disable.
Resolution 8
Give the Anonymous User permissions to the Management Reporter install folder.

  • In IIS 7
    • Expand the server name and then expand Sites.
    • Click the Mangement Reporter Site and then double-click Authentication under the IIS category.
    • Right-click Anonymous Authentication and then click Edit.
    • Make note of the user.
  • In IIS 6
    • Expand the server name and then expand Web Sites.
    • Right-click the Management Reporter Site and then click Properties.
    • Click the Directory Security tab and then click Edit.
    • Make note of the anonymous user.
  • In Windows Explorer on the MR Server.
    • Go to the folder where MR is installed (by default this path is: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.0).
    • Right-click the Application Services folder and then click Properties.
    • Click the Security tab and make sure the anonymous user has at least Modify permissions. 
Resolution 9
Verify the time on the client and server. Change the time that is incorrect. The time must be within five minutes of each other.
Resolution 10
Setup an exception in your Firewall program. Steps will vary depending on the Firewall program used but here are high level steps.
  • Click Start and then click Run.  Type WF.MSC and then press Enter.
  • Click Inbound Rules.
  • Click New Rule.
  • Click Port and then click Next.
  • Click Specific local ports and then type 4712. If you are not using the default port of 4712, you will need to type that here. Click Next.
  • Click Allow the connection and then click Next.
  • Select Domain, Private, and Public.  Click Next.
  • Type Management Reporter as the Name and then click Finish.
Resolution 11
The MR Install Guide has the following information regarding the encrypt connection option:
You must configure SSL on the server and install certificates before you can use this option. For more information about encryption in Microsoft SQL Server, see the SQL Server documentation on MSDN (http://msdn.microsoft.com/en-us/library/ms189067.aspx).
You could also modify the config files to turn Encryption off (make a backup copy of the files before you modify them).
  • In Windows Explorer, go to the MR install folder (the default install is: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.0)
    • In the Application Service folder find the web.config file and right-click the file to open it in Notepad.
    • Locate the <connectionstrings> and change the setting Encrypt= from True to False.
    • Save the changes.
    • In the Process Service folder find the MRProcessService.exe.config file and right-click the file to open it in Notepad.
    • Locate the <connectionstrings> and change the setting Encrypt= from True to False.
    • Save the changes.
Resolution 12
Remove the computer from the domain and then add it back to the domain.  Warning A local administrator account will need to be used to logon to the computer one time after it is removed from the domain.
  • Click Start, click Run and type: sysdm.cpl to open System Properties.
  • Click Change and make a note of the Domain name.
  • Click Workgroup, type a name (i.e. workgroup), click OK to accept changes and then restart the computer.
  • After restarting, click Start, click Run and type: sysdm.cpl to open System Properties.
  • Click Change and then click Domain.
  • Enter the domain noted above, click OK to accept changes and then restart the computer.
Resolution 13
In IIS set ASP.NET to Allowed:
  • In IIS 7
    • Click the server name and then double-click ISAPI and CGI Restrictions under the IIS category.
    • Right-click ASP.NET vX.XX and then click Allow.
  • In IIS 6
    • Expand the server name and then click Web Service Extensions.
    • Click ASP.NET vX.XX and then click Allow.  
Note Where vX.XX is a placeholder for the actual ASP.NET version. Beginning with MR V2 SP1 (2.0.1663.3) the version of ASP.NET used with MR is v4.0.30319.
Resolution 14
Install WCF HTTP Activation.
  • In Windows Server 2008, open Server Manager and then click Features.
  • Click Add Features and then expand .NET Framework.
  • Expand WCF Activation and then mark HTTP Activation.
  • Click Next and then click Install.
Resolution 15
For IIS 7.0:
Register ASP.NET.
  • Click Start, point to Programs, and then click Accessories.
  • Right-click Command Prompt and then click Run as administrator.
  • Browse to the appropriate directory:
    • 32-bit systems: %SystemRoot%\Microsoft.NET\Framework\v4.0.30319
    • 64-bit systems: %SystemRoot%\Microsoft.NET\Framework64\v4.0.30319
  • In the command prompt, type: aspnet_regiis.exe -iru
Note On a 64-bit system that has the 64-bit .Net v4.0.30319 Framework registered, you will need to set the Enable 32-bit Applications property to False on the Management Reporter Application Pool in IIS Manager.

For IIS 6.0:
Note IIS 6.0 does not support running both 32-bit and 64-bit modes at the same time.
Register ASP.NET:

  • Click Start, point to Programs, and then click Accessories.
  • Right-click Command Prompt and then click Run as administrator.
  • Browse to the appropriate directory:
    • 32-bit systems: %SystemRoot%\Microsoft.NET\Framework\v4.0.30319
    • 64-bit systems: %SystemRoot%\Microsoft.NET\Framework64\v4.0.30319
  • In the command prompt, type: aspnet_regiis.exe -iru
  • Expand the server node and click Web Service Extensions.
  • Set all ASP.NET v4.0.30319 web service extensions to AllowedIf you registered the 64-bit version:
    • Click Start, point to Programs, and then click Accessories.
    • Right-click Command Prompt and then click Run as administrator.
    • Type the following command to enable the 64-bit mode:
      cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 0
After registering ASP.NET you will need to set the Enable32bitAppOnWin64 property to match the version you registered:
If you registered the 32-bit version:

  • Click Start, point to Programs, and then click Accessories.
  • Right-click Command Prompt and then click Run as administrator.
  • Type the following command to enable the 32-bit mode:
    cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1
 Resolution 16
  • Open Internet Information Services (IIS) Manager.
  • Expand the server name, then expand Sites and then click Management Reporter.
  • Double-click ISAPI Filters in the IIS Section.  Then double-click the ASP.NET_4.0.30319.0 line. In the Edit ISAPI Filter window, edit the Executable box so that is is C:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_filter.dll 
  • Click OK and then restart the Management Reporter website.  To do this, click Management Reporter and then click Restart
  Resolution 17
Create an SPN on the IIS machine for the domain account running the MR Service.  To create an SPN for this domain account, run the Setspn tool at a command prompt on the IIS server with the following commands:

setspn -A HTTP/webservername domain\customAccountName

setspn -A HTTP/webservername.fullyqualifieddomainname domain\customAccountName
Note
  • "webservername" should be replaced with the IIS server name where the MR Application Service is installed.
  • "webservername.FullyQualifiedDomainName" should be replaced with the fully qualified domain name of the IIS server where the MR Application Service is installed.
  • "domain\customAccountName" should be replaced with the domain account running the MR Services.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
More Information :

Some of the changes above may require IIS be restarted so be sure that IIS is restarted as needed.
If you still receive error messages after making changes contact Microsoft Management Reporter support with the errors including details from Event Viewer.
Click Start, point Administrative Tools, and then click Internet Information Services (IIS) Manager. 


You may also refer the following website.
http://support.microsoft.com/kb/2406829

Installing the Management Reporter Server

One of the significant enhancements to Management Reporter is support for a multi-tiered architecture.  In Management Reporter, the client, server, and database can all reside on separate physical machines.  The Management Reporter server is comprised of two components: the application service and the process service.  The application service handles authentication and access to data within Management Reporter, whereas the process service generates reports which are created and queued by the Management Reporter clients.

The following post will provide a walkthrough of installing and configuring the Management Reporter server.  With my configuration, I ended up with 12 steps total.  Depending on the options selected during install, you may have more or less.

Step 1 License Terms

Pretty straightforward here....you must agree to the license terms.

 

Step 2 Customize Installation

You can select to install just the application service, just the process service, or both services simultaneously.  If the application service is selected, you will also have the option of installing the Management Reporter database.

 

Step 3 Configure Service Account

You must specify the account under which the services will run.  In my example, I simply used my own domain account, although you may prefer to use a different account.  If you enter a specific account, you will have to provide the password for that domain account.







Step 4 Select New or Existing Database

Since I am installing the application service, I must either create a new database or connect to an existing database.  For this example, I will create a new database.




Step 5 Create Database

If you decide to create the database, you will have to specify the database server and authentication method to be used to create the database.




Step 6 Configure Database Master Key
The installation will require you to enter a password which will be used to encrypt sensitive data in the SQL Server database.  Do not lose or forget this password.



Step 7 Configure Database Connection
The next step configures how the Mangement Reporter services will access the Management Reporter database.



Step 8 Specify Management Reporter Administrator
During the install, one administrator user will be created for Management Reporter.  Specify the user who will be the first administrator.  This user will then be able to add additional users after the application installed.

Step 9 Configure Application Service
The application service runs within IIS, therefore it needs to be configured to use a port number.  The default port is 4712.  To change this, enter a different port number.  The Management Reporter installation can optionally open the firewall for this port.


Step 10 Ready to Install
Once all of the steps have been completed, click "Install".



Step 11 Installing Management Reporter
The installation will communicate progress and may take longer if the database is being installed.




Step 12 Application Service and Process Service are installed
After the server installation completes, you will be able to verify the application service and process service have both been installed.  In the Server Manager, navigate to the sites under IIS and you should be able to find Management Reporter.  Selecting the option titled "Application Pool" will also show a Management Reporter application pool.



In the Services window, there will now be a new service titled "Management Reporter Process Service".

Tuesday, April 10, 2012

Steps To Update Time Dimension in OLAP

  1. Open SQL Server Business Intelligence Development Studio (this is on the start menu under Microsoft SQL Server 2005 and also referred to as BIDS).
Then you will want to select file – open then Analysis Services database. You want to specify the OLAP database.
  1. Once the database opens in solution explorer under dimensions find the time dimension. Right click on the time dimension and select open.
  2. With the time dimension open right click on time and select properties.
  3. In the properties for time in the source field see what value you have. If you have an end date of 12/30/2010 or something before that you should follow these steps.
Change the time dimension to have an end date at some point in the future. In my other case with this issue they set it to 12/31/2012 but you really could pick any time in the future (within reason). You would change this in the properties of the  time dimension. You would expand the source section and change the Calendar  End Date to some future date.
  1. Next we need to check what the time dimension is set to in Dynamics AX. To do this in Dynamics AX go to Administration > Setup > Business analysis > OLAP > Update BI project > Time Dimensions tab. If the end date is set to 2010 then change that to match the end date that you gave the time dimension. Then click ok on this form.
  2. Now you need to update the exchange rates in the BI-Exchange Rates table. To do this go to Administration > Setup > Business analysis > OLAP > Setup Exchange Rates. On this form pick the company that you want to use exchange rates for and click ok. This will create entries in the BI-Exchange rates.
  3. The final step is to go back to BIDS and process the OLAP database.

Monday, April 9, 2012

Ax Question and Answers

Page not found