we need to create a star schema in FM, but we are unable since we are
pretty new on cognos v8. it would be great if we get any tips/procedure.
thank you in advance
pooja
>:( >:( >:( >:( >:( >:( >:(
Hello Pooja,
You want to do data modelling in Cognos FM. The best practice I would suggest is to have individual layers.
1. Physical or Database layer - Bring in all the data sources here into this layer.
2. Logical Layer - Place where you want to create your joins. Create Namespaces and folders as per your specifications. The cardinality of a join is important. Giving out incorrect specifications might lead to erroneous results.
3. Business Layer - Rename the columns as per your business specifications and standards.
4. Presentation Layer - create packages and administer user security as per your specifications.
This way, your end user will have a completely customized reporting package and the user will remain independent of the changes made in the database layer.
Creating a Star Schema is often the most preferred solution, but not always the most optimal solution.
Use Shortcuts as required, which could mean your package could be maintained more easily.
Hope it helped your cause,
Sagar