Using multiple data sources within one report

  • If I wanted to combine the data from an OLPA cube, and a flat SQL database table within the same report, is it possible?

  • Yes, depends entirely on how you want to join them in the report but there are many possibilities:

    1. Create two datasets, and have these printed on the report in two tables.

    2. Create one dataset that does an internal join of the source.

    3. Create two datasets, and have the data printed in one table (means you must use some aggregate functions on the second dataset).

    As I say, it depends on what you want.

    Regards,

    Nigel West
    UK

  • Thank you Nigel.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply