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 types of facts ? explain them?

Answers were Sorted based on User's Feedback



what are the types of facts ? explain them?..

Answer / palzkumar

Three types of Fact...

1. Additive Fact: Additive facts are facts that can be
summed up through all of the dimensions in the fact table.

2. Semi-Additive Fact: Semi-additive facts are facts that
can be summed up for some of the dimensions in the fact
table, but not the others.

eg : Bank Balances - you can take a bank account as Semi-
Additive since a current balance for the account can't be
summed as time period; but if you want see current balance
of a bank you can sum all accounts current balance.

3. Non-Additive Fact: Non-additive facts are facts that
cannot be summed up for any of the dimensions present in
the fact table.
Eg: . Ratios, Averages & Variance

rgds,
palz

Is This Answer Correct ?    47 Yes 1 No

what are the types of facts ? explain them?..

Answer / arkchowdary

Types of Facts------------------ Additive Fact,
Semi-Additive Fact,
Non-Additive Fact.
Perodic Fact,
Accumilative Fact

Is This Answer Correct ?    10 Yes 8 No

Post New Answer

More Cognos Interview Questions

what is mean by cognos powerhouse?

1 Answers   TCS,


my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

0 Answers  


Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com

7 Answers  


What is Parametermap?

2 Answers  


What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?

1 Answers   IBM,


How do we convert from Numeric to be Words?

0 Answers  


How can create users and permissions in cognos?

0 Answers  


describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

0 Answers  


What is the enterprise class platform architecture of cognos 8?

0 Answers  


How security is concerned with Reportnet? Explain its implementing steps.

0 Answers   iFlex,


how to perform back drill through in cognos 8 what is the use of it

0 Answers  


in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

0 Answers  


Categories