Multi-fact queries across PowerCubes

[halkosj]

We need to do multi-fact queries (stitch-queries) using measures from two different cubes. We have ther necessary conformed dimensions in both cubes.

We're getting this error (in Report Stidio):

OP-ERR-0109

The model item '[Recruiters Cube].[Measures].[Production Recruiters]' is invalid.

Queries involving either cube alone work fine.

How do we get the multiple-cube queries to work?

[aliclowes]

HI

Have you got this to work ? I am having the same problem, as I understand it is because the prompt is returning the member and the member is not known in the other cubes as it relates back to the original cube the prompt is based on

[MFGF]

Hi,

Stitch queries are specifically limited to data modelled in Cognos 8 (ie in Framework Manager).  Cubes are modelled externally to Cognos 8, using whatever modelling tool is appropriate.  Put simply, you cannot have a single query in a Cognos 8 report which spans multiple cubes.  There are various techniques to work around this - UNIONS and/or Master-Detail relationships between queries within a Report Studio report, but in each case, separate underlying queries are required for each cube.

Regards,

MF.