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 / chavid

Hen the chracteristic value (#s) is one & is larger (say
like order no. During query this ill give performance
issue. So it is better to define such chars as line item
Dims. Only SId is generated & used by fact table. R O thumb
is hen the cardinality is > 10 then it is advisable to
define the IO as L I Dim. L I Dim uses b-tree index (
default is Bipmap).

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is virtual kef figures? what are the uses and in which case supposed to be use?

1960


What is the licensing requirement you should be aware of?

2108


Give examples of data sources that support remote cubes?

2070


What are the sap enhancements to enhance fir data?

940


How would you know if a segment/segment level entry has been summarized?

1831


how to getweekday,weekmonth,month,weekno,week order in the report by using routines?

2047


which object based you created extended star schema?

1722


What is the use of db connection in sap bw data acquisition?

971


What are the other BW processes?

2066


What is extended star schema?

987


is there is any book that covers all topics of BI 7.0 and the navigation steps for bi 7.0 and pdf of 7

1953


What is the procedure to create a data mart?

2064


how the master data is read?

2081


Explain ods?

969


How much time would it take to upload 1 million data to infocube?

946