Tuesday, January 27, 2009

PPS Planning Discontinued by April 1,2009

A couple of emails I've received and feedback I've seen from different forums are not consistent with the announcement Microsoft gave last Friday and I want to clarify this.

The PerformancePoint Server 2007 is rebranded as PerformancePoint Services and will still be offered in the market as part of MOSS Enterprise. There are 3 components of the PPS server: Planning, Analytics and Monitoring (PAM). Of this 3 only Planning is discontinued while Analytics and Monitoring will be called PerformancePoint Services like Excel Services, Forms Services and Visio Services in the Sharepoint platform.

Thursday, January 22, 2009

My favorite SQL Server sites

Data Mining http://www.sqlserverdatamining.com/ssdm/

Best Practice http://www.kimballgroup.com/

Reporting http://www.databasejournal.com/article.php/1459531 (William Pearson)

Integration http://www.sqlis.com/

Microsoft BI http://www.microsoft.com/sqlserver/2008/en/us/business-intelligence.aspx


SQL Protocols http://blogs.msdn.com/sql_protocols/default.aspx

BI according to Microsoft

The Microsoft BI team presented the new BI stack to the New York Business Intelligence New York Meetup group yesterday. The first part of the presentation was the product demonstration then an open discussion on the product functionalities which got too detailed. A comparison of Excel 2007 and Proclarity was also in the table but was cut short because it was out of content. It was refreshing to see ProClarity working in harmony with PerformancePoint Server and MOSS.

To get more info about Microsoft BI click here. To join the New York Business Intelligence Meetup click here.

Friday, January 16, 2009

Microsoft Convergence 2009 New Orleans Announcements

If you're planning on attending Convergence this year please read this:

  • Early Registration discount date has been extended to January 21, 2009. Save $300 by registering early, secure your favorite hotels while they are still available and take advantage of better airline rates.
  • The session catalog (containing 225 sessions) is now live on the Convergence marketing site.
  • The Convergence Customer Excellence Awards recognize, honor and celebrate customers who have achieved outstanding success with their Microsoft solutions as well as Microsoft partners' solutions. Customer Excellence Award nominations are now being accepted through January 20, 2009.

Tuesday, November 11, 2008

Microsoft Dynamics GP/SL HR/Payroll Offer

For Microsoft Dynamics GP customers licensed under Module Based Licensing Professional Edition or Business Ready Licensing: Receive up to 20% off on Human Resources and Payroll modules purchases over $5,000

For Microsoft Dynamics GP customers licensed under Module Based Licensing Standard Edition and Microsoft Dynamics SL customers licensed under Module Based Licensing or Business Ready Licensing: Receive up to 20% off on Human Resources and Payroll modules purchases over $3,000*

As an additional benefit, Microsoft Dynamics GP customers licensed under Module Based Licensing or Business Ready Licensing can receive up to a 20% discount on a PTO manager module purchase

Click HERE for more information

Monday, September 08, 2008

The End of GAAP Could Begin Next Year

The SEC suggests that some companies could forgo GAAP by the end of 2009, and that all companies may have to do the same by 2016.


The Securities and Exchange Commission has raised the possibility that some U.S. publicly traded companies will be able to use international financial reporting standards next year.

On Wednesday, the SEC commissioners proposed a timetable for transitioning all public companies from U.S. generally accepted accounting standards to IFRS within eight years, with the allowance for some companies to begin using the global rules earlier. If this so-called roadmap is approved, the SEC estimates that 110 companies would be eligible to use IFRS at the end of fiscal years ending after December 15, 2009, depending on their size and industry.

The roadmap further calls for the SEC to make a decision in 2011 regarding whether to require all of its registrants to use IFRS......click here for more

Friday, August 01, 2008

Error when using ProTools Item Combiner

Question: I am merging one item code to another. The item validates. I run the merge
and get an error "Cannot insert duplicate key row in object 'IV10201' with
unique index 'AK3IV10201'."

If it's merging one code into another table, how could it possibly have key
violation since it's changing the code?

The same error is happening on every item I try.

Answer(from my friend Richard Whaley):
This is one of the headaches of combining items.

The IV10201 table is the purchase receipts. So, if Item A had a receipt and
Item B had a receipt, you are also combining the receipt list. This should
work EXCEPT...

The AK3IV10201 index is a unique index, meaning there can only be ONE entry
in the index with the same item number, receipt number, and receipt type.
So, if item A had a receipt #5 via PO and item B had are receipt #5 via PO,
you get this error.

How to fix it? you need to purge receiving history, something you might not
want to do.

Digital Transformation unleashed

You're the CIO/CDO sitting in your weekly update executive meeting with the CEO, CFO, COO, and others. You start the meeting with the pr...