Thursday 30 June 2011

Microsoft Forecaster 70 Service Pack 4

Microsoft Forecaster 70 Service Pack 4 has been released


Issue Description



193720 No way to remove revenue account from revenue module once data has been associated.


312625 Error displaying capital in detail report when using Allow drilldown to capital detail. 315158 Deleting pay type association from salary grade creates orphaned records


320795 Current users list doesn't work correctly on SQL Server 2005/2008. 321729 The Multi-row tab doesn’t show the lines (rows), if an input set name is longer than 24 characters.


325800 Start Period and End Period can’t be adjusted in HR Master after another field is changed. 344372 Entering capital item into invalid period and deleting causes duplicate/orphan records


362922 Excel Add-in returns no results when the optimization factor is 0. 363919 Single Row Input with 'Suppress Zero Lines on Input' creates difference from Multi-row.


363939 When using Human Resources Annually’ with regular allocations not selected, headcount is not updated for hourly employees. 366414 Reports where lines are the departments show a zero balance


367077 Copy plan wizard for HR Details does not correctly calculate allocation. 368241 System needs to keep deleted employees shaded while changing the “Show Allocation As” option.


368800 Importing HR changes clears existing data in HR master but not in HR input. 370981 Improve CALREV processing performance.


378602 FTE not calculated correctly for employees distributed between multiple departments when specifying different employee options. 381253 Running capital task on input set with historic periods causes results to shift the number of historic periods defined.


383592 When reassigning an employee to a new department, the value in the Increase Period 2 field is not updated in the new department. 390352 Allocation lost when reassigning an employee from two or more departments into one using the reassign window.


403235 Error: “ExpressLink encountered a problem attempting to submit data to Microsoft Forecaster.” This occurs if the user name contains a period. (Ex. Jane.doe) 403641 Decimal values do not appear on the single row tab


404570 Temp tables do not get dropped on SQL Server 2000 when the username is numeric


410614 When prompting for period and using a selection sub-menu in a report, users have to select period twice before the report will display.


415674 If a user defined benefit exceeds 5,000 characters, Forecaster will close unexpectedly when trying to select it. 419972 Enabling Auto-translate causes Forecaster to stop responding when adding employees in HR master.


440395 If many options are created for a user defined benefit, Forecaster may close unexpectedly when trying to select an option in HR input. 453998 The destination account and the contra account can’t be the same when two or more allocations are created and accumulate is used.


465875 When sorting columns in the Multi-row tab, incorrect values can be created if a @LOOKUP calculation is also used. 466855 Enabling Auto-translate causes Forecaster to stop responding when importing employees through HR import.


467705 Forecaster closes unexpectedly. 469946 If an employee from a previous input set salary grade doesn’t exist in a new input set, Forecaster closes expectedly when adding the employee.


470760 Specifying a color for calculated columns doesn’t apply the color. 473830 If Add as FTE is not selected when adding an employee in HR master, Forecaster closes unexpectedly.


Know Issues
Cannot Connect to Server When Using the Microsoft Forecaster Database Creation Wizard with SQL 2008 Server (See KB 962541   http://support.microsoft.com/kb/962541 )

Microsoft Reporter Service Pack 2

Management Reporter for Microsoft Dynamics® with Service Pack 2 provides general performance improvements and enhanced functionality for reporting. In addition, the following areas have been improved:


• Data provider updates for Microsoft Dynamics AX 2009.


• Data provider updates for Microsoft Dynamics GP 2010 and support for Microsoft Dynamics GP 2010 R2.


• Improved support for multiple Active Directory® domains.


• Better support for rounding adjustments and adjustment periods.


• Performance improvements for reports with large numbers of transactions, many calculated rows, and Analytical Accounting.


• Improved error handling in report processing


If you have access to Customer Source you can download this with the following link

https://mbs.microsoft.com/customersource/downloads/servicepacks/msd_managementreporterservicepack2.htm?printpage=false&sid=mwm4nwdaom4ygerwp3k505qp&stext=Management Reporter Service Pack 2

Thursday 23 June 2011

How to Create a Demo Company in Microsoft Management Reporter that Connects to the Fabrikam Company in Microsoft Dynamics GP 2010

How to Create a Demo Company in Microsoft Management Reporter that Connects to the Fabrikam Company in Microsoft Dynamics GP 2010

Describes how to create a sample company in Management Reporter that will connect to the Fabrikam demo company in Microsoft Dynamics Dynamics GP 2010.

See article below
https://mbs.microsoft.com/partnersource/deployment/documentation/howtoarticles/msdygp_mr_createdemocompany.htm?p=187 

How to Create an Application Role in SQL Server 2008 for Forecaster 7.0

How to Create an Application Role in SQL Server 2008 for Forecaster 7.0



By using an application role, users will be unable to log on to a database by using ODBC or another querying tool unless they know the password for the role. This helps prevent unauthorized access to the Forecaster database data. The Microsoft Forecaster 7.0 client will be able to read the application role password and let users log on.


Article can be found below:

https://mbs.microsoft.com/partnersource/deployment/documentation/howtoarticles/msdforecasterapprolesqlserver_howto.htm?p=187

installing sharepoint 2010 privilege service accounts

Great Article about installing SharePoint2010

http://sharepointgeorge.com/2010/installing-sharepoint-2010-privilege-service-accounts

SharePoint 2010 - MissingWebPart

The SharePoint Health Analyser picked up an issue with the configuration of a new SharePoint 2010 installation and found the following two errors:


[MissingWebPart] WebPart class [a7563a72-5661-4571-de0c-b2bc1de8718d] is referenced [4] times in the database [XXXXXX], but is not installed on the current farm. Please install any feature/solution which contains this web part. One or more web parts are referenced in the database [XXXXXX], but are not installed on the current farm. Please install any feature or solution which contains these web parts.


[MissingWebPart] WebPart class [8d6034c4-a416-e535-281a-6b714894e1aa] is referenced [6] times in the database [SharePoint_AdminContent_392c3097-c08f-4865-b5bf-2ce1b95b1269], but is not installed on the current farm. Please install any feature/solution which contains this web part. One or more web parts are referenced in the database [SharePoint_AdminContent_392c3097-c08f-4865-b5bf-2ce1b95b1269], but are not installed on the current farm. Please install any feature or solution which contains these web parts. 

Resolution:
To correct the entries above go to GENERAL APPLICATION SETTINGS > FARM SEARCH ADMINISTRATION > SEARCH SERVICE ADMINISTRATION.   Then afterwards go back to the reported message and click Reanalyse, it should then disappear

Wednesday 15 June 2011

Management reporter 2.0 and Additional settings Performance issue

I have found another issue whilst working on performance issues at a client and with the assistance of Microsoft have picked it up.

When setting up a company the in Management Reporter 2.0 with or without Feature Pack 1 with the following Additional Options will cause performance issues

Account Category,
User Defined 1,
User Defined 2,
User Defined 3
User Defined 4.

Also do not mark Dynamics GP Financials with Analytical Accounting. Hotfix has been released for Feature pack 1 but I can confirm if this helps with performance issues

Example of performance saving by unmarking the options is as follows for a report with a tree that contains 84 units:

With options marked: 60 minutes
Without options marked: 30 minutes

How to transfer logins and passwords between instances of SQL Server

Fantastic article from Microsoft to transfer logins between SQL Server installs.  Pefect for server moves of SQL 7, 2000, 2005 and 2008

http://support.microsoft.com/kb/246133