Development Stratergy

[muraliredy]

Hi Guys,
             we have planned to develop reports on our product which is related to supply chain managment. we are having little bit information on cognos and so  can any of you provide some good suggestion how we can plan and proceed to develop the report in

at present this reporting will be based on t he OLTP system and not on OLAP system. can you please suggest us which will be the best way of doing reporting using OLTP environment

i have some ideas can you please tell ame if my approach to my reporting is correct
-----------------------------------------------------------------------------------------------------------

1) Create database views in the OLTP database
2) Importing the view in to congnos frame work and appling securities to the query subjects based on user and groups
3) Based on the view creating a star schema model
4) using this star schema model for reporting purpose

can you please suggest me if the above process is ok or do you have any other best process to implement reporting on OLTP database

We are currently Working on Cognos Reportnet 1.1 MR3

[COGNOiSe administrator]

Querying OLTP directly might affect your perfomance, but is acceptable. Views would help, especially if they were materialized ones (ORACLE).