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 line item dimension? when we need them?
how we will come to know we need to create line item
dimensions?

Answer Posted / gangadhar

If the volume of the masterdara of a dimension is growing
along with the transaction data then to improve the data
read performance of master data, we can create the
dimension as line item dimension.

when we create a dimension as line item dimension, the SID
of the characteristic will be joined directly with the fact
table without using dimID's.

Disadvantages : F4 help is not possible in data selection
screens for line item dimension.

Conditions : 1. The dimension should have only one
characteristic. 2. Master data of dimension >= 20% of
transaction data of infocube(interms of records).

Is This Answer Correct ?    20 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What steps do you take when you add a new company code to the already running delta datasource ? The datasource is already extracting specific company code delta data , so how will add new company code without disturbing delta

1212


What are transfer rules?

883


What are the do?s and don?ts?

2021


Which transaction on R/3 shows the transactions with pending processes for update?

1919


What is the calculated key figure?

881


What is an open hub service?

963


What is the program to maintain change run?

2117


Where the data is extracted during init of delta and during delta updates?

1957


Extraction in mm and SD and FI? What is the requirement and name them?

2078


Where do we use write optimized dso?

903


what are the data types for the characteristics info object?

924


What exactly do you know about business warehouse statistics?

883


What is update routines.

907


What is data ware-housing hierarchy?

1048


What are the naming conventions for aggregates created from statistics?

1866