HI All, is this possible to use multiple cube in one report,in case they have some field common as i do want to display data based on these common field as we did in join concept in Simple sql Query . Amit

Hi Amit, yes you can use mutiple cube in a report. First you need to create connection to each seperately and create dataset accordingly. One the fields are in your dataset, you can do whatever you want to. Hope it helps!

Hi All, what i need to do is to connect multiple cube from one cube (Master -Slave relationship) and trying to use that cube in report. Amit

Hi Amit, You can't do it directly. To get it around, use subreports for the slave cubes, then on the master report, use the common fields to connect these subreport against the master cube fields. If you are running SSRS 2008 R2, use the LookUp function. thanks, Jerry