Tuesday, May 20, 2008

3 TIER Business Intelligence

COGNOS 3 TIER BI PLANNING

whenever you're creating meta-data model in framework manger follow this process.. i found it very useful.

Make 3 namesapces in your Framework model

first one named as data source Views(Query Subjects,Procedures, Query items)
Second Busines View(Query subjects,items based on the business users views),
and Third one is Cube(OLAP) view, it contains measure dimensions, regular dimension with hierachies, levels as well.

and then finally publish packages based on these view because it's good for performance.

Post your comments on different modeling techniques in framework manager.

0 comments: