Source for Transformer

[barrysaab]

I need to create cube in a transformer and am using report as a source ,but if my report is developed through sql.Does it matter?Please Suggest.

[cognostechie]

Why do you ask? Is it not working ?

It does not matter as long as the report is a valid report in Cognos Connection (should be valid in Content Store).

That being said, it is a better idea to use a package instead of a report as a data source.

[twlarsen]

Why would it be better idea to use a package then a report as a data source?  Is there a performance gain?

I always used reports since it's easier to customize, and didn't have any issues that were solved by using a package instead.

Am I missing something about the report vs package setup?

[cognostechie]

Everything is not about performance gain.

A report is out there on the portal and can be accessed by many users unless you secure it. If somebody modifies it (removes a column or adds a filter) for the purpose of the report, it will break the Transformer model or affect the data. A package is accessed only by developers so it is in more reliable hands.

From an architectural perspective, I prefer a package from a seperate namespace meant only for the Cubes but you can go ahead with the reports if you like.