Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Force Multiple Queries / "Stitching" in Union

647032May 14 2009 — edited May 15 2009

Is there any way to force OBIEE to execute several queries in parallel when combining several similar queries?

For example, I have a very large fact table with monthly snapshot data. I would rather use combine with similar request option to send similar queries for each month and have OBIEE "stitch" them together. I have seen cases where multiple queries are sent do the database and other cases where one query is generated and sent to the database. Is there a way to force multiple queries to be sent?

Ideally, what I'd like to be able to do is use my time dimension to send always force a query for each month (which is partitioned in the database).

Edited by: user644029 on May 14, 2009 1:41 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 12 2009

Added on May 14 2009

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

4 comments

857 views