PerformancePoint Server to be merged into next SharePoint version.


Online project management, task software, and free collaboration workspace: AJAXWorkspace
AJAXWorkspace is a free online workspace that offers task tracking software, team collaboration, online calendar, document sharing, and file management for project management and teamwork.

I noticed from my colleague that “PerformancePoint Server 2007 will no longer be a standalone item on the Microsoft price list as of April 1, 2009. Microsoft will release PerformancePoint Server 2007 “Service Pack 3” which will include updates to the current product’s Planning module in mid-2009. This will be the final release of the product and the final release of the Planning component. This release will contain many key feature and functionality enhancements that our customers and partners have requested.”

The functionalities of PerformancePoint Monitoring & Analytics with all scorecard, dashboard, and analytical capabilities will move from PerformancePoint Server into next SharePoint Server Enterprise version.

As a result, end user can save cost without need to purchase additional PPS server license. PerformancePoint Monitoring & Analytics modules are very powerful tools which allow user to easily analyst and monitor their business performance. I believe SharePoint Server will become a popular product very soon.

SQL script to generate random number and decimal as per row basis


This is nothing new on how to generate random number as per row basis. I am using NewID() method and complied into SQL function. Just to keep as my own record. Here are the 2 functions which return integer and decimal value.

Function:

 CREATE FUNCTION dbo.udf_GetRandomNumber(
@GUID AS UNIQUEIDENTIFIER,
@MinValue AS INT = 0,
@MaxValue AS INT = 1000
)
RETURNS INT AS
BEGIN
  �
 RETURN ABS(CAST(CAST(@GUID AS VARBINARY) AS INT) % (@MaxValue – @MinValue + 1)) + @MinValue

END

 Usage:

 SELECT dbo.GetRandomNumber(NewID(),100,500) FROM TableA
– Return random number from 100 to 500 as per row basis

Function:

CREATE FUNCTION dbo.udf_GetRandomDecimal(
@GUID AS UNIQUEIDENTIFIER,
@MinValue AS INT = 0,
@MaxValue AS INT = 1000,
@GUIDDecimal AS UNIQUEIDENTIFIER = NULL
)
RETURNS DECIMAL (18,2) AS
BEGIN
 DECLARE @dResult AS DECIMAL (18,2)
 IF @GUIDDecimal IS NOT NULL
  SET @dResult = ABS(CAST(CAST(@GUID AS VARBINARY) AS INT) % (@MaxValue-@MinValue + 1)) + @MinValue + ABS(CAST(CAST(@GUIDDecimal AS VARBINARY) AS INT) % 100)/100.0
 ELSE
  SET @dResult = ABS(CAST(CAST(@GUID AS VARBINARY) AS INT) % (@MaxValue-@MinValue + 1)) + @MinValue

 RETURN @dResult

END

Usage:

SELECT dbo.GetRandomDecimal(NewID(),100,500,NewID()) FROM TableA
– Return random decimal number from 100.00 to 500.99 as per row basis