Master Detail Relationships

Bursting without a Master Detail Relationship

Situation: the customer is making the same report available via bursting and via the portal.

Issue to solve: to enable bursting on a report, a master detail relationship between the burst table and the content of the report has to be enabled. However, this master detail relationship is not wanted on the report when executed from the portal. Using only IBM Cognos BI, the author needs to maintain two identical reports with the only difference being the relationship to the burst table.

Makes BI work: With Abirio, the burst table is maintained outside of the report. As such, no master detail relationship is needed on the report itself. Abirio will use the burst table to generate and distribute the same report as the one used in the portal, thus saving the author the overhead of maintaining the same report twice.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s