Combining OLAP and relational data sources

Although there is no restriction on importing both relational and OLAP data sources into your Framework Manager project, you need to be aware of two things when adding OLAP data sources:

  1. The metadata for OLAP sources is checked when the package is opened in one of the BI Studios. If there are a lot of cubes in the package, it will take a long time for the package to open or it may not open at all.
  2. If an OLAP source is not available, the package will not open even if the relational sources are available.

Your Report Designers will need to be made aware that there are relational and OLAP data sources available within the published packages since combining data from the different sources may add complexity ...

Get IBM Cognos 10 Framework Manager now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.