How to extend orders schema in datawarehouse

In the development phase of a Commerce Server 2007 project, I extended Order classes following these instructions the vkumar instructions.
I did it really good, and everything in my web site is working well, but few days ago, my customer asked me to create some reports with Reporting Services filtering the results by the field I added to the classes.
I need 2 days of work to find the solution to this problem.
The steps to do make the Datawarehouse work with this new fields are:

  1. Extending the Data Warehouse Logical Schema :
    Create a vbscript to add the new Member to all the extended classes
  2. Select Transaction Properties for Import
    1. Add the required field to csv_* views in database *_transactions
    2. Add the required records to the table TransDimension in *_transactions db.
  3. Run an Import DTS Package
    This will add new stored procedures in datawarehouse db, incrementing the MinorVersion field in ClsDef table, make the data import task point to these new stored procedures.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s