join multiple cubes in one RS query

[Alex_G]

Hello, All!

I need to join the data from two PowerPlay cubes in one query.
This cubes has 3 Identical dimensions.
Whether there is an opportunity to make it?

Thanks in advance,
WBR Alex

[MFGF]

Hi,

Data cannot be joined directly across multiple cubes.  The only options you have are to bring in the data from each cube in a separate query, then either UNION the queries together or else link them using a master-detail relationship.

Regards,

MF.

[Alex_G]

Thank you!

I created a query as an UNION, and now have a trouble with parameters for dimensions.
I defined a filter as: caption([mycube].[Time].[Time].[Month])=?MonthFilter?

MonthFilter is defined as a list of items of [Month] level [Time] dimension, like 2007/Apr,...
In result, report has not returns any rows.

With filter        caption([mycube].[Time].[Time].[Month])='2007/Apr' data in report is present.
   
In what there can be a business?

W.B.R., Alex

[rockytopmark]

This is a Dimensional datasource, so think dimensional with your report and filtering!!!

Filter() is and MDX function that can limit the result set.

Use the dimensions rather then their attributes and roles when filtering, it is more effective and eloquent.

Also, Try putting this in your report, rather than the Month level itself:

[mycube].[Time].[Time].[Month] -> ?timeParm?

It will force a Tree Prompt, which will display the Time Hierarchy in easy to understand and choose from manner.

If you wish your report to be dynamic (allow drill-down) then just have the Level in your report and create a Filter that filters the hierarchy with the parameter, like:

[mycube].[Time].[Time] = ?timeParm?


A mixture of the two can make for a really elaborate report, displaying multiple levels and yet dynamic.

[Alex_G]

This is a Dimensional datasource, so think dimensional with your report and filtering!!!

Filter() is and MDX function that can limit the result set.

Use the dimensions rather then their attributes and roles when filtering, it is more effective and eloquent.

Also, Try putting this in your report, rather than the Month level itself:

[mycube].[Time].[Time].[Month] -> ?timeParm?

It will force a Tree Prompt, which will display the Time Hierarchy in easy to understand and choose from manner.

If you wish your report to be dynamic (allow drill-down) then just have the Level in your report and create a Filter that filters the hierarchy with the parameter, like:

[mycube].[Time].[Time] = ?timeParm?


A mixture of the two can make for a really elaborate report, displaying multiple levels and yet dynamic.

Sorry, but filter() gives the empty result in my case too.

[mycube].[Time].[Time] = ?timeParm? and [mycube].[Time].[Time].[Month] -> ?timeParm? is not applicable, because of two cubes with one parameter.