11/30/12

All about SAP BI....

Home

Profile

Photos

SDN SAP BI NEWS

All about SAP BI....

I don't own any material or content, all are collected from various Sources.Logos and content are owned by respective owners.

All about Attributes.

Posted by Sharath Labels: SAP bi c ertific ation material, SAP BI FAQS, SAP BI INTERV IEW QUESTIONS, SAP BW INTERV IEW QUESTIONS

Popular Posts
S PB B Itriw A W Inev e Q et n C niu d. u si s o t e .. o n .

Entries (RSS)

Comments (RSS)

B :e l n ve T iae y lea ae n hs r q et n Ia e .f h v u si s fc d Iu ae o a ysre sos o a yo e n ce n h t fr n n o teq et npoieta f h u si rv o d ht o ea o 1 Weh v sa. n l .. s ae t. . S PB 7Itriw A I nev e Q et n!! t R a Tm u si s !Wi e l ie o ! h a po c .. p ra h. . B : h n i b ns g y C a dr a i u a n S uc : D Itriw r a d o re S N nev es n e teq et nwln t e a h u si i o rm i o l n tesm , u f dte h a e b ti h n p ten Bif f o r rfe atr. r o y u poi e l B. . . C m o Po u t nFi rs o m n rd ci aue o l E c u trda B /B n o nee t W I Po u t nS p ot rd ci u p r o

By:Sridevi Aduri Attributes are InfoObjects that exist already, and that are assigned logically to the new characteristic Navigational Attributes A Navigational Attibute is any attribute of a Characteristic which is treated in very similar way as we treat as Characteristic while Query Designer. Means one can perform drilldowns, filters etc on the same while Query designing. Imp Note:
While Creating the Info Object -- Attributes Tab Page -- Nav Attri butes to be switched on . While Designign the Cube we need to Check mark for the Nav. Attributes to make use of them.

A ot bu
H y o s. T i b gi a a o t A B, ee e F l . . hs l s l b u S P Ih r k . o l I a t osaeI otn S PB Itriw w n t h r mp r t A Ineve a q et n, eala o t A B C r f ain, u si s D ti b u S P I et i t s o s ic o ra t se ais n lt k o l g w i i e li cn r a d i l n we e hc - me o te d h e re . tiki anc p c t sae i i an d Ihn t z i l e o h r. wl e a l t t k e U d t gti b g. Iyufe r o e p p ai hs l . .f o e l y n o . smeg o B sufs aee o g t b h r, o o d I tf i fr n u h o e ee p aed e it l s o malo e bisharath.blogspot@gmail.com.... H vfn. a u. . . H vanc Tme. a i i .. e .

Follow by Email: For new Updates

Email address... Submit

Features / Advantages
Nav. Attr. acts like a Char while Reporting. All navigation functions in the OLAP processor are also possible Filters, Drilldowns, Variables are possible while Reporting. It always hold the Present Truth Data . Historic Data is not possible through Nav. Attributes. As the data is fetching from Master Data Tables and Not from Info Cube.

Labels
BI (15) BI 7.03 (2) BI 7.3 (2) bi certification material (5) Difference between DTP and Infopackage (3) Differences between BW 3.5 and BI 7.0 (2) DYNAMIC FILTERS (2) EDW (1) End Routine (3) Enhancement (2) Expert Routine (3) Extraction (11) INFOPACKAGE (2) Process Chains (1) Queries (4) RDA (1) Realtime Data Aqusition (2) Reporting (8) Routines (2) sap BI (9) SAP BI ABAP (1)

S m ayT iK o ld e u m r hs n we g bif ep B C nutns s r h ls W o sl t a e a Q ikrfrn eg ie i uc eee c ud ,n sln C m lxpo u t n ov g o pe rd ci i o I u s A to: eaa s e, uh r D vkr s R d yT . e d a. . Wh D Pa d y T n nt o Ifp c aei no a kg n S PB 70 o A I .? r Df rn e iee c f b t e nD Pa d ew e T n Ifp c ae no a kg S m ayT id c m n wl u m r hs o u e t i l h l t u d rtn teb s ep o n esa d h ai c ie o w yD Prpa e I da f h T el dP c i B 70fro dn ted t n I . o la ig h aa t d t tres n d t. o aa ag t a d aa. . Al A Sa d r R p rs lS P tn ad e ot N Bo dlvl e ot o ra ee R p r O t n aaa l fr e ot pi s vibe o rp r o l e e uinT o eR m rs xc t o c d e ak U e b R p r ae . sd y e ot ra. . D tF w o Po es h isn aal o f rc s C a i n df rn S PB B iee t A W-I f T eeaesm t e d u t h r r o ei s o bs m rgrigh w t st p e adn o o e u po ess i i tepo es rc se wt n h rc s h c a s Po es h i i h i . rc s c a s n n srcua a dlg a tu trl n o i l c go pn o . ru ig f. . IF C B SNO U E U TMA ES P LI T A BW C N E T I O CP S E P AN TO X L IA IN IF C B SNO U E U TMA ES PBW C N E T LI T A I O CP S E P AN TO - y"hi nh X L IA IN b S r a t k Muh a "N O U E tyl IF C B S a U TMA EE P AN TO L I T X L IA IN IF C B 1 IF C B -. N O U E . N O U E. . S PB D t S uc A W aa o re Ehn e e t n ac m n

Disadvantages:
Leads to less Query Performance. In the enhanced star schema of an InfoCube, navigation attributes lie one join further out than characteristics. This means that a query with a navigation attribute has to run an additional join If a navigation attribute is used in an aggregate, the aggregate has to be adjusted using a change run as soon as new values are loaded for the navigation attribute.

http://help.sap.com/saphelp_nw04s/helpdata/EN/80/1a63e7e07211d2acb80000e829fbfe/frameset.htm INFOCUBE (1) Transitive Attributes A Navigational attribute of a Navigational Attributes is called Transitive Attribute. Tricky right Let me explain
If a Nav Attr Has the further more Nav. Attributes ( as its Attributes ) in it those are called Transitive Attributes . For Example Consider there exists a characteristic Material .It has Plant as its navigational attribute. Plant further has a navigational attribute Material group. Thus Material group is the transitive attribute. A drilldown is needed on both Plant and Material group.

If Cube contains both Material and Plant

SAP bi certification material (6) And again we need to have both Material & Plant in your Info Cube to Drill down. (To fetch the data through Nav. Attrs. we need Master Data SAP BI FAQS (5) tables hence, we need to check mark/select both of them in the Cube SAP BI INTERVIEW QUESTIONS (10) )ht:/ epspc m sp ep n 0sh ld t/N 6/ 75b 1 0 52 1000a10ff m st t tp/h l. .o /a h l_ w 4/ ep aaE /fc 53 b c b 6e 0000142/r ee. m a a h SAP BI Inventory Management (1) sap bi stuff (6) sap BI support issues (11) SAP BW 7.03 (2) SAP BW 7.3 (3) sap bw certification material (4) SAP BW FAQS (4) SAP BW INTERVIEW QUESTIONS (6)

Dimension table having both Material and Plant will have Dim ID, Sid of Material, and Sid of Plant. Since both the Sids exists reference of each navigational attribute is made correctly.

If Cube contains only 'Material

bisharath.blogspot.in

1/15

11/30/12

All about SAP BI....

Dimension table having only Material will have Dim ID, Sid of Material. Since Sid for first level navigational attribute (Plant) does not exists, reference to navigational attribute is not made correctly. Exclusive Attributes / Attributes Only/ Display Attribute If you set the Attribute Only Indicator(General Tab page for Chars / Addl Properties tabpage for Key Figs) for Characteristic while creating, it can only be used as Display Attribute for another Characteristic and not as a Nav. Attr. Features:
SAP BW New (2) sap bw support issue (8) Start Routine (2) Supporting Issues (9) Whats new with SAP NetWeaver BW 7.3 (3) Why DTP and not Infopackage in SAP BI (2)
A d dB : e kt C a p ti d e y V n aa h l ah a C aa aiR Pe K m r h lp l . rm u a, l l , Vks gr a S e aJ h i A aw l e m o n a , a dT p nK m r a . . n a a u a Ji 1 n Ito u t nA w c n nrd ci s e a o ra . e d. . S PB IvnoyMa ae e t A Ine tr ngm n B : a K n uaa dJ u y Rj ad l n i t Ki n S uc : d . pc m r h a o re sns .o s a H, F w p it i i e onsn IvnoyMa ae e t B ne tr n g m n. W Ivnoym vm n c b s ne tr oe e t u e aeii. r nt . . S PB Itriw Q et n A Inev e u si s o C n2. o t.. .

T eew s nerrntigd e h r a a ro i hs a g t

And it cannot be included in Info Cubes

It can be used in DSO, Infoset and Char as InfoProviders. In this Info Provider , the char is not visible during read access (at run time)

Hyderabad Tirupati Bus

Buses from Hyderabad to Tirupati. Get Best Seats. Book Now!
www.travelyaari.com

This means, it is not available in the query. If the Info Provider is being used as source of Transformation or DTP the characteristic is not visible.

Wh ts a l p rio ? : a itbe at in A t S Piuigfc tbe A s s at al n p rio igt ipoete at inn o m rv h t p r r ac . o cn ef m n e y u a o p rio o l o 0 A MO T at in ny n C L N H t o 0I P . r F C E. S .

