Connecting 2 packages

[TreleMorele]

Hello,
what should I do to join 2 elements from 2 packages?
For example: GO sales (query) with GO data warehouse (query)

Idk if I understand this well:
- should I predefine in Dynamic Query Mode connections between those 2 packages to make it work? How?

[MFGF]

Hello,
what should I do to join 2 elements from 2 packages?
For example: GO sales (query) with GO data warehouse (query)

Idk if I understand this well:
- should I predefine in Dynamic Query Mode connections between those 2 packages to make it work? How?

Hi,

Can you explain what you're trying to achieve? Are you attempting to bring in data from multiple databases into a dynamic cube? Or do you want to be able to report over multiple cubes as though they were a single cube? Or something else?

Cheers!

MF.

[TreleMorele]

Thank you for your quick response, MFGF.

I believe I want to report over mlultiple cubes as though they were a single cube. Tell me if I'm wrong:

Imagine we have 2 packages like GO sales (query) and GO data warehouse (query)

I make 1 query  with 2 items:
package GO sales (query)-> Inventory (query) -> Products -> Product and
package GO sales (query)-> Inventory (query) -> Inventory -> Unit Cost

I make 2nd query with 2 items:
package GO data warehouse (query)-> Sales and marketing (query) -> Product forecast (query) -> Products -> Product and
package GO data warehouse (query)-> Sales and marketing (query) -> Product forecast (query) -> Product forecast facts -> Forecast unit cost

After that I want to join those 2 queries where Product would be my key.
So I have
Product | Unit Cost | Forecast unit cost
But if I simply grab those 2 queries into join cognos prevents me to add a query from another package.

The same happens with my packages. I assume I'm missing something. Probably I should predefine some connections between those 2 packages.
What should I do?

[MFGF]

Thank you for your quick response, MFGF.

I believe I want to report over mlultiple cubes as though they were a single cube. Tell me if I'm wrong:

Imagine we have 2 packages like GO sales (query) and GO data warehouse (query)

I make 1 query  with 2 items:
package GO sales (query)-> Inventory (query) -> Products -> Product and
package GO sales (query)-> Inventory (query) -> Inventory -> Unit Cost

I make 2nd query with 2 items:
package GO data warehouse (query)-> Sales and marketing (query) -> Product forecast (query) -> Products -> Product and
package GO data warehouse (query)-> Sales and marketing (query) -> Product forecast (query) -> Product forecast facts -> Forecast unit cost

After that I want to join those 2 queries where Product would be my key.
So I have
Product | Unit Cost | Forecast unit cost
But if I simply grab those 2 queries into join cognos prevents me to add a query from another package.

The same happens with my packages. I assume I'm missing something. Probably I should predefine some connections between those 2 packages.
What should I do?

Hi,

Joining is a relational concept, but Dynamic Cubes are not relational - they are OLAP. You can't join cube data in the way you describe.

If you have two dynamic cubes that share all or some dimensions, you can have these feed into a virtual cube, and report over this. The data would need to be in the same data warehouse database for both, though.

Cheers!

MF.

[TreleMorele]

Thanks for your explanation.
I thought it would be more simple. Actually I found that IBM is working on taking data from 2 packages so obviously it can't be done easily now.
https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=91723
So it means I need to have a virtual cube if I want to make it work.
Thanks a lot!