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 is a dimension table and types? explain about line
item dimension and high cardinality and uses, in which case
suppose to be use?

Answer Posted / shri

Dimension table which holds character infobjects...

Types of Dimension tables..
Time dimension
Unit dimension
Package dimension

Line item dimension
when the dimension table contains more than 20% size of
fact table then it is a line item dimension..
in line item dimension table we will have only one
character info object..

scenario..
document number in granular infocubes..
customer numbers in coustmer-centric business like
telecommunications,banking and insurance...

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is automatic loading of similar/identical requests option?

1963


what are the drawbacks of ods?

1003


How to create condition and exceptions in bi.7.0?

867


What is the process chain and when you can use the same in the data warehouse?

835


What is the procedure to create a data mart?

1972


What are the steps to load non cumulative cube?

2380


What are value sets?

2013


What is a dashboard in sap bw?

989


describe how you have used excel as a compliment to bex?

914


Give an example of the content key figure OTOTALSTCK (quantity total stock)?

2166


Can you create a data storage area in the sap bw?

886


How would you convert an info package group to a process chain?

2388


What is the difference between ods and info-cubes?

951


What are the options to calculate result as ? summation?

1930


Explain ods?

906