It is just for Display at Query and cannot be used for Drill downs while reporting.

T eew s nerrnti h r a a ro i hs gd e agt

About Me
Exclusive attributes: If you choose exclusively attribute, then the created key figure can only be used as an attribute for another characteristic, but cannot be used as a dedicated key figure in the InfoCube.
Ve m c m lt poi iw y o pee rfe l

Amazon Contextual Product Ads

While Creating A Key Figure -- The Tabpage:Additional Properties -Check Box for Attributies Only

Popular Posts
S PB B Itriw Q et n C niu d. A W Inev e u si s o t e .. o n . B :e l n ve T iaeq et n Ia e .f h v y lea ae n hs r u si s fc d Iu ae o a ysre sos o a yo eo teq et npoie n ce n h t fr n n f h u si rv o d ta o ea o 1 Weh v sa. ht n l . . s ae t. . S PB 7Itriw Q et n!! t R a Tm A I nev e u si s !Wi e l ie o ! h a po c .. p ra h. . B : h n i b ns g S uc : D Itriw r a d y C a dr a i u o re S N nev es n a n e teq et nwln t e a tesm , u f dte h u si o i o rm i h a e b t i h l n n p ten Bif f o r rfeB. atr. r o y u poi . e l . C m o Po u t nFi rs n o nee a B /B o m n rd ci aue E c u trd t W o l I Po u t nS p ot rd ci u p r o S m ayT iK o ld ebif ep B C nutns u m r hs n we g r h ls W o sl t e a a Q ikrfrn eg ie i sln C m lx s uc eee c ud ,n ov g o pe i po u t nI u s A to: eaa R d yT . rd ci s e, uh r D vkr e d a. o s . Wh D Pa dn tno a kg i S PB y T n o Ifp c ae n A I 70 o Df rn eb t e nD Pa d .? r iee c ew e T n f Ifp c ae no a kg S m ayT id c m n wlh l t u m r hs o u e t i ep o l u d rtn teb s ie o w yD P n esa d h ai d a f h T c rpa e I i B 70fro dn ted t t d t e l d P n I . o la ig h aa o aa c tres n d t. ag t a d aa. . Al A Sa d r R p rs lS P tn ad e ot N Bo dlvl e ot pin aaa l fr e ot o ra ee R p r O t s vibe o rp r o l e e uinT o eR m rs sdb R p r ae . xc t o c d e ak U e y e ot ra. .

0 comments

INFOCUBES - ULTIMATE SAP BIW CONCEPTS EXPLAINATION

Posted by Sharath Labels: BI, bi c ertific ation material, Extrac tion, INFOCUBE, sap BI, SAP bi c ertific ation material, SAP BI FAQS, SAP BI INTERV IEW QUESTIONS, sap bi stuff

Pages
Home S NB N WS D IE R a ieI u s elm s e T s

Deals

INFOCUBES - ULTIMATE SAP BIW CONCEPTS EXPLAINATION - y b "hia t M tyl S r nh uha " k a INFOCUBES - ULTIMATE EXPLAINATION INFOCUBE 1. INFOCUBE-INTRODUCTION: 2. INFOCUBE - STRUCTURE 3. INFOCUBE TYPES 3.1 Basic Cube: 2 Types 3.1.1 Standard InfoCube 3.1.2 Transactional InfoCube 3.2 Remote Cubes: 3 Types 3.2.1 SAP Remote Cube 3.2.2 General Remote Cube 3.2.3 Remote Cube With Services 4. INFOCUBE TABLES- F,E,P,T,U,N 5. INFOCUBE-TOOLS 5.1 PARTITIONING 5.2 ADVANTAGES OF PARTITIONING: 5.3 CLASSIFICATION OR TYPES OF PARTITIONING 5.3.1 PHYSICAL PARTITIONING/TABLE/LOW LEVEL 5.3.2 LOGICAL PARTITIONING/HIGH LEVEL PARTITIONING 5.3.3 EXAMPLES ON PARTITIONING USING 0CALMONTH & 0FISCYEAR

Feedjit

bisharath.blogspot.in

2/15

11/30/12

All about SAP BI....

5.3.3.1 ERRORS ON PARTITIONING 5.3.4 REPARTITIONING 5.3.4.1 REPARTITIONING TYPES 5.3.5 Repartitioning - Limitations- errors 5.3.6 EXAMPLES ON PARTITIONING USING 0CALMONTH & 0FISCYEAR 5.4 COMPRESSION OR COLLAPSE 5.5 INDEX/INDICES 5.6 RECONSTRUCTION 5.6.1 ERRORS ON RECONSTRUCTION 5.6.2 Key Points to remember while going for reconstruction 5.6.3 Why Errors Occur in Reconstruction? 5.7 STEPS FOR RECONSTRUCTION 5.8 ROLLUP 5.9 LINE ITEM DIMENSION/DEGENERATE DIMENSION 5.9.1 LINE ITEM DIMENSION ADVANTAGES 5.9.2 LINE ITEM DIMENSION DISADVANTAGES 5.10 HIGH CARDINALITY 6. INFOCUBE DESIGN ALTERNATIVES 6.1 ALTERNATIVE I : TIME DEPENDENT NAVIGATIONAL ATTRIBUTES 6.2 ALTERNATIVE II : DIMENSION CHARACTERISTICS 6.3 ALTERNATIVE III : TIME DEPENDENT ENTIRE HIERARCHIES 6.4 OTHER ALTERNATIVES: 6.4.1 COMPOUND ATTRIBUTE 6.4.2 LINE ITEM DIMENSION 7. FEW QUESTIONS ON INFOCUBES 1. INFOCUBE-INTRODUCTION: T ecnrl bet u o w i terp r a da a ss nB aeb sd h e t o jcs p n hc h e ot n n l e i W r ae a h s y aecldIfC b s w cnse a IfPo ies a IfC b i a r ae no u e & e a e n s no rvd r. n no u e s l mu ii nin l aasrcuea dast f e t n la l ta cnan ldme s a d t t tr n t o u e o rl i a tb s h t o ti ao e IfO jcs no bet. 2. INFOCUBE- STRUCTURESrcueo IfC b i cniee a E S t tr fno u e s o s rd s S u d E tn e Sa Sh ma S o F k Sh ma ta cnan xe d d tr ce / n w l e ce , h t o tis a 1F c T b at a l e nDme s nT b s i ni a l o e nS r g t I (I) a l ur ae D SD tb s o e nF c T b s at a l e nM se D t T b s atr aa a l e F c T b wt K yiue at a l i eFg rs e h nDme s nT b s i caatr t s i ni a l wt h rcei i o e h sc nS r g t I (I) a l l kM se d t tb s Heacy a l ur ae D SD tb si atr aa a l & irrh T b s o e n e e nM se D t T b s r t d p n e t n cnb sae b mu il atr aa a l ae i e me e e d n a d a e h rd y lp t e IfC b s M se d t tb cnan At b ts h t r ue fr no u e. atr aa a l o tis t iue ta ae sd o e r pee t ga dn vg t grp r i S PB sse rsni n a iai e ot n A (W) ytm. n n s 3. INFOCUBE TYPES:

Live Traffic Feed

A visitor from Bogot, Distrito Especial viewed "All about SAP BI....: SAP BI 7 Interview Questions!!!! With Real-Time approach...." 13 mins ago A visitor from Sampaloc, Rizal viewed "All about SAP BI....: Common Production Failures Encountered at BW / BI Production Support" 21 mins ago A visitor from Bangalore, Karnataka viewed "All about SAP BI...." 24 mins ago A visitor from Hyderabad, Andhra Pradesh viewed "All about SAP BI....: SAP BI 7 Interview Questions!!!! With Real-Time approach...." 24 mins ago A visitor from Taipei, Tai-pei viewed "All about SAP BI....: Writing a Virtual Characteristic or Key figure" 32 mins ago A visitor from Atlanta, Georgia viewed "All about SAP BI....: SAP BI 7 Interview Questions!!!! With Real-Time approach...." 1 hour 16 mins ago A visitor from Memphis, Tennessee viewed "All about SAP BI....: INFOCUBES ULTIMATE SAP BIW CONCEPTS EXPLAINATION" 2 hours 1 min ago A visitor from Europe viewed "All about SAP BI....: All SAP
Share it
Share this on Facebook Tweet this
View stats
(NEW) Appointment gadget >>

Interview
B s C b s eieo smeD t B s ai u e rs c d na aa ae R moeC b s eieo rmoesse e t ue R s d n e t ytm S Prmoecb rs e o oh r / Sse ue S P A e t u e ei s n te R 3 ytm ss A I d G n rle t C b rs e o n nS PSse ue B P e ea rmoe u e ei s n o A ytm ss A I d R moeC b wt evcs eieo n nS Psse e t u e iS ri rs e d n o A ytm 3.1. BASIC CUBE: 2 TYPES: T eeaep yi l a al l i tesme h s r hs ay v i b n h a cl ae B sse i w i te aeseie o ter t d t e i . W ytm n hc h y r p c id r h imea aa xs h f t 3.1.1. STANDARD INFOCUBE: FREQUENTLY USEDSa d r IfC b ae tn ad no u e r

Find company salaries, interview questions, reviews & office photos

www.jobiness.in

bisharath.blogspot.in

3/15

11/30/12

All about SAP BI....

