Multiple datasources in SSRS 2005 reports

Hi,
Is is possible to have multiple analysis Services datasources for a single
report? I want to be able to display measures from both cubes on the same
report with a common dimension without having to redesign my cubes.
Thanks!
BrianThe short answer is yes, but you won't be able to display the measures
side-by-side in the same region if this is what you are after. That's
because you cannot join RS datasets. That said, you can have two regions,
each bound to its own dataset. If you have a virtual cube and your MDX query
pulls data from both cubies than you should be OK.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Brian Madden" <bmadden@.gmail.com> wrote in message
news:756074632671466407265129@.msnews.microsoft.com...
> Hi,
> Is is possible to have multiple analysis Services datasources for a single
> report? I want to be able to display measures from both cubes on the same
> report with a common dimension without having to redesign my cubes.
> Thanks!
> Brian
>

Multiple configuration question

Hi,

I have an analysis project with 4 configurations

- Development

- Test

- Acceptance

- Production

In each configuration I have set correctly the deployement server.

But the datasources are also dependend of the configuration.

So how can I specify different datasources for each configuration ?

With regards,

Constantijn Enders

The ConnectionString of a DataSource is per configuration. To set it, use the DataSource dialog in each configuration.

These are all the properties that can be customized per configuration:

ReportServer of ReportAction objects Path of ReportAction objects StorageLocation of Cube objects ConnectionString of DataSource objects ManagedProvider of DataSource objects KeyErrorLogFile of ErrorConfiguration objects (used in Dimensions, Cubes, MeasureGroups, Partitions and MiningStructures) StorageLocation of MeasureGroup objects StorageLocation of Partition objects|||

Great, it works.

Thanks

CE