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...

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

How to create measures and Demensions?

Question Posted / swapna

Answers were Sorted based on User's Feedback



How to create measures and Demensions?..

Answer / ven

By using the Framework Manager we can create measures and
dimensions according to our business needs.

Is This Answer Correct ?    4 Yes 0 No

How to create measures and Demensions?..

Answer / palzkumar

Question is bit confusing..

First of all, when you design model in FMW, you will derive
new (calculated) measure thru existing KPI/Measure. Like
Qty, Sales Amt, Rate, Discount etc. From this KPI, you can
derive new measure.

Otherwise, when you design DM for a organization, you need
to study the sytem, you define Dimension, where all master,
and heirachies are there. Difine a Fact Table with All KPI,
Measures/Numbers.

And then you join PK in Dimension Tables with FK in Fact
Table.

This is dimensional modeling in dw. this db can used in
FWM, to create package, where you create calculated measure.


rgds,
palz

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Cognos Interview Questions

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

0 Answers  

Which service handles requests for cognos connection,query studio and event studio.

3 Answers   HCL,

I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?

6 Answers  

What do you mean by drill through report?

0 Answers  

is there any possibility to hide items other than render variable?

2 Answers   IBM,

Can you define framework manager?

0 Answers  

How the Bursting happens in same report and how to Print the bursting Report?

0 Answers   IBM,

What is cognos powerhouse?

0 Answers  

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

0 Answers  

can any one say the which is the best performance in framework manager

1 Answers  

What are all the advantages of Cognos?

0 Answers  

how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls

2 Answers   Patni,

For more Cognos Interview Questions Click Here
Categories