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.
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.
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?
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.