Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are the best practices while building a Cognos Framework Manager Package ?
As in, what calculations would you not like to be handled in FM and rather get it directly from Database.

Answer Posted / praveen k

best practices of framework manager are,
Create

1)Database view

   a)Import the Metadata from database.
   b)Check the usage properties of each query item
   c)manage the relationship and cardinality of Query            subjects
2)Business  view

  Rename the existing query subjects into business            understandable names.
3)Dimensional view

   a)Create regular and measure dimensions using business       view.
   b)set member caption and business key of regular            dimension.
   c)Check scope of dimensional view.

4)Package view
  a)create query and analysis packages.
  b)publish the packages to cognos connection.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between powerplay transformer and power play reports?

951


----------------Describe DWH Architecture?

2012


What do you mean by drill through report?

920


2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

2139


Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2502


How to a create header dynamically in a crosstab report in cognos 8.1?

2375


Which studio is used to create reports?

1055


What is a Pivot?

1041


What do you understand by ‘ibm predictive maintenance and quality’?

932


how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

995


in u r data u having duplicates how to fetch the latest data in our report?

5630


Can you define framework manager?

965


Define dimensions?

968


Can you define fan trap?

1222


Can you define snapshot?

878