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

Explain the architecture of the sap bw system?

901


What is translation key?

1971


which object based you created extended star schema?

1656


R/3 extraction failed - recovery procedure? R/3 extraction is running from past 2 years. Suddenly it failed since 5 days and again today it is running fine. But how i do get data loaded to cube for failed loads? What are the procedures that can be followed?

2688


What is extraction setup?

2120


is their any difference between bex 3.5 and bex 7.0?

4008


I don't have master data it will possible to load transaction data? it is possible is there any other steps to do that one

2622


In real world when do you recommend aggregate?

2360


What are the options for conditions for key figures?

1841


How do you use the value set in bex query?

2287


Tell something you know about the dimension in the warehouse and how it can be optimized?

914


How do you check the alert monitor?

2132


What is data flow in bw/bi?

988


You have 10 cubes for which you created multiprovider but you want data only for one cube. What will you do?

930


is it possible to avoid special characteristic in infocube level permanently?

1832