Hi Team,
As I am new to sql based report,
Can you please let me know the concept, that even if i develop sql based report because one table is not mapped to the other table.
Is that package required to develop the report.
Kindly suggest me , and give some points to be helpful for me.
Regards
Inam
Yes, the package is the connection to the data source(s). You always need one.
Directly writing SQL in a report is a Bad Idea(tm) in 99.9% of all cases. Just Don't Do It.
If the model is incorrect, it should be fixed.
bd is right about needing a package. You always have to have a package, even if you don't use it. bd is ultra-right about not using sql in the report. You're completely bypassing what cognos does and missing out on the query-writing optimizations it can use. More importantly, at some point down the road, the source or structure of the data will change and you'll have to remember to find and correct this one report, whereas correcting a package fixes every report based on it.
Quote from: bdbits on 16 Jul 2015 10:16:32 AM
Yes, the package is the connection to the data source(s). You always need one.
Directly writing SQL in a report is a Bad Idea(tm) in 99.9% of all cases. Just Don't Do It.
If the model is incorrect, it should be fixed.
Thank you Bdbits