cmmo &aeo t zdfr e dA cs, a eu d t rl , h t n b o n r pi e o R a ces h v p ae u s ta e a l mi e e t nfr t no S uc D t &l d cnb sh d l r somai f o re aa o s a e ce u d a o a e 3.1.2. TRANSACTIONAL INFOCUBE:T et nat n lno u e aen t h r sci a IfC b s r o a o f q e t ue a due o lb cr i a p ct n sc a S M &A O r u nl sd n sd n y et n p lai s uh s E e y y a i o P. D t aew i e drclit sc cb s yas gU d tR l aa r r tn i t no uh u e bp si p ae u s t e y n e 3.2. REMOTE CUBES: 3 TYPES:R moecb s eieo armoesse e t u e rs d n e t ytm. R moeC b s ah r td t f m oh r W sse , h t r e t u e g te mea aa r o te B ytms ta ae cniee a Vr a C b s T eeaetermoecb tp s o s rd s i u l u e. h s r h e t u e ye: d t 3.2.1. SAP REMOTE CUBE:tecb rs e o n nS PR 3sse & h u e ei s n o A / ytm d cmmu i t ni vatesri A I A I o nc i s i h evc P( P) ao e S 3.2.2. GENERAL REMOTE CUBE:C b rs e o n nS PR 3S uc u e ei s n o A / o re d Sse &cmmu i t ni vaB P. ytm o nc i s i A I ao 3.2.3. REMOTE CUBE WITH SERVICES:C b rs e o a y e t u e ei s n n rmoe d sse i . A o n nS P&i a al l vaue d f e fnt n ytm . S P r o A e s v i b i sr ei d u ci ae n o mo u . dl e 4. INFOCUBE TABLES- F,E,P,T,U,NTa scinC d : IT C E A rnat o o e LS S H M LS S H M > ne n meo teIfS uc O D C 3&E eue U o IT C E A e tr a f h no o re S _ 0 x ct. p n e euintepi r (at tb i dsl e a a u e p n e n d . x ct h r y F c) a l s i a d s n n x a d d o e o ma e py E p n ten d a dsetesre . x a d h o e n e h ce n T eeaetetb s ecnseu d r x a d dn d : hs r h al w a e ne epne oe e
P w rdb Bo g r o ee y lge.

