DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
vishwa4ds
Participant



Joined: 06 Oct 2005
Posts: 7

Points: 68

Post Posted: Fri Apr 17, 2009 10:36 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hi ,

Framework Manager is the core part of Cognos BI suite.
It is internal tool of cognos to build Logical Metadata modelling by creating Cubes.

So we can say in a high level that Framework manageer is used to create metadata of report which contains relevent information pulled from database(s).

We refresh cube to update the report.

Best practice is to create view of tables then connect cognos to it.
Fetch the data from views and create cubes which is used feed values to the report.
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42790
Location: Denver, CO
Points: 220550

Post Posted: Fri Apr 17, 2009 12:34 pm Reply with quote    Back to top    

Is there a question here anywhere?

_________________
-craig

"I don't mind you comin' here and wastin' all my time time"
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54407
Location: Sydney, Australia
Points: 295092

Post Posted: Fri Apr 17, 2009 2:45 pm Reply with quote    Back to top    

I don't think it's fair to say (at least in version 8.4) that Framework Manager creates any metadata. Metadata are stored in the unified metadata repository of Information Server, which any of the Co ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
Not yet rated
vmcburney

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 23 Jan 2003
Posts: 3590
Location: Australia, Melbourne
Points: 28109

Post Posted: Sun Apr 19, 2009 8:30 pm Reply with quote    Back to top    

One of the problems is that a database takes a physical column name and a comment. Cognos needs three pieces of metadata: column name, label and tool tip. If you define all three in the model you lose one of them in the database - usually the label which is the most important metadata since it is the name of the field used in reports. I found it best to export the metadata straight from the modelling tool into Cognos Framework Manager and to bypass the Information Server. Once in Cognos you need to make some model adjustment depending on how your model matches how Cognos works and you may need extra derived columns such as unique counts.

_________________
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn: Vincent McBurney LinkedIn
Rate this response:  
Not yet rated
eostic

Premium Poster



Group memberships:
Premium Members

Joined: 17 Oct 2005
Posts: 3788

Points: 30468

Post Posted: Sun Apr 19, 2009 9:41 pm Reply with quote    Back to top    

Another interesting integration is to take mature metadata from Framework Manager and put it into Business Glossary. Quite often the Framework Manager contains rich descriptions, like the tool tips that Vincent mentions, and "Model Comments", each of which can be stored in BG and then used in BG Browser searches, Business Glossary Anywhere, and in the Cognos 8.4 feature that dives directly into BG from within the Cognos Report and Query Viewers.

This can be done in several ways. One that I've found successful is to use the Model report extract feature from Framework Manager to create an xml document that can then be manipulated into csv for loading to BG.

Ernie

_________________
Ernie Ostic

blogit!
Open IGC is Here!
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours