Report examples using Analysis services and reporting service

Hello

Are there any examples of Reports using Analysis services and reporting service

Thanks

arik




Answer this question

Report examples using Analysis services and reporting service

  • h1

    Hi arikve,

    Is your question about the commerce server 2007 context, or about a general context

    Regards,



  • Can-Ann

    Hello arikve,

    Concerning reporting services You have many samples (rdls) in your commerce server 2007 base installation directory (RDLs\ your language\ subdirectory example C:\program Files\Microsoft Commerce server 2007\RDLs\EN\).

    Concerning analysis services, if you have an existing commerce server 2007 web site installed on your server , you can access to your cubes through sql server analysis services and choosing your relevant database.

    You must have installed your data warehouse database before.

    If you have no commerce server web site, install the starter site.

    You can access the reporting services related to you web site, use Report Manager.

    If you want to see data:

    First navigate (create your account, buy products ...) your site.

    Second use the data warehouse import wizard to create a DTS importation task that populates the data warehouse with:

    IIS logs files

    catalog data

    profiles data

    Transactions data

    Execute this DTS task to fulfil your cubes

    Use Report Manager to view the resulting reports.

    Ps. you can create your own cubes and reports and add them to Report manager

    Regards,



  • Gabriel Méndez

    hi

    my question is commerce server context

    Thanks



  • Report examples using Analysis services and reporting service