5. INFOCUBE-UTILITIES 5.1. PARTITIONINGP r t nn i temeh do dvdn atb it at i ig s h io to f iiig a l no e mu il s lr id p n e t r e tdsg nsete cl ws o lp , mae,n e e d n o rl e e me t(i r o mn i r t e l a h u e rwws) ae o tef l a al l w i w u e a l aq i o i b sd n h i d v i b hc o l n b e es ae h d e uc k rfrnefr h itn e v l s f il i tetb . eee c o te ne d d a e o f d n h a l u es e F r at inn ad t st a l s a n 2p r t nn ci r o P r t ig aa e, te t mo g at i ig r ei io a io t a 0 A M N H&0 IC E mut etee CL O T FS P R s b h r. 5.2. ADVANTAGES OF PARTITIONING:P r t nn ao s o t at i ig lw yu o io l p r r p rll aara s f lp p r t n se dn u teq ey ef m aae d t e d o mu il at i s p e ig p h u r o l t e io e euinpoes x ct o rcs. B p r t nn a IfC b , h rp r n p r r nei e h ne y at i ig n no u e te e ot g ef ma c s n a cd io i o b cueii e s r osac i s lr a l , omane a c b cme ea s ts ai t e rh n mae tb s s e l e itn ne eo s muhe s r c ai . e Odd t cnb q i lrmo e b do pn ap r t n l aa a e uc y e v d y rp ig at i . k io yucnstpp r t nn i IfC b mane a c e t sp r t nn . o a eu at i ig n no u e itn ne xr > at i ig io a io 5.3. CLASSIFICATION OR TYPES OF PARTITIONING 5.3.1. PHYSICAL PARTITIONING/TABLE/LOW LEVELP yi l at inn hs a P r t ig c io a ocldtb / wl e p r t nn i rsr tdt Tme l ae a l l e l at i ig s et ce o i s l eo v io i C aatr t s n i d n a D t B s L v lo liteu d r ig h rcei i a d s o e t aa ae e e n f h n eln sc , y y d tb s ao s t aa ae lw i l . E : rc ,nomi,B , B / 9 x O al Ifr x IM D 2 3 0 e H r i acmmo w y f at inn i t ce t rn e.no u ecn ee s o n a o p r t ig s o rae a g s IfC b a io b p r t n do at sc l eTmeC aatr t s s e w e at i e n i le i i io me i k h rcei i a b l . sc o FS A Y A ( FS Y A ) IC L E R 0 IC E R FS A Y A V RA T 0 IC A N ) IC L E R A IN ( FS V R T FS A Y A / E ID0 IC E ID IC L E R P RO (FS P RO ) P S IGP RO ( FS P R ) O TN E IDO IC E 3 B ti p yi l at inn o d t cnb q i lrmo e b do pn y hs hs a p r t ig l aa a e uc y e v d y rp ig c io d k ap r t n at i . io

bisharath.blogspot.in

4/15

11/30/12
n t: op r t nn i BI ., xe t B (s t u p r ) oe N at i ig n .70 e cp D 2 a isp ot io s

All about SAP BI....

5.3.2. LOGICAL PARTITIONING/HIGH LEVEL PARTITIONINGL gcl oi a p r t nn i d n a M lC b ssv rlno u e jie it a at i ig s o e t u iu e(e ea IfC b s on d no io t M lC b ) r u irvd re e i . aa ag te e .nti cs u iu e o M lPo ie l l. D tT re l l i hs ae t t v e v rl e d t aesp rtd&jie it aM lC b . e td aa r e aae a on d no u iu e t H r TmeC aatr t s n i n t rsr t n a oyucnma e ee i h rcei i o l s o a et ci , l o a sc y i o s k p s ino P n&A ta d t, e in, uies raec oio n l t a cu l aa R go s B s s Ae t. n A v na e: d a tg s A p r h cne t M lC b ue p rllu -u r s ahe ig s e te o cp, u iu e ss aae sbq ei , civn t l e q ey efr ne u i tl u r p r ma c lmae . o t y L gcl at inn d n t o smea y d io a d t b s sae o i p r t ig o o cnu a io n a dt n l aa ae p c. i Wh nasbq ey i acnt u n IfPo ie, rd cdst f aa e u -u r ht o si e tno rvd r a e ue e o d t s t i l d dit s lrIfC b f m l g IfC b tre, v ni so e no mae no u e r a e no u e ag t e e n a l o r a sneo M lPo ie. be c f u irvd r t 5.3.3. EXAMPLES ON PARTITIONING USING 0CALMONTH & 0FISCYEART E EA ET H R R WOP R IINN C IE I: A TTO IG RT RA cl d r nh(C L O T ) a n a mo t 0 A M N H e f cle rp r d(FS P R i a ya/ ei 0 IC E ) s o A a isa c w cnp r t nad tst s go lo etp a n te t n ntne e a at i io aae ui n n ye mo g h n y a o et oci r : b v w r ei t a I od r oma ep r t n a l s o eo tet oIfO jcs s b n re t k at i , te t n f h w no bet mut e io a cnan di teIfC b . o tie n h no u e Iyuw n t p r t na IfC b uigtef cle rp r d f o a t o at i n no u e s io n h i a ya/ ei s o (FS P R caatr t , o h v t st h f cle r ain 0 IC E ) h rcei i yu a e o e te i a ya v r t sc s a caatr t t cntn. h rcei i o o sa t sc Atrat aigIfC b , at a l i ce tdo ted tb s wt o e f e ci t no u e fc tb s rae n h aa ae i n v n e h o ten mb r f at in cr so dn t tev l rn e f h u e o p r t s or p n ig o h a e a g . io e u Y ucnst h v l rn eyusl o a e te a ea g o re . u f P r t nn IfC b s s gC aatr t 0 A M N H at i ig no u e ui h rcei i C L O T : io n sc C o s tep r t nn ci r n0 A M N Ha dgv tev l rn e h oe h at i ig r ei C L O T n ie h a e a g io t o u a s Fo 0 .9 8 rm= 11 9 t= 22 0 o 1 .0 3 S h wma y at in aece tdatr at inn ? oo n p r t s r rae f p r t ig io e io 6yas 1 mo ts 2=7 p r t n aece td e r * 2 nh + 4 at i s r rae io 2p r t n fr a e ta l o tieo tern e me nn <0 .9 8 at i s o v l s h ta us io u y d f h a g , a ig 11 9 o > 22 0 . r 1 .0 3 Y ucna od tr n h wma y at in aece tda ama i m o a l eemie o s n p r t s r rae s io xmu o ted tb s fr h fc tb o teIfC b . n h aa ae o te at a l f h no u e e Y uco s 3 a tema i m n mb r f at in. o h oe 0 s h xmu u e o p r t s io R sln f m tev l rn e eu ig r h a e a g : t o u 6yas 1 cl d r nh +2magn l at in (pt 0 .9 8 f m e r *2 a n a mo ts e ria p r t s u o 11 9 , r io o 1 .0 3=7 s g v l s 22 0 ) 4 i l a e. ne u T esse go p tremo ts t t tg te i ap r t n h ytm ru s he nh a a i o eh rn at i me io 4Q atr P r t n =1Y a u r s at i s e io er S , yas 4p r t n/e r 2magn l at in =2 p r t n ae o 6 e r * at i sya + io ria p r t s 6 at i s r io io ce tdo ted tb s. rae n h aa ae T ep r r neg i i o lg ie fr h p r t n dIfC b ite h ef ma c an s n an d o te at i e no u e f h o y io t dme s no teIfC b i cni e t i me i ni f h no u e s o s tn. o s T i me n ta a v l s f h 0 A * h rcei i o ad t rcr i hs a s h t l a e o te C L caatr t s f aa eod n l u sc tet dme s nmut ie c oh r i ap r t nn va h i me i ni o s f ah te wt t h at i ig i io 0AM N H CL O T . N t: o cno lca g tev l rn ew e teIfC b d e n t oe Y u a n h n e h a e a g h n h no u e o s o y u cnana y aa o ti n d t. PARTITIONING INFOCUBES USING THE CHARACTERISTIC 0FISCPERM n aoy hn h r i S t h v l fr h 0 IC A N a d tr tig ee s e te a e o te FS V R T , u caatr t t cntn. h rcei i o o sa t sc 5.3.4. STEPS FOR PARTITIONING AN INFOCUBE USING 0CALDAY & 0FISCPER:A mii rtr rb nh d ns ao Wok e c t >no e mane a c IfS t itn ne > o b cc teIfC b d u l lk h no u e e i > dtno u e E iIfC b > h rcei i sre C aatr t s ce n sc > i C aatr t s a Tme h rcei i tb sc > xrs Et a >CS eic rp r e o IfO jc I p c i Po et s fno bet f i > t cueS eic rp r e da gb x Sr tr-p c i Po et s il o u f i o > p c y o sa t o tecaatr t 0 IC A N S ei cntn fr h h rcei i FS V R T f sc > ot u C ni e n >nteda gb xe tr h rq i dd ti I h il o ne te e ur eal o e s

bisharath.blogspot.in

5/15

11/30/12

All about SAP BI....

5.3.5. Partition Errors: Ffc tb s f at in dIfC b h v p r t n ta aee t, r at a l o p r t e no u e a e at i s h t r mpy o e io io tee t p r t n d n t a eacr so dn e t i terl e h mpy at i s o o h v io or p n ig nr n h e td e y a p ca edme s n ak g i ni . o S l in : h rq et A _ A TTO S IF _ E _ B h l yut o t 1 te e u s S P P R IIN _N O G T D 4 e s o o uo p a a z teepo l . h e t p r t n o tef at a l ae n l e h s rb ms T e mpy at i s f h fc tb r y e io e rp r d.na dt n tesse i u s nifr t nma a e Itee e ot I d io , h ytm s e a nomai e i s o n g .f h r i n cr so dn e t fr p r t ni teIfP ca edm s o or p n ig nr o a at i n h no ak g i e y io tb (rh n d. a l op a e ) e Wh nyucmpesdteafce IfC b , d tb s err curd e o o rse h f td no u e a aa ae r ocr e o e i do p r t n atr h ata cmpes n H w v r ti err a n rp at i , f te cu lo rsi . o e e, hs r w s io e o o n t e otdt tea p ct n T el s n teae o cmpes nd o rp r e o h p lai . h o i h ra f o rsi o i o g o n t i l a y r r n g s T eerrs o rp r di ted v l e o ds a n er ma a e. h r i n t e ot n h e e p r py o o e o t c (R N A TO S 5 ) tesse l ( R N A TO S 2 ) n r e T A S C IN M 0, h ytm o T A S C IN M 1 a d a g tejbo eve (R N A TO S 3 ) i e. h o v riw T A S C IN M 7 et r h T ea p ct ntik ta ted t i teIfC b i cr c, h d t h p lai hn s h t h aa n h no u e s or t te aa i o e o teafce rq et o p r t n i n t i l e i terp r n f h f td e u ss r at i s s o ds a d n h e ot g e io py i b cuete d n t a eacr so dn e t i tep ca e ea s h y o o h v or p n ig nr n h ak g e y dme s n i ni . o S l in : s terp r S P D O _ P R IIN < Z ) ormo ete o t 2 ue h e ot A _ R P F A TTO S / 1 t e v h uo op a e o e t p r t n f m teafce f at a l , s rh n d r mpy at i s r h f td fc tb s a io o e e d sr e i n t 1 0 7 7 t e sr ta ted tb s l t f 5 eci d n oe 3 6 4 , o nue h t h aa ae i o 2 5 b mi p r t n p r aa aetb i n t e ce u n csai. at i s e d tb s a l s o rah d n eesry io e l 5.3.6. REPARTITIONING:R p r t nn i ameh do p r t nn , sd e at i ig s io to f at i ig ue io fr cb w i i a e d p r t n dta h so d dd t. cu l P n o a u e hc s l a y at i e h t a l e aa A ta & l h r io a a d t v rin cmeh r. s ek o , h IfC b h s cu l aaw i aa es s o o ee A w n w te no u e a ata d t hc h i a e d l d da p r l d t atrp r t n Iw d rp r t n s l a yo e s e p n aa f r a a e at i .f e o e at i , io io ted t i tecb wl en t v i b / ted t d et d t aciig h aa n h u e i b o a al l lt aa u o aa rhvn l a e il o e ap r do t . v r ei f i o me Y ucnacs rp r t nn i teD t Wae o s gWokB nhuig o a ces e at i ig n h aa rh ui io n r ec s n A mii rtrC ne t e uo yu IfC b . d ns ao> o tx M n f o rno u e t 5.3.6.1. REPARTITIONING - 3 TYPES: A C mp t rp r t nn , ) o l e e at i ig e io B A dn p r t n t a efc tb ta i a e d p r t n da d ) d ig at i s o n at a l h ts l a y at i e n io e r io C M rige t o a s e t p r t n o a efc tb ta i ) egn mpy r l t mpy at i s f n at a l h ts mo io e a ed prt nd l a y at i e r io 5.3.7. REPARTITIONING - LIMITATIONS- ERRORS:S L2 0 p r t nn Q 0 5 at i ig io l tsu : r rnS 2 e ey n t a w rah dtel t o i i e er i M 1 v r miue s e e ce h i fr mi s o mi n mb r f at in p r Q 2 0 ( e 1 0 ) u e o p r t s e S L 0 5i . 0 0 io . 5.4. COMPRESSION OR COLLAPSE:C mpes nrd cs h n mb r f o rsi e ue te u e o o rcrs y o iigrcrs i tesmek y h t a b e l d di eod b cmbnn eod wt h a h e ta h s e n o e n a sp rt rq et. e aae e u ss C mpes ni cicla tecmpesdd t cnn l g r e td o rsi s r i , s h o rse aa a o o e d l e o ta n e f m teIfC b uigi rq etD . o mut ecr i ta te r h no u e s t e u s I' Y u s b et n h t h o n s s a d t l d dit teIfC b i cr c. aa o e no h no u e s or t a e T eue d f e p r t ni o lafcigtecmpesdEF c T b . h sr ei d at i s n f t h o rse -at a l n io y e n e B d fu FF c T b cnan d t. y ea l -at a l o tis aa t e B d fu S Paoae aR q etDfr ahp sigma e y ea l A lcts e u s I o e c ot t l n d. B uigR q etD w cnd l e sl t h d t. ys n e u s I, e a e t/e c te aa e e A w k o ta EF c T b i cmpesd&FF c T b i s e n w h t -at a l s o rse e -at a l s e u cmpesd no rse . Wh ncmpesd d t f m FF c T b t nfr dt EF c T b e o rse , aa r o -at a l r ser o -at a l e a e e a da terq etD ael t d l e /st on l n l h e u s I' r o / e td e t u. l s s e l Atr o rsin cmp rb tesaeue b EF c T b i l sr f cmpes , o aa l h p c sd y -at a l se e e o y e s ta FF c T b . h n -at a l e FF c T b i cmpesd ue BT A Id x s -at a l s o rse ss IM P n e e e EF c T b i u cmpesdue BT E Id x s -at a l s no rse ss -R E n e e e 5.5. INDEX/INDICES PRIMARY INDEXT epi r Id xi ce tda tmai l w e te h r y n e s rae uo t ay h n h ma cl tb i ce tdi ted tb s. a l s rae n h aa ae e SECONDARY INDEX(ohBt p&BTe aescn ay n i s Bt i ma -re r eo d r idc ) e Bt pid x s r ce tdb d fu o e c dme s ncl o afc i ma n e e ae rae y ea l n ah i ni o mn f at t o u tb al e &BTe idcs nA A tb s -re n i o B P a l . e e 5.6. RECONSTRUCTION:R cnt cini tepoes y hc yul d eo sr t s h rcs b w i o o u o h a d t it tesmecb / D o df rn cb / D f m P A T eman aa no h a u e O S r i ee t u e O S r f o S. h i p roei ta atr e t gterq et b C mpes n C lpeb up s s h t f d l i h e u ss y o rsi / oa s y e en o l a y n , oiw w n terq et ta aed l e (l n w w d n n o e s f e a t h e u ss h t r e td o / e ) e o ' e d t n e t g t suc sse o f t i s o clcigrq et, eg t e d o o o o re ytm r l fe fr oet e u ss w e a l l n

bisharath.blogspot.in

6/15

11/30/12

All about SAP BI....

