Gael Duhamel [MVP]

In the Commerce Server enterprise edition, you can have access to the analytics reports and to a data warehouse.

In this post, I will show you how to configure them, and in the same time have a quick look on what it’s look like.

Before to start the installation, you have to install and configure:

• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
• SQL Server Integration Services (SSIS)

Please, be sure that you have the mandatory prerequisites:

• For SQL Server 2005
  • Install Microsoft SQL Server 2005 Service Pack 2
  • Install Microsoft SQL Server 2000 DTS Designer Components
• For SQL Server 2008
  • Install Microsoft SQL Server 2005 Backward Compatibility Components
  • Update all the reports to SQL Server 2008. For that, open it all with the SQL Server Business Intelligence Development Studio 2008. The RDL’s files are stored in: %commerce_server_root%\RDLs

Now it’s time to unpup the ressource file for the data warehouse (the file takes place in %commerce_server_root%\Pup Packages\DW.pup). This ressource will create the database which will be the cube’s data source.

Beware: if you install your data warehouse in another language than english you must change the file %commerce_server_root%\Data\CommerceOlap.xmla  line 9679 and replace the “Everyone” string by “Tout le monde” for the french environment.

<Roles>
  <Role>
    <ID>All Users</ID>
    <Name>All Users</Name>
    <Members>
      <Member>
        <Name _loc="locData">EveryoneTout le monde</Name>
      </Member>
    </Members>
  </Role>
</Roles>

Read the rest of this entry »