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