How exactly do we implement basket analysis using reporting services front
end?

I have the mdx expression that will return the number of customers that
have brought specific products together, but i am not sure how i am to
implement this in the cube / reporting services

1. In case the user wants to dynamically select the products for analysis,
then I guess the MDX needs to be built up dynamically and a calculated
measure cannot be predefined in the cube. Can reporting services do this?
(we are using reporting services as front end)

2. In case, the selection of products in fixed, then we can define a calc
measure, but how do we expose the products set to the user? The product dim
has P1, P2, P3,... how do we let the user chose a member that would mean P1
AND P2 AND P3 (multiselect would just mean P1 OR P2 OR P3) I was trying
using calc member on the product dim, but have not been able to do so.

any help is appreciated.

thank you
Rama

--
Message posted via http://www.sqlmonster.com

For point #1, please refer to this MSDN paper:

http://msdn.microsoft.com/library/de.../en-us/dnsql2k
/html/olapasandrs.asp
...
Using Parameters to Filter Data in the Report

The whole purpose for creating parameters is to filter the data that is
displayed in the report. To accomplish this we are going to rely on the
ability of Reporting Services that enables queries to be generated
dynamically at runtime. Treating the MDX query as an expression does
this.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***