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
2)
few points to add would be
1) to check the relations between views..for e.g. if connecting two reference tables or connecting a reference with transcation table use the cardinality properly by analysing the two..
2) have a separate/ shortcut of views or QS for showing outerjoins and inner join.
Srik