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

How to create measures and Demensions?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by Drill down and Drill Up?

934


tell me two or three issues from client side and how to solve those issues?

2107


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2197


what are the errors faced while bursting the reports and how to solve those errors?

1946


Can you explain new content durability?

968


please please give me some banking calculations in framework manager.

2031


What is the use of cognos decision stream?

1035


Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

2013


how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?

2227


how can I test reports in cagnos?

1074


Can you define query studio?

911


In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1924


What you mean by drill across and what is the difference between drill through, drill across?

966


plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........

2304


Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

905