te f m P A hm r o S. Reconstruction of a cube is a more common requirement and is required when:1 Aca g t tesrcueo acb :d l ino ) h n e o h t tr f u e e t u eo f caatr t sk y iue, e caatr t sk y iue ta cnb h rcei i / e f rs n w h rcei i / e f rs h t a e sc g sc g d r e f m e i igcask y iue ei d r v o xs n h r/ e f rs t g 2 C a g t u d t rl ) h n e o p ae u s e 3 M sigmatr aaa drq et a b e ma u l tre ge n) i n s se d t n e u s h s e n n ay un d re l o c matr aah s e nmanan da dl d dterq et ) h u ne se d t a b e itie n o e h e u s( so l a s d b rcnt ce . e eo sr td u 5.6.1. KEY POINTS TO REMEMBER WHILE GOING FOR RECONSTRUCTION:R cnt cinmut cu d r gp sigf e eo sr t u o s ocr ui ot r n n e p r d. ei s o U es s b l k d sr mut e o e . c T r n t a sh d l jb ta afc a p ct n emiae l ce u d o s h t f t p lai . l e e i o D at aetesat f S WV n u d t rp r e ci t h tr o R B 3 n p ae e ot v . 5.6.2. WHY ERRORS OCCUR IN RECONSTRUCTION?Err ocr n d e r s cu o l u o y t d cme t ot g ma ed r grcnt cinrn w i dsl s o ou n p si s d ui eo sr t u , hc i a n n u o h py icr c v l s nB b cuetel i o b fr a dAtrma e ae nor t a e i W, ea s h o c f eoe n f i g s r e u g e n l g r th o o e mac. n 5.6.3. STEPS FOR RECONSTRUCTIONTa scinC d s rnat o o e: L WE : OD T E T A TO : U T M ZN C C PT B L A A X R C IN C S O IIG O K I L WG : E E EC N E T O S T PT B E B D LT O T N S F E U A LS L WQ : E T Q E E B DLA UUD S 1 : P A ER Q E T / E O D M 3 U D T E U S SR C R S S Q : L A E T A T RQ E E M 1 CER XR C O UUS R A : W D L AQ E EM NT R S 7 B E T U U O IO S 3 / A 8 : E E EU D T L G E8S 3 D LT P A E O STEPS:1 M n aoy U e l k : . a d tr - sro s c 2 M n aoy (eo srcintb s fr p lain1 mut ee t) . a d tr - R cnt t a l o a p ct u o e i o 1 s b mpy E trt nat n- B &a p ct n=1 fr Dsl d cme t. ne r sci L WG a o p lai i o 1 o S a s ou ns e 3 D p n igo tesl tdu d t meh d cekb l q e e: . e e dn n h e ce p ae to , h c e w u u s e o S 1 eile o u -eile V u d t M 3 sr i d r nsr i d 3 p ae az az L WQ e aq e e B D l uud t Sat p aigted t f m teC so z gC cpt t nat n tr u d t h aa r h utmi n ok i( a sci n o i r o L WE o B )r sat h cr so dn a p ct nseic p aerp r R B 3 n(n tr te or p n ig p lai -p c i u d t e ot M WV n n e i o f =a p ct n n mb r drcl i t nat nS 3 / A 8. p lai i o u e) i t n r sci E 8 S 3 e y a o 4 E tr S 7&c a d l q e e o P A iicnan d t i q e e . ne R A l r e a u u s f S ,ft o tis aa n u u e t 5 L a d l d t f m R 3t B . o d e a aa r t o / oW 6 Sat h rcnt cinfr h d s e a p ct n . tr te eo sr t o te ei d p lai . u o r i o Iyuaecr igo t cmp t rcnt cin d l etecne t o f o r ar n u a o l e eo sr t , e t h o tns f y e u o e te cr so dn d t tres n yu B (u e a dO So jcs. h or p n ig aa ag t i o r W cb s n D bet) e 7 U eIirq et d l iia zt nwt d t t nfr o afl p a . s nt e u s (e a nt lai i aa r se) r u u l d t ii o h a l o t l dted t f m tercnt cinit B o o h aa r h eo sr t no W. a o u o 8 R nteR B 3 nu d t rp r a an . u h M WV n p ae e ot g i. 5.6.4. ERRORS ON RECONSTRUCTION:B l yucnsev r u err e w o a e ai s r s o o o o rcnt cin I a ra S PH l We s ea dS Na dfr l e a n eo sr t . h d e d A e u o p bi n C n omu td t a s l tei t ma etea de c, ay nu d rtn igtecne t i e h s o k h u ine e s i n esa dn h o cps mp s ERROR 1: Wh nI o l e rcnt cin R p ae d cme t ae e cmp td eo sr t , e e td ou ns r e u o cmig Wh? o n. y S l in T ercnt cinpo rms r ed t a dt e it test o t : h eo sr t uo u o rga w i aa d iv l no h et i y u tb s p al . e Iad cme ts nee t i f m tercnt cin ia oa p as f ou n i e trd wc r h eo sr t ,t l p e r e o u o s t i i test ptb . h rfr, h rcnt cintb s y wc n h e- a l T eeoe te eo sr t a l ma e u e u o e cnantesmed t f m yu cr n rcnt cina df m o ti h a aa r o o r ur t eo sr t e u o n r o pe iu rcnt cinrn ( r x mp , et) Iti d t i l d d rvo s eo sr t u s f e a l tss.f hs aa so e u o o e a it B yuwl say e mu il v l s nteq eis e cpin no W, o i uu l se lp a e i h u r (xe t : l l t e u e o K y iue i a O So jc w oeu d t i a v r r e ) e f rs n n D bet h s p ae s t o ew i . g t ERROR 2: Icr c d t i B frn iiu l ou ns o ap r do nor t aa n W, o idvd a d cme t fr ei f e o rcnt cinrn Wh? eo sr t u . y u o S l in D cme t w r p se d r gtercnt cin o t : ou ns ee otd ui h eo sr t . uo n u o D cme t ce tdd r gtercnt cinrnte e i i te ou ns rae ui h eo sr t u h n xs n h n u o t rcnt cintb s s e a i teu d t q e e. hs eu s nte eo sr t a l a w l s n h p ae u u s T i rsl i h u o e l t ce t no d p ct d t i B rai f u lae aa n W. o i E a l D cme t 7 1 q a t y 5 x mp : ou n 4 1 , u ni 1 e t D t i teP A aa n h S : R C N E D C M N Q A TT O A C L O U E T U N IY 4 1 1 d l , e rcr 7 1 5 e a n w eod t

bisharath.blogspot.in

7/15

11/30/12

All about SAP BI....

4 1 1 rcnt cin 7 1 5 eo sr t u o Q ey eu : u r rsl t 41 3 71 0 D cme t ta aeca g dd r gtercnt cinrndsl ou ns h t r h n e ui h eo sr t u i a n u o py icr c v l s nB b cuetel i o teb fr a datrma e nor t a e i W ea s h o c f h eoe n f i g s e u g e n l g r th o o e mac. n E a l D cme t 7 2 q a t y 0 i ca g dt 1 . x mp : ou n 4 1 , u ni 1 ,s h n e o 2 e t D t i teP A aa n h S : R C N E D C M N Q A TT O A C L O U E T U N IY X4 1 1 - e a b fr i g 7 2 0 d l , eoe ma e t 4 1 1 d l ,ma ea u 72 2 e a i g ns t 4 1 1 rcnt cin 7 2 2 eo sr t u o Q ey eu : u r rsl t 41 1 72 4 ERROR 3: Atr o p r r tercnt cina drsat h u d t, f yu ef m h eo sr t e o u o n etr te p ae yuf dd p ct d cme t i B o i u lae ou ns n W. n i S l in T ercnt cinin rs h d t i teu d t q e e. o t : h eo sr t g oe te aa n h p ae u u s A uo u o n wyce tdd cme ts nteu d t q e ea at gt nmi in e l rae ou n i i h p ae u u w in r s s o i a s it ted l q e e H w v r tercnt cina opoess hs no h e a u u . o e e, h eo sr t t u o l rcse ti s d cme t ea s i d t i a e d i ted cme t a l . h rfr, ou n b cue t aa s l a y n h ou n tb s T eeoe s r e yucnueted l iia zt no fl p a t l dtesme o a s h e a nt lai r u u l d o o h a t ii o l o a d cme t rm tercnt cina dwt tef s d l atr h ou n f o h eo sr t u o n i h i t e a f te h r t e rcnt cinit B eo sr t no W. u o Atr o p r r tercnt cina drsat h u d t, o f d f yu ef m h eo sr t e o u o n etr te p ae yu i n d p ct d cme t i B u lae ou ns n W. i S l in T esmea p it ; h r, h d cme ts nteu d t ot :h a uo s on 2 tee te ou n i i h p ae q e e h r,ts nted l q e e T ercnt cina oin rs aa u u , ee ii i h e a u u . h eo sr t t u o l g oe d t s i ted l q e e. nu d tdd cme ts nted l q e ea at g n h e a u u s A p ae ou n i i h e a u u w in t t i t nmi init B H w v r tercnt cinpoess hs r s s o no W. o e e, h eo sr t a s u o rcse ti d cme t ea s i d t i a e d cnan di ted cme t a l . ou n b cue t aa s l a y o tie n h ou n tb s s r e T eeoe yucnueted l iia zt no fl p a t l dte h rfr, o a s h e a nt lai r u u l d o o h t ii o l o a smed cme t rm tercnt cina dwt tef s d l atr h a ou n f o h eo sr t u o n i h i t e a f te h r t e rcnt cinit B eo sr t no W. u o ERROR 4:D cme t aaf m t o ted l iia zt nrq ets ou n d t r i o me f h e a nt lai e u s i t ii o mi igf m B sn r s o W. S l in T eR B 3 nu d t rp r w s o d at ae . s rsl o t : h M WV n p ae e ot a n t e ci td A a eu , uo v t d t f m teu d t q e eL WQo S 1 cnb ra w i ted t o aa r h p ae u u B o r M 3 a e e d hl h aa f e teiia zt nrq ets en u l d d H w v r s c n d l h nt lai e u s i b ig p a e . o e e, i e o e a ii o o n t q e e(e) xss nR A , h r i n tre fr hs aaa dii l t u u yt e i i S 7 tee s o ag t o ti d t n tso . t s 5.7. ROLLUPR lpce ts g rg ts na IfC b w e e e n wd t ou rae a ge ae i n no u e h n v r e aa l il dd so e . a 5.8. LINE ITEM DIMENSION/DEGENERATE DIMENSIONltes eo a fh i f z dme s no acb i moeta 2 %o ten r lat a l te w i ni f u e s r h n 0 f h oma fc tb , h n e o e d f eta dme s na aLn I m Dme s n ei h t i ni s ie t n o e i ni . o E : a s ou n N mb rno edme s ni S l C b . x S l D cme t u e i n i ni s a s u e e o e S l C b h s a s ou n n mb r n uu l tedme s ns e a s u e a sl d cme t u e a d say h i ni i e e l o z a dtefc tb s ewl etesme B t h nyua dteo eh a n h at a l i i b h a . u w e o d h v re d e z l o l k p fr I I/ I'tep r r newl ev r s w fo u s o DM D SD h ef ma c i b ey l . o s o l o B f g igi a aLn I m Dme s n tesse p t SDi teF c y l gn s s ie t a e i ni , h ytm us I n h at o T b ise do D I fr a s ou n N mb r a l nta f M D o sl d cme t u e. e e T i a od o el k pit dme s ntb . h s i nintb i n t hs v is n o u no i ni a l T u dme s o o e o al s o e ce tdi ti cs. h a v na ei ta yun t n sv sae rae n hs ae T e d a tg s h t o o o l a e p c y b cuetedme s ntb i n t rae b t ji i ma eb t e n ea s h i ni a l s o ce td u a on s d ew e o e tet otb s at SDtb (iga 3 ise do 3T b s at h w a l F c & I a l da rm )nta f a l F c, e e e Dme s n&SDtb s da rm 2 i ni o I a l (iga ) e B l i g i frlsrt np roeo l E SE tn e Sa Sh ma e w ma e s o i t i up s n ( S xe d d tr ce ) o l ao u y

bisharath.blogspot.in

8/15

11/30/12

All about SAP BI....

Dme s nT b , I I= r r K y i ni a l DM D Pi y e o e ma F c T b , I I-oeg K y at a l DM DF rin e e Dme s nT b Ln s at a l A dAG o pO Smi r h rcei i i ni a l ik F c T b n o e e ru f i l C aatr t s a sc E c Dme s nT b H s n DM D&2 8C aatr t s nE c R w ah i ni a l a O e I I o e 4 h rcei i I ah o sc 5.8.1. LINE ITEM DIMENSION ADVANTAGES: S v s p c b n t raigDme s nT b a e sae y o ce t n i ni a l o e 5.8.2. LINE ITEM DIMENSION DISADVANTAGES:O c aDme s ni ne i ni s o f g e a Ln I m, o cn o as d io a C aatr t s l g d s ie t Y u a n t s a dt n l h rcei i . a e i sc O lo ecaatr t i ao e p r ieI m Dme s n&fr F ) n n h rcei i s lw d e Ln t y sc l e i ni o o (4 h l teM se D t i dsl e , hc tk s r t . e , h atr aa s i a d w i a e moe i p py h me 5.9. HIGH CARDINALITY:IteDme s ne ce s 0 o tes eo te f h i ni xe d 1 % f h i f h o z fc tb , h nyuma eti a Hg C ria t Dme s n Hg at a l te o e k hs s ih adn ly i ni . ih i o C ria t Dme s ni o eta h s e ea p tnil curne. h n adn ly i ni s n h t a sv rl oe t ocr cs w e i o a e yuf gadme s na Hg C ria t, h d tb s i a jse o l a i ni s ih adn ly te aa ae s dutd o i acrig . codn l y B R Eid xi ue rte ta BT A id x B cuei g n rlite T E n e s sd ah r h n IM P n e , ea s n e ea f h , cria t i e p ce t e ce o ef t ta o afc tb ,ts adn ly s x etd o xe d n i h h t f at a l ii i f e a vsb t cekti f g d i l o h c hs l ae a N T : A cn et f m BT A id xt B R Eid xiw sl t O E S P ovr r s o IM P n e o T E n e f e e c e dme s na Hg C ria t. i ni s ih adn ly o i 6. INFOCUBE DESIGN ALTERNATIVES: R fr S PR 3B Se -ySe G ieb Ba F &H ny u ee: A / W tpb-tp ud y io u er F IfC b D s ntcnq e o h l u t rv a a tmai ca g s n no u e ei eh iu s f e s s o e e l uo t h n e i g p c teIfC b . h s a en t e ma b of e rgo /a s h no u e T ee l rai s y e f c/e in sl t v i e rpee tt e e rsnai . v 61 A T R A IEI :TM D P N E TN VG TO A A T IU E .. L E N TV I E E E D N A IA IN L T RB T S 62 A T R A IEI :DM N INC A A T RS ISM T O .. L E N TV I I E SO H R C E ITC E H D 63 A T R A IEI : I ED P N E TE TR HE A C IS .. L E N TV I TM E E D N N IE IR R HE I 64 O H RA T R A IE .. T E L E N TV : 641 C M O N A T IU E ... O P U D T RB T 642 LN IE DM N IN ... IE T M I E SO 7 F W Q E TO SO IF C B S . E U S IN N N O U E Wh t r IfC b s a ae no u e?

bisharath.blogspot.in

9/15

11/30/12

All about SAP BI....

Wh ts h srcueo IfC b ? a i te t tr fno u e u Wh t r IfC b tp s a ae no u e ye? AeteIfC b s aa ag t? o ? r h no u e D tT res H w Wh t r vr a C b sR moeC b s? a ae i u l u e(e t u e) t H wma y u e yuh dd s n d o n C b s o a ei e ? g Wh t r tea v na e o IfC b ? a ae h d a tg s fno u e Whc cb d S Pi l ns i u e o A mp me t? h e Wh t r IfC b tb s a ae no u e a l ? e Wh t r S pD f e Dme s n? a ae a ei d i ni s n o H wma y a l aefr dw e yuat aeteIfC b srcue o n tb s r ome h n o ci t h no u e t tr? e v u Wh t r teto o uit s f nIfC b ? a ae h o l r tie o a no u e s li Wh ts a t y a l p r t nn o a IfC b ? a i me n b tb at i ig f n no u e e io Wh ts a t y o rsino a IfC b a i me n b C mpes o f n no u e D yug fr at inn o C mpes n o o o o p r t ig r o rsi ? io o A v na e a dDsd a tg s f nIfC b p r t nn ? d a tg s n i v na e o a no u e at i ig a io Wh t a p n t EF c T b a dFF c T b iyuma ep r t no a h p e s o -at a l n e at a l f o e k at i n io a IfC b ? n no u e Wh d ug fr at inn ? y o o o p r t ig io Wh ts e at inn ? a i R p r t ig io Wh t r tetp s f e at inn ? a ae h ye o R p r t ig io Wh ts o rsin Wh yug fr o rsin a i C mpes ? y o o o C mpes ? o o Wh ts eo srcin Wh yug fr eo srcin a i R cnt t ? y o o o R cnt t ? u o u o Wh t r tema d tr se s od efcieerr rercnt cin a ae h n aoy tp t o f t e v r f o e eo sr t , u o w i g igR cnt cin hl on eo sr t ? e u o Wh t r teerr ocr uigR cnt cin a ae h r s cu d r o n eo sr t ? u o Wh ts ou o a IfC b ? a i R lp f n no u e l H wcnyume sr teIfC b s e o a o aue h no u e i ? z Wh ts ieI m Dme s n a i Ln t e i ni ? o Wh ts e e eae Dme s n a i D g n rtd i ni ? o Wh ts ihC ria t? a i Hg adn ly i H wcnyua a z ta tecb a aLn I m Dme s no o a o n l e h t h u e s iet y e i ni r o Hg C ria t? ih adn ly i Wh t r teIfC b d s na en t e? a ae h no u e ei l rai s g t v C nyue p i tea en t et d p n e t a iain l t iue a o x l n h l rai i a t v me e e d n n vg t a at b ts o r i IfC b d s n n no u e ei ? g C nyue p i tea en t edme s ncaatr t s nIfC b a o x l n h l rai i ni h rcei i i no u e a t v o sc ds n ei ? g C nyue p i tea en t et d p n e t ni heacis n a o x l n h l rai i a t v me e e d n e t e irrhe i r IfC b d s n no u e ei ? g Wh t r teoh r eh iu s fno u ed s na en t e a ae h te tcnq e o IfC b ei l rai s g t v Wh ts o o n At b t? a i C mp u d t iue r Wh ts ietm Dme s n Wi iafc d s nn a IfC b ? a i Ln I e i ni ? l t f t ei ig n no u e o l e g Wh t r tema i m n mb r f at in yucnce t o a a ae h xmu u e o p r t s o a rae n n io IfC b ? no u e Wh ts IT C E A a i LS S H M ? I a t osetetb s f nIfC b . o ?s h r a y rnat n w n t e h a l o a no u e H w I tee n Ta sci e o C d? oe Wh nteIfC b tb s rae ? e h no u e a l ce td e Aetetb s rae atr ciaino S vn teIfC b srcue r h a l ce td f at t e e v o r a ig h no u e t tr u ? Ddyui l ne R moe u e E p i metese ai? i o mp me td e tC b ? x l n e a h cn r o C nyucnie IfC b a Sa Sh mao E tn e Sa Sh ma a o o s rno u e s tr ce d r xe d d tr ce ? I R p r t nn a al l i BW 35o BI .? y s e at i ig v i b n . . r .70 Wh? io ae O w a b s yuas nC aatr t s oDme s n? n h t ai o si h rcei i t i ni s s g sc o
0 comments

Important Tables in SAP BI ( NW2004)

Posted by Sharath

A d db Au V rd rjn a snspcm d e y rn aa aaa , t d .a .o Lsigo cmmo lue tb s nS PB a dt u d rtn tew y aa i n fo t n sd a l i A I n o n esa d h a d t y e i soe i teb ce do S PB s trd n h ak n f A I Lse b l aesmeo tetb s o i dew r o t o f h a l cmmo lue i S PB ( W 2 0 ) e n sd n A I N 0 4 y - o e e tesmeh s o b e tse i N 0 4 a dp aema e hw vrh a a n t e n etd n W2 0 s n l s e k cr cin irq i d S meo ti maeil a g n tru hal o or t s f e ur . o e o e f hs tr h s o e ho g o f a t ee as eoema igit tef a lt n cu cnansmeo e yb l b fr l kn t o h i l s a d o l o ti o n i d lr d rfrne /icr c rfrne , o e e mot f h m h v b e eee cs nor t eee cs h w v r s o te a e e n e v l ae . a d td i

bisharath.blogspot.in

10/15

11/30/12

All about SAP BI....

Transfer Structure RT SS R T FE D S S IL R T R LS SSUE RA O T SR U T D 0T D3 Update Rules RUD O T SPR U RUD A SPD T RUDE S P KY R U DN O S P IF Embedded ABAP coding for Transfer / Update Rules RA BP SAA InfoPackage R L PO SD I R L PO S D IT RLPUE SD R L R L PE SD SL R M NC P S O ID R P KO SA P S ProcessChain R EE T H I S V N C AN R EE T E D SVN H A R EE T E D SVN H A T R P C AN SC H I R P C AN T R S C H IA T R P C AN S C H IT RPL G H I S C O C AN RPL G SC O S R P P O ESO SC R C SL G R P _ O IO S C M NT R Queries R Z L DR SET I Drcoy f h rp r n cmp n n e me t i tr o te e ot g o o e t l ns e i e R Z L T T T xs f e ot gcmp n n e me t SET X e t o rp r n o o e t l ns i e R Z L X E Drcoy f u r e me t eee cs S E T R F i tr o q ey l n rfrne e e R R E DR Drcoy f l e ot ( u r G N NI) SRPI i tr o a rp r Q ey E U I e l s D R Z O P I i coy f e ot gcmp n ns S C M DRDr tr o rp r n o o e t e i RZA G SR N E R Z L DR SET I S l t nseict nfr ne me t e ci p c i i o a l n e o fa o e Drcoy f h rp r n cmp n n e me t i tr o te e ot g o o e t l ns e i e R Z E E T S l t npo et s f ne me t SSLC e ci rp r e o a l n e o i e R Z O PC A s n n rue b cmp n n <>IfC b SC M I si me t e sa l o o e t - no u e g e R Z L P I Pir is i e me t oi o s S E T RO r ie wt l n cl in ot h e l s R Z L P O l n po et s st n s S E T R PE me t rp r e (et g) e i i R Z L A T t iuesl t np r i nine me t S E T T RAt b t e ci e dme s r e o o l n e RZAC SC L RZE SC L RZ L B SG O V D f io o afr l e me t ei t n f omu l n ni a e Q ey ein r Drcoy f es u r D s e: i tr o C l g e l Go a V r b s nR p r n l l ai l i e ot g b ae i E e t h i Poes gE e t a l v n C an rcsi v n T b n e H a e fr h e e t h i e d r o te v n can H a e fr h e e t h i e d r o te v n can Poes h i d ti rcs can eal s At b ts o aPoes h i t iue fr rcs C an r T xs o C an e t fr h i CosT b L gI /C anI rs-a l o D h i D e A p ct nL g fr h Poes h is p lai o s o te rcs C an i o L g fr h C anR n o s o te h i u s M ntrn iiu l rcs can o i idvd a poes h is o Ln s aao ret ifp ca e ik d tsuc o no ak g s IfP ca eT x D sr t n no ak g e t eci i po A A suc cd fr B P o re o e o IfP ca e no ak g s H rcd dsl t n i ado e e ci s n e o IfP ca e no ak g s C nan terq et dn mb r o tis h e u s- u e i b d t tre y aa ag t Ls o IfP ca eG o p / i fno ak g ru s t IfP ca e no ak g s A A suc cd p r bet B P o re o e e o jc ruie ot n U d t rl Ls p ae u s i e t U d t rl wt ruie p ae u s i o t s e h n U d t rl k y il p ae u e f d e es IfPo ie t Ifsuc no rvd r o noo re cr l in or a o et Ta se SrcueLs rnfr t tr i u t Ta se Srcuef l rnfr t tr i d u es Ta se Srcuerl rnfr t tr u s u e T x n meo Ta se R uie et a f rnfr o t n T x fr / Ta se srcue e t o R 3 rnfr t tr u O jcs bet

R P C AN V N S M lp E e t wt Poes h is S C H IE E T u il v ns i rcs C an t e h R P C M A D O Sse C mma dE euinL g (rcs C an) S C O M N L G ytm o n x ct o o s Poes h is

R P R N A IB E V r b s o Poes h is o R ni S C U V RA L S ai l fr rcs C an fr u t ae me

R Z H N E h n ehsoy f e ot gcmp n ns S C A G SC a g i r o rp r n o o e t t i

bisharath.blogspot.in

11/15

11/30/12

All about SAP BI....

Workbooks R R ID X S WBN E R R ID X S WBN E T RR SO E S WB T R Ls o bn r l g o jcs E cl ok o k) i f iaya e bet (xe w rb o s t r Tt s f iay bet (xe w rb o s ie o bn r o jcs E cl ok o k) l Soa efr iayag o jcs E cl ok o k) trg o bn r l e bet (xe w rb o s r

R R T M L T sin n o E cl ok o k a p ro a tmp ts S WB E P A EA s me t f xe w rb o s s esn le l e g a RR RB O S WO K O K Wh r-sdlt o rp r i w rb o s eeue i fr e ot n ok o k s s Web templates RZ B S WO J R Z BT T S WO J X R Z BX E S WO JR F R Z E PA E S WT M L T InfoObject R DO J S IB R DO J S IBT R DO J S IB R DO J S IBT RD T N V SA R A RD T N V SA R AT RDC A R SBH T RD H BS SC AA RD H SC A RD P SDA R DO J M S IBC P R KF SY RD I S TM RD N SU I InfoCube RD UE SC B RD UE S C BT R D U EO J S C B IB R D IE S DM R D IE S DM T R D I EO J S DM IB Drcoy fno u e i tr o IfC b s e T xs nIfC b s e t o no u e O jcs e IfC b ( h r-sdlt bet p rno u e w eeue i ) s Drcoy f i nin i tr o Dme s s e o T xs nDme s n e t o i ni s o IfO jcs o e c Dme s n( eeU e Ls) no bet fr ah i ni Wh r-sd i o t Drcoy f l no bet i tr o a IfO jcs e l T xs fno bet e t o IfO jcs Drcoy f l no bet i tr o a IfO jcs e l T xs fno bet e t o IfO jcs N vg t nAt b ts a iai t iue o r N vg t nAt b ts a iai t iue o r M se D t At b ts atr aa t iue r B s C aatr t s fr h rcei i ,i ai h rcei i ( C aatr t sTme c sc o sc C aatr t s a dU i ) h rcei i , n nt sc s C aatr t s aa g h rcei i C tl sc o D t P ca eC aatr t aa ak g h rcei i sc D p n e c s fno bet e e d ni o IfO jcs e K y iue e Fg rs TmeC aatr t s i h rcei i sc Ui nt s Soa eo teWe O jcs trg f h b bet T xs o T mp tsI msVe s e t fr e l e/t / iw a e Srcueo teB O jcs naT mp t t tr f h W bet i u e le a H a e T b fr W H M T mp ts edr al o B T L e l e e a

R D U E U T IfC b s n o e i aM lC b S C B M L I no u e iv l d n u iu e v t R DC U TIB M lPo ie: e cin Ie t i t no IfO jcs S IM L I J u irvd r S l t /d nic i fno bet O t e o fa o R DC A R S IH P O R DK F R S IY P O C aatr t Po et s p c i t a IfC b h rcei i rp r e S eic o n no u e sc i f F gPo et s p c i t a IfC b l rp r e S eic o n no u e a i f

R DC A IB IfO jcs f h SokV l i T b fr h IfC b S IV LO J no bet o te tc a dt a l o te no u e i y e

Aggregates R D A G DR SD G R I RD A G T SD G R RD A G T SD G L Drcoy f g rg ts i tr o A ge ae e T x o A ge ae e t n g rg ts Drcoy f h a ge ae, e t i tr o te g rg ts txs e R D A G C M D sr t no A ge ae S D G R O P eci i f g rg ts po

ODS Object RD DO SO S RD DO SO S T R D D OO J S O S IB RD DO AL SO S T B Drcoy f l D O jcs i tr o a O S bet e l T xs f l D O jcs e t o a O S bet l IfO jcs f D O jcs no bet o O S bet Drcoy f l D O jc T b s i tr o a O S bet a l e l e

R D D O T N VN vg t nAt b ts o O SO jc S O S A R A a iai t iue fr D bet o r

bisharath.blogspot.in

12/15

11/30/12

All about SAP BI....

PSA RTO S SS D Drcoy f l S T b s i tr o a P A a l e l e

DataSource (= OLTP Source) R OO RE O SUC R DLA O ET M H a e T b fr A B D tS ucs S PS uc e d r a l o S P W aa o re (A o re e Sse B Sse ytm/ W ytm) B D l Poe ue(A S uc Sse W e a rcd r S P o re ytm) t

R O T S U C R p ct nT b fr aa o re i B S L P O R E e lai a l o D tS ucs n W i o e

InfoSource RI SS R IT SS R IFE D SS IL Communications Structure RK SS C mmu i t n Srcuefrno o re wt o nc i s t tr o IfS ucs i ao u h F xb U d t l il p ae e e Drcoy fno o re wt F xb U d t i tr o IfS ucs i l il p ae e h e e T xs nIfS ucs i F xb U d t e t o no o re wt l il p ae h e e IfO jcs f nIfS uc no bet o a no o re

RK SS R K FE D S S IL R IFE D SS IL

C mmu i t n Srcue(iw fr t iue fr n o nc i s t tr Ve ) o At b ts o a ao u r IfS uc wt Drc U d t no o re i i t p ae h e T xs nIfS ucs i F xb U d t e t o no o re wt l il p ae h e e IfO jcs f nIfS uc wt F xb U d t no bet o a no o re i l il p ae h e e

Transfer Structure RT SS R OGN O SE Ta se Srcuei S PB rnfr t tr n A W u G n rtdO jcs o aD tS uc (rnfr e eae bet fr aa o re Ta se Srcue fr x mp i S PS uc Sse t tr, o e a l n A o re ytm) u e

Mapping R IO M P SS S A R O FE D A S S IL M P M p igB t e nIfS ucs n D tS ucs a pn ew e no o re a d aa o re (O T S ucs = L P o re) M p igB t e nD tS uc Fe s n IfO jcs a pn ew e aa o re il a d no bet d

InfoSpoke R BP KSLE SSO EEST R BP KVEST SSO ESLE IfS o eDrcoy n S l t nO t n no p k i tr a d e ci pi s e e o o IfS o eDrcoy i S l t nO t n a d no p k i tr wt e ci pi s n e h e o o V rinn es ig o Ls o a IfS o e wt at b ts itie i f l no p k s i t iue manan d t l h r wt t nat nR B w i ic d ten meo i r sci S O hc nl e h a h a o h u f teS uc &T re Srcue h o re ag t t trs u Ls o a IfS o e wt teS ot L n i f l no p k s i h h r & o g t l h D sr t n (n o eo teecnb manan d. eci i s o l n f h s a e itie ) po y C nan a temesg s h t a eb e rcre o tis l h l sa e ta h v e n eod d d r gtee euino a IfS o e T i tb ui h x ct n o f n no p k . hs a l e cn a b a d dt uigteA A CasM to irl e de o s n h B P l / eh d __ g s o > d _ymesg . a d s_ sa e

R BP K SSO E

R BP KT SSO E

R B T PD E S S S E IM S

SAP BW Statistics RD SA SDT T RD SA A G SDT T G R RD SA C N SDT T O D B s T b frno u e/ u r s ai a l o IfC b sQ ei c e e D tiT b fr g rg t S tp eal a l o A ge ae eu e IfC b C mpes n no u e o rsi o

R D S A A G D FD tiT b o N vg t nfr ahIfC b / u r S D T T G R E eal a l f a iai o e c no u e Q ey e o

bisharath.blogspot.in

13/15

11/30/12
RD SA DL S D T T EE R D S A WH SDT T M IfC b D l in no u e e t s eo Wae o s M n g me t rh ue a a e n

All about SAP BI....

Misc R FC SE B Fo tn C ek U eu fr h cigte W rne d h c. sflo cekn h isae S PG I es n o ue mahn s ntld A U v ri s n sr cie. l o IfP ca esl t na djbpo rm, h r i no ak g e ci n o rga tee n e o f l U D O Eteu d t sau i d P M D h p ae tts e ( I/ E T / U L I T D L A F L) N P AT b d l in S al e t e eo JbSh d l D f io o ce u ei t n e ni JbSh d l R sl o ce u eu e t M ntr esg s o i M sa e o C ekl dn err i tb h c o ig r s n a l a o e R p r V r b s iwtb e ot ai l ve a l ae e D v l e K y tb e e p r es a l o e Al rnat n i tesse l a sci s n h ytm T o Drcoy f h a ge ae i tr o te g rg ts e C nrl aa tr fr aat nfr rm te o t p rmees o d t r se f o a o h suc sse o re ytm O jcs nU e'F v r e bet i sr a oi s s t Ta scinC d s i T x rnat o o e wt e t h f l n me a dcr so dn d t e me t a s i d a s n or p n ig aa l n n me e e e D sr t no e c d t e me t eci i f ah aa l n po e Al A D f e T b N me l P ei d a l a s S n e D sr t no Al A D f e T b N me eci i f l P ei d a l a s po S n e

R SL O E SED N R PA E SS D L TT P BC TT O BC R M N ES SOMS RER RO SR O L G VR Z L B _ SG O V D V C ES EA C S TT SC R D A G DR SD G R I R IO P M OD C R S S E _U F M N B FC TT T SC D 0L D3 D 0L D 3T D 0L D2 D 0L D 2T

Web Item RZ TM S WIE R Z DT M S WM IE RZ TM RF S WIE X E RZ B S WO J R Z BT T S WO J X R Z BX E S WO JR F R Z E PA E S WT M L T H a e T b fr W We I ms edr al o B e bt e B We M td t: e l eI m ( aa rvd r W b ea aa T mp t t a e D tpo ie, I m, . ) t . . e . Cos eee c o We I ms rs R frne f b t e Soa eo teWe O jcs trg f h b bet T xs f e l e/tmsVe s e t o T mp tsI a e / iw Srcueo teB O jcs naT mp t t tr f h W bet i u e le a H a e T b fr W H M T mp ts edr al o B T L e l e e a

R Z I EO U F RB f r o Ta s t nM M R p t I S WM M IB F E uf fr rnl i I E e . o O e ao

Archiving R A C IR S R HP O R A C IR IB S R HP OO J R A C IR L C S R HP O O B Aciig G n rl rhvn Po et s W rhvn : e ea Aciig rp r e i B Aciig G n rl rhvn Po et s W rhvn : e ea Aciig rp r e i B A ciig G n rl oa Po et s W R hvn : e ea L cl rp r e i

R A C IR L C E W Aciig Acie D t Ae S R HP O O S LB rhvn : rhv d aa ra R A C IR PD S R HP O I RA C RQ SR H E R A C R Q IE S R H E FL S RA C RQ E S R H E SL B Aciig Po rm R frne o IfPo ie W rhvn : rga eee cs fno rvd r B Aciig AciigR q et W rhvn : rhvn e u s B Aciig V r f dAcieFl W rhvn : ef i rhv i s ie e B Aciig R q et e cin W rhvn : e u s- l t s Se o

Open Hub Destination R B H E VC T S O S R IE P O e H b S ri T p s p n u : evc ye e R B E U S D L A O e H b Cos eee c O to n /n o n SR Q ET ET p n u : rs R frne ub u d Ib u d RBE USM S S R Q E T E S O e H b L gfr R q et pn u: o o a eus R B E UD SR Q I R B E UD R S R Q I3 D R B E UD U S R Q IR N R BT U T R SS R C U E O e H b R q et p n u : e u ss O e H b Sau o 3dP r R q et p n u : tts f r at e u ss y O e H b T b wt Sau fr R q et p n u : a l i tts o a e u s e h O e H b G n rtdSrcue a dT b s p n u : e eae t trs n a l u e

bisharath.blogspot.in

14/15

11/30/12
0 comments

All about SAP BI....

Older Posts

S bciet: ot (tm u sr b o P ss Ao )
Copyright 2009 - A ll about SA P BI.... - is proudly presented by Free Blogger Templates Sm ashing Magazine - De sign Dise ase Popularize d by W atch Tv O nline Download Fre e W ordpre ss Te m plate s. Unblock through unblock m yspace prox y, Songs by Guitar Song C hords

bisharath.blogspot.in

15/15