COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: inu on 06 Dec 2013 10:30:10 PM

Title: Why not getting no issue on changing the query item name to business name
Post by: inu on 06 Dec 2013 10:30:10 PM
Hi
When we create presentation layer  in Framework Manager for a model, we also change the query item name into business name. but at the time of running the report in report studio, cognos might goes to database and fetch the records properly and correctly. how it is done correctly!!!!!!!!!!. Though the column names have been changed ,:

  Is not there a mismatch of column names of database table and our query item names. please clear my duaghts.

Thanks and Regards
Inam
Title: Re: Why not getting no issue on changing the query item name to business name
Post by: blom0344 on 09 Dec 2013 01:51:35 PM
Cognos maps the column names to business names by means of the metadata layer. That's basically the function of a framework : mapping a business model to entities in the database , making sure the correct SQL is generated. you may get a clue from studying the generated SQL of a model query subject