Commerce Server 2009 Datawarehouse reports

Recently Brad Bont has published a good article on his blog about “Capture CommerceEvents with Commerce Server 2009“, this article very clearly describes utilizing the commerce server event logging, for the data warehouse reporting purposes. Have a look at before dealing with commerce server data warehouse.

Shopping Basket Analysis with MS AS

Shopping Basket Analysis Video Tutorial (Data Mining Table Analysis Tool) http://msdn.microsoft.com/en-us/library/dd299410.aspx

Custom DW Class Creation Internals

When you create custom Datawarehouse classes, Commerce Server OleDb provider works on your DW database, and it creates atable, a SP, and inserts records to ClsDef, and MemDef tables.

Below script is provided just to inform you ‘internal events’ when you create a new custom DW class in Commerce Server 2007.———————————————————————————–— DROP SCRIPT: […]

While working with CS DataWarehouse remember these

Datawarehouse and named instanceshttp://social.msdn.microsoft.com/Forums/en-US/commserver2007/thread/52e0fae1-3649-492a-8633-92b7dbf58ef7/

Web Analytics concepts in Wikihttp://en.wikipedia.org/wiki/Web_analytics

Fix for “BadImageFormatException was unhandled” on x64 platforms

How to Install the Data Warehouse Reports

Configuring the Data Warehouse and Analysis Server

How to install a 32-bit version of SQL Server 2005 Reporting Services on a computer that is running a 64-bit version of Windows

How […]