Hi - new member here.Ã, Hope someone can advise me where to start.Ã, I know what reports are required, I know what the source data is like and have entity relationship diagrams showing the linking fields and cardinality.Ã, I've read through all the online documentation and have a good idea of the process from Import View to Business View.Ã, It's just that I've got about 30 tables and this is my first go at real modelling.Ã, One bit of documentation says to think about the report result you need i.e. the query, work out which tables would be needed, look at their relationships and make changes to give reporting results you want.Ã, OK, I can do that but do I have to do that for every query I need? And what happens when a new report is needed?Ã, Do I have to keep going back to the model and check relationships?Ã,Â
Secondly, how many 'stars' would you expect to have to create when modeling with about 30 tables?Ã, Does every table have to appear somewhere in a star schema?Ã,Â
Any advice would be great.Ã, Thanks.
First of all... have you taken any courses in ReportNet? I would advise you to take the "Metadata modelling part 2" course because this will help you a lot in modelling and to understand why somethings are done in a particular way... Just visit cognos.com
Yes, I have taken metadata modelling part one and part two but it was several months ago and I didn't get chance to try things out straight after the course.Ã, Ã, I do understand the concepts and can remind myself of techniques by referring to the course books.Ã, It is just that when I got the Import view in place, put the reporting requirements in front of me and dug out the ER diagrams I realised I didn't know what to do next!Ã, A bit of guidance wouldÃ, be great.Ã, Thanks.
BB
Create some business views, in which you can customize the view for e.g. a particular department and/or use specific filters and create extra / other relationships... But how long has it been that you took the course?