We are currently using and ODS database for our reporting. I was if anyone has any idea whether it is possible to collect data from more than one package with similar data. For instance I want to use an Employee package at first but not all the data that I want is in that package. So i tried moving over to the Payroll package that has many of the same UIDs but the report no longer is valid because the links are lost to the old package. Is this functionality just not there or do I need to do something special?
Hi,
you could use "pure" SQL, depending on your Database and join them.
Sounds to me like your requirements were not captured correctly.
...Report Studio can only point to one "package" per report.
...if you have reports that can't be built because of this, the package doesn't meet your requirements.
Yes, you could use SQL, but ...that's a hack and does not really align with the paradigm of this toolset (i.e. rapid application development, code versus configure, meta-data in one place, etc..)