smart schema design-v1.0

8/10/2019 Smart Schema Design-V1.0

1/43


2/43

TA#$E %& C%NTENTS

' Intro"uction (

) $o**in* in +

( Entities An" ,oins -

+ Im!ortant Sc.ema &eatures /

0 Creatin* %b1ects '2 03 a3 Deletin*4Co!56aste an %b1ects '0 03 b3 Grou!in* %b1ects '-

03 c3 %b1ect 6ro!erties '/

7 Creatin* Attributes )8 73 a3 Settin* Attribute 6ro!erties ('

- 9niverse Creation (- -3 a3 To E"it Entit an" ,oins (/ -3 b3 Delete 9niverse +(

8 Im!ortant Consi"erations ++

2


3/43

'3 Intro"uction

Smart S(hema is a sensitive and important (omponent provided b! SmartStream te(hno%og! as a part o ,ransa(tion Lie(!(%e #anagement sot)arepa(+age and it p%a!s a vita% ro%e in hand%ing various +inds o re(on(i%iation.

,he ob'e(tive o this do(ument is to guide ,L# proessiona%s about variouseatures o Smart S(hema and its (ustomiation.

Ater reading this guide$ user shou%d be ab%e to (ustomie S(hema as per thebusiness reuirement.

3


4/43

)3 $o**in* in:

4 the ,L# sot)are is insta%%ed in !our ma(hine then go to Start menu and

se%e(t &rograms /5 Smart Stream ,e(hno%ogies /5 Smart S(hema.

4 the sot)are is insta%%ed in (%ients ma(hine and !ou have an a((ess to a(itri7 UL. Login and se%e(t ,L# Uti%ities /5 Smart S(hema.

Ater the app%i(ation is %aun(hed %ogin prompt )i%% appear in ront o !ou assho)n be%o):

Choose !our database t!pe 8e.g. 9ra(%e$ SL Server$ S!base or S!base 1;


5/43

C%i(+ Login button. 4 a%% the above detai%s are (orre(t%! entered$ Smart S(hema4ntera(e )i%% appear on the s(reen as disp%a!ed be%o):

;


6/43

Using 9ptions )e (an (hange the intera(e a((ess vie) as Norma% orAdministrator.

Using Administrator a((ess mode gives e7tra privi%eged to modi! propert! or

the produ(tied ob'e(ts and attributes.

6


7/43

(3 Entities an" ,oins:

=ntities and ?oins deine a universe. ,o see a universes entit! and 'oins vie)se%e(t the parti(u%ar universe and then (%i(+ @=ntities and ?oins tab right

beside the @9b'e(t and Attributes tab at the bottom o the (urrent s(reen assho)n be%o):

Bou (an go ba(+ to the universes hierar(hi(a% vie) again b! se%e(ting the@9b'e(t and Attributes tab.

e%o) is the @entities and 'oins vie) o a universe:


8/43

Components disp%a!ed in the be%o) pi(ture are:

ase tab%e tab%e )hi(h is the parent o a%% the other tab%es and bui%ds theirst 'oinEre%ationship )ith other tab%es )hi(h in turn are 'oined )ith severa%other tab%es. 4n this (ase it is item 84


9/43


10/43

03 Creatin* %b1ects:

Gor an! (reation or modii(ation in the S(hema$ it shou%d be in un%o(+ed mode.,o (hange the mode$ (%i(+ the Lo(+ button p%a(ed on the top o the %et side.As soon as )e (%i(+$ it (hanges to un%o(+ed mode as sho)n be%o):

4 !ou are going to (reate a ne) ob'e(t$ it must have ob'e(ts (reated in 4tem$#essage ,!pe$ #essage Feader and Case Summar! 8this universe is reuired ihand%ing (ases are a part o the business reuirement< universes.

,o (reate a ne) ob'e(t or %eve% steps are as be%o):

-o to 4tem universe:=7pand the 4tem Leve%$ !ou )i%% be ab%e to see some %eve%s area%read! present under 4tem %eve% e.g. Cash e(on(i%iations$ &ositione(on(i%iations et(. ,hese are produ(tied %eve%s (reated b! smartstream and read! to use.A%% the ob'e(tsE%eve%s have a hierar(hi(a% stru(ture as sho)n be%o):

10


11/43

,he %o)est %eve%s or the (hi%d %eve%s are a%so +no)n as Lea Nodes.

4n this (ase Credit Conirmation$ Debit Conirmation$ 9ur Cash Credit$ 9urCash Debit$ ,heir Cash Credit$ ,heir Cash Debit$ Credit euest and Debiteuest are %ea nodes as sho)n above.

,o (reate a ne) ob'e(t$=ither right (%i(+ 4tem %eve% and se%e(t @Add 9b'e(t option or se%e(t

the Add 9b'e(t i(on .

11


12/43

Name the ob'e(t o%%o)ing business (onvention. ,hen (reate (hi%d%eve%s or the ne)%! (reated %eve% in the simi%ar ashion as mentionedin step >.

Chi%d nodes ma! either represent a (reditEdebit 8or (ashre(on(i%iations


13/43

e.g.

Leve%s in 4tem Universe:

4n #essage Feader Universe:

4n #essage ,!pe Universe:

13


14/43

So %eve%s avai%ab%e or (reating message eed in re(on admin is ,heir CashConirmations

1>


15/43

03 a3 Deletin*4Co!56aste an %b1ect

An ob'e(t )ith one or more (hi%d ob'e(ts (ant be de%eted unti% its(hi%d ob'e(ts are de%eted.,o de%ete a %ead nodeE(hi%d ob'e(t$ either right (%i(+ and se%e(t the

Kde%ete ob'e(t propert! or use de%ete i(on .

Simi%ar%! to (op!Epaste a se%e(ted ob'e(t use (op! and paste

i(ons or use (op! paste option rom the menu ater a right (%i(+

on the se%e(ted %eve%.

1;


16/43


17/43

03 b3 Grou!in* %b1ects

A%% the ob'e(ts (reated under 4tem and #essage Feader universe must begrouped )ith the ob'e(ts (reated under #essage ,!pe universe.

-rouping pane is avai%ab%e 'ust be%o) the Attributes pane in the midd%e orea(h %eve%.

4t (an be done in both the )a!s.

=ither !ou group message t!pe ob'e(t )ith the (orresponding ob'e(t in 4temuniverse. ,his grouping %in+ )i%% automati(a%%! appear in the grouping pane orthe (orresponding ob'e(t under #essage ,!pe universe.

9r under #essage ,!pe Universe$ or the ne)%! (reated Lea NodeE9b'e(tgroup the (orresponding ob'e(t o 4tem and #essage Feader universe in the-roupings pane. ,hese grouping %in+s )i%% automati(a%%! appear in both 4temand #essage Feader Universe or the (orresponding %eve%s.

Usage: -rouping is use u%% )hen !ou are going to use -eneri( #essage#aintenan(e un(tiona%it! or !our ne)%! (reated #essage t!pes.A%so it he%ps %in+ing the items %oaded into item tab%e )ith #essage Feader and#essage Geed tab%e )hi(h he%ps in %oading data and re%oading it using -eneri(#essage #aintenan(e 8i eed goes in 9perator 4ntervention


18/43

Simi%ar%! a%% (ase %eve%s present in Case Summar! universe (an be grouped orthe parti(u%ar %eve% in #essage ,!pe. 4t deines )hi(h t!pes o (ase (an beraised on a parti(u%ar item %oaded or the parti(u%ar #essage eed 8or messaget!pe %eve%


19/43

03 c3 %b1ect 6ro!erties:

9b'e(ts properties govern the behaviour o the items %oaded or theparti(u%ar ob'e(t in ,L# )eb (onne(t as )e%% as re(on admin.

! deau%t S(hema disp%a!s on%! (he(+ed properties or an ob'e(t. ,o see a%%

the properties avai%ab%e or se%e(tion$ the (he(+bo7 i(on (an beun(he(+ed.

Note: 9b'e(t properties are not inheritab%e i.e. the! dont get inheritedrom the parent %eve% ob'e(t to its (hi%d %eve% ob'e(t. 9n%! those properties)hi(h are assigned to an ob'e(t )i%% depi(t the behaviour o it.

9b'e(t &roperties pane is avai%ab%e 'ust in the midd%e o the intera(e aboveAttributes pane. 4 !ou se%e(t a parti(u%ar ob'e(t$ properties or that ob'e(t

)i%% appear in the properties pane and (an be set as per the reuirement.

a3=a(h %ea node or )hi(h data needs to be %oaded in the database musthave the o%%o)ing properties set in Item universe:

Item Si"e / Side depi(ts that )hether the item %oaded or this %eve% )i%% betreated as 9urs 8Ledgers< or ,heirs 8Statements


20/43

-enera%%! Credit and Debit (omes or (ash items and unassigned is used orboth se(urit! position items.

Action 4t depi(ts the sign o the amount. 4t is used b! ,L# )hi%e eva%uating

aggregate un(tions %i+e N=, or N=,&=C=N, upon the amount attributes.,he sign )i%% be appended to the amount va%ue and then it )i%% be netted.

Note:4t is not app%i(ab%e to a%% aggregate un(tions %i+e SU# doesnt ma+euse o sign mentioned in the A(tion propert!.

Gor our side items 8or )hi(h Side is L< A(tion used is and or their sideitems 8Gor )hi(h Side is S< A(tion is .

Above mentioned properties are the mandator! properties need to be set

or a Lea NodeEChi%d %eve% ob'e(t in 4tem universe. Apart rom these$ someoptiona% properties a%so (an be set as reuired 8in 4tem universe


21/43

b3,here are no properties to be set in Messa*e Hea"eruniverse.

c34n Messa*e T!euniverse$ o%%o)ing properties must be set or those ne)%!(reated %ea node or )hi(h message eed )i%% be (reated and data )i%% be

%oaded into database.

4 !ou are going to use -eneri( #essage #aintenan(e un(tiona%it! or !our ne)message t!pes$ then o%%o)ing properties must be (he(+ed or the(orresponding %ea node in #essage ,!pe universe:

Generic Manual In!ut ; Ma< Rows ; 4 this propert! is set$ it te%%s the ma7imumnumber o ro)s permitted in -eneri( #anua% 4nput or an ob'e(t.

Generic Manual In!ut ; View -enera% #anua% 4nput is avai%ab%e or thisob'e(t.

Mt!e is the Lea Node va%ue o the ob'e(t in 4tem universe )hi(h is grouped)ith the se%e(ted ob'e(t o #essage ,!pe universe.

#t!pe is set to 1001H )hi(h is the LNV o this ob'e(t in 4tem universe:

21


22/43

e%o) properties governs the message eed properties in re(on admin:

Messa*e &ee" A"min ; c.ec=>"u!licate>item iel" enable" ; 4 )e (he(+ thispropert!$ it enab%es the @Che(+ Dup%i(ate 4tem (he(+bo7 )hi%e (reating amessage eed in e(on Admin as sho)n be%o):

22


23/43

Va%ue 1 ma+es the (he(+bo7 auto (he(+ed )henever a message eed is (reated.

Messa*e &ee" A"min ; collect>stats iel" enable" 5 4 )e (he(+ this propert!$it enab%es the @#4S Statisti(s (he(+bo7 )hi%e (reating a message eed in e(onAdmin as sho)n be%o):

Va%ue 0 represents the (he(+bo7 )ont be auto se%e(ted but enab%ed to bese%e(ted i reuired.

23


24/43

Messa*e &ee" A"min ;loa">a"visor iel" enable" 5 4 )e (he(+ this propert!$it enab%es the @Advisor! 4tems 9n%! (he(+bo7 )hi%e (reating a message eed ine(on Admin as sho)n be%o):

Messa*e &ee" A"min ;over>inbrco"e iel" enable" 5 4 )e (he(+ this propert!$it enab%es the @4tem 9verrides Deau%t (he(+bo7 )hi%e (reating a messageeed in e(on Admin as sho)n be%o):

2>


25/43

Messa*e &ee" A"min ; !ro!osal>tri**erin* iel" enable" 5 4 )e (he(+ thispropert!$ it enab%es the @&roposa% ,riggering dropdo)n )hi%e (reating amessage eed in e(on Admin as sho)n be%o):

2;


26/43

Messa*e &ee" A"min ; stmt>re? iel" enable" 5 4 )e (he(+ this propert!$ itenab%es the @Statement Gre dropdo)n )hi%e (reating a message eed ine(on Admin as sho)n be%o):

Messa*e &ee" A"min ; stmt>source iel" enable" 5 4 )e (he(+ this propert!$it enab%es the @Statement Sour(e dropdo)n )hi%e (reating a message eed ine(on Admin as sho)n be%o):

26


27/43

Messa*e &ee" A"min ;Value o balance>t!e 5 4 )e (he(+ this propert!$ itdoesnt enab%e but popu%ates the @a%an(e ,!pe ie%d )ith a va%ue )hi%e(reating a message eed in e(on Admin as sho)n be%o):

Va%ue 0 represents No a%an(es$Va%ue 1 represents Curren(! a%an(esVa%ue 2 represents ,ransa(tions a%an(esVa%ue 3 represents &ositions a%an(es

2


28/43


29/43

9b'e(t at (hi%d %eve% inherit a%% the attributes o their parent %eve%under )hi(h the! have been (reated.Sin(e ob'e(ts at the same %eve% do not inherit ea(h others attributes$so ob'e(ts at the same %eve% (an use same ie%d or mapping.4n this (ase$ to optimie the s(hema stru(ture$ it is preerab%e to add

a%% the (ommon attributes among the same %eve% ob'e(ts at a(ommon parent node.

Caution: Jhi%e overriding a ie%d mapping$ !ou shou%d ta+e (are that itis not (reating an! ambiguit! or ,L# i.e. i same ie%d is avai%ab%e )ithdierent names ater inheritan(e or an ob'e(t then it might (reate(onusion or ,L# )hi%e using this attribute or bui%d in e(on Admin.

Attributes are inheritab%e rom parent nodes. Fen(e a%% the (ommonattributes or %edger and statement %eve% (an be added to the parent %eve%and )i%% be inherited b! %ea nodes.

Note: Bou (annot add attributes to the %eve%s in #essage ,!pe universe.

,o add an attribute$ use o%%o)ing steps:

Un%o(+ S(hema using button.

Se%e(t 4tem universe rom the Universe se%e(tor pane situated at thever! %etmost o the S(hema intera(e.

,hen se%e(t the desired ob'e(t %eve% or )hi(h !ou )ant to add theattributes.

4 the Attributes pane is (o%%apsed$ e7pand it using .

4 a%read! attributes are present$ s(ro%% to the bottom o the paneand at the end. An empt! ro) )i%% be avai%ab%e.

No) either !ou (an (reate an attribute se%e(ting the ie%d rom the

avai%ab%e ie%ds dropdo)n 9 (an (op! attribute rom an ob'e(t

)here the desired ie%d is a%read! deined using (op! button and

then paste it to !our se%e(ted ob'e(t %eve% using paste button .

,o de%ete an attribute use o%%o)ing steps:

2H


30/43

Un%o(+ S(hema using button.Se%e(t 4tem universe rom the Universe se%e(tor pane situated at the

ver! %etmost o the S(hema intera(e.

,hen se%e(t the desired ob'e(t %eve% or )hi(h !ou )ant to add theattributes.

4 the Attributes pane is (o%%apsed$ e7pand it using .,hen se%e(t the attribute )hi(h !ou )ant to de%ete and (%i(+ de%ete

button.

Note: 4 a%read! some data is %oaded or the parti(u%ar ob'e(t$ then !oumight not be ab%e to de%ete the attribute dire(t%!. 4n su(h (ase$ irst removegrouping o the se%e(ted ob'e(t rom grouping pane. Ater that attribute (an bede%eted$ but dont orget to add the grouping again. ,hen %o(+ the s(hema.

30


31/43

73 a3 Settin* Attributes 6ro!erties

Attribute properties govern the behaviour o an attribute in e(on Admin$Smart Studio and )eb (onne(t.Attribute &roperties pane is situated at the rightmost (orner o the S(hema

intera(e as high%ighted )ith a b%a(+ ba(+ground in the be%o) pi(:

4 !ou (reate an attribute b! se%e(ting rom the avai%ab%e ie%ds dropdo)n$ thenthere )ont be an! properties set b! deau%t.ut i !ou have (opied an attribute rom -eneri( 4tem temp%ate %eve% andpasted it to !our ob'e(t %eve%$ then it )i%% have some deau%t settings orattribute properties.

Go%%o)ing are the properties need to be set or an attribute re%ated todashboard grids:

Das.boar"s ; E"itable ; 4 this propert! is (he(+ed$ then the attribute )i%% beeditab%e in )eb/(onne(t dashboards.

Das.boar"s ; View ; Dis!laable ; ,his propert! must be (he(+ed to ma+e theattribute avai%ab%e )hi%e (reation o dashboard in Smart Studio.

Das.boar" totals ; Met.o" ; 4 this propert! is (he(+ed$ then this attributeparti(ipates in grid tota% (a%(u%ation other)ise not. 4 the va%ue or this

31


32/43

attribute is set to 1$ a norma% sum )i%% be app%ied to this attributes va%uesother)ise norma% netting (a%(u%ation )i%% happen or the se%e(ted items in thedashboard 8in )eb (onne(t


33/43

Go%%o)ing are the properties )hi(h governs the avai%abi%it! o an attribute indierent events in e(on Admin:

Events ; Create Case ; Available 5 4 this propert! is (he(+ed the attribute )i%%be avai%ab%e in Create Case event.

Events ; Create Data ; N%T Available 5 4 this propert! is (he(+ed the attribute)i%% not be avai%ab%e in Create Data event.So ma+e sure this propert! shou%d not be (he(+ed i !ou are going to use thisattribute in Create Data event.

Events ; E"it ; Available 5 4 this propert! is (he(+ed the attribute )i%% beavai%ab%e in =dit events.

Events ; Resolve Case ; Available 5 4 this propert! is (he(+ed the attribute)i%% be avai%ab%e in eso%ve Case event.

Events ; Sto!4Abort ; Available 5 4 this propert! is (he(+ed the attribute )i%%be avai%ab%e in StopEAbort event.

Events ; arn ; Available 5 4 this propert! is (he(+ed the attribute )i%% beavai%ab%e in Jarn event.

,he be%o) properties are set )hen business reuires message maintenan(e and

manua% input un(tiona%it! through dashboards:

33


34/43

Closin* balance or GMI .ea"er/ App%i(ab%e to de(ima% t!pes o (o%umns i.e.amount ie%ds. &rovides -#4 )ith the (%osing ba%an(e amount attribute or ons(reen ba%an(e (a%(u%ations )hi%e entering data in -#4.

Generic Manual In!ut ; Dis!laable 4 (he(+ed$ attribute )i%% be visib%e in-#4 (ontro%.

Generic Manual In!ut ; E"itable/ 4 (he(+ed$ attribute )i%% be editab%e in -#4(ontro%.

Generic Messa*e Maintenance ; Dis!laable/ 4 (he(+ed$ attribute )i%% bevisib%e in -## dashboard.

Generic Messa*e Maintenance ; E"itable/ 4 (he(+ed$ attribute )i%% be

editab%e in -## dashboard.

Man"ator 4 (he(+ed$ attribute 8ie%d< )i%% be mar+ed as mandator! in -#4and -## (ontro%s.

Nettin* iel" or GMI balance 4 (he(+ed$ this attribute )i%% (ontribute to theon s(reen ba%an(e (a%(u%ation in -#4.

%!enin* balance or GMI .ea"er/ App%i(ab%e to de(ima% t!pes o (o%umns i.e.amount ie%ds. &rovides -#4 )ith the opening ba%an(e amount attribute or on

s(reen ba%an(e (a%(u%ations )hi%e entering data in -#4.

3>


35/43

Under Miscellaneous cate*or)e have a propert! (a%%ed %!tional Au"it ,hispropert! is app%i(ab%e to those attributes )hi(h are used in edit events anddont )ant to be tra(ed through Audit trai% 8a )eb (onne(t uti%it! )hi(hdisp%a!s a %og o events happening on the se%e(ted item in a dashboard


36/43

6asses ; Rule BA**re*ate ualit ; Available 4 (he(+ed$ attribute )i%% beavai%ab%e at the parti(u%ar %eve% or aggregate ua%it! ru%e (reation in e(onAdmin.

6asses ; Rule BMatc. ualit ; Available 4 (he(+ed$ attribute )i%% beavai%ab%e at the parti(u%ar %eve% or pass ua%it! ru%e (reation in e(on Admin.

6asses ; Rule B6o!ulation ; Available 4 (he(+ed$ attribute )i%% be avai%ab%eat the parti(u%ar %eve% or popu%ation ru%e (reation in e(on Admin.

6asses ; Rule BSco!e ; Available 4 (he(+ed$ attribute )i%% be avai%ab%e at theparti(u%ar %eve% or s(ope ru%e (reation in e(on Admin.

Rules ; Access ; Available / 4 (he(+ed$ attribute )i%% be avai%ab%e at the

parti(u%ar %eve% or a((ess ru%e (reation in Smart Studio.

Rules ; Grou! ; Ri*.t .an" Si"e 5 Available/ 4 (he(+ed$ attribute )i%% beavai%ab%e at the parti(u%ar %eve% or a ru%e (reation )or+s on a group o items.

Rules ; Searc. ; Available / 4 (he(+ed$ attribute )i%% be avai%ab%e at theparti(u%ar %eve% or sear(h ru%e (reation in Smart Studio.

Rules ; Searc. ; Ri*.t .an" Si"e 5 Available / 4 (he(+ed$ attribute )i%% beavai%ab%e or right hand side o sear(h ru%e (reation in Smart Studio.

Rules ; or=low ; Available/ 4 (he(+ed$ attribute )i%% be avai%ab%e at theparti(u%ar %eve% or )or+%o) ru%e (reation in e(on Admin.

Rules BConstraints ; Available/ 4 (he(+ed$ attribute )i%% be avai%ab%e at theparti(u%ar %eve% or (onstraint ru%e (reation in Smart Studio.

36


37/43

-3 9niverse Creation

Sometimes )e (reate vie)s 'oining e7isting tab%es in database and )riteba(+end s(ripts to popu%ate these vie)s based on business reuirements.

,o ma+e the data o this vie) avai%ab%e or ront/end user$ it is reuired tobui%d a dashboard. ,o ma+e a dashboard )e need to se%e(t a parti(u%ar universeand then the %eve%.

4n that (ase$ )e (reate a ne) universe using our (ustomied vie)s or 'oininge7isting tab%es in the desired )a!.

,o (reate a ne) universe use this i(on p%a(ed in the too%bar 'ust be%o) theUniverse Se%e(tor tab as sho)n be%o):

Jhen )e se%e(t this button be%o) prompt appears on the intera(e s(reen assho)n be%o):

3


38/43

&rovide a name or !our ne) universe.Se%e(t suitab%e produ(t t!pe$ this is 'ust to (ategorie the universesbased n the produ(t t!pe.,hen !ou must se%e(t a base entit!. 4t (an either be !our o)n vie) oran e7isting tab%e )hi(h !ou )ant to use as the base entit! in !our'oin strateg!.9n(e !ou (%i(+ o+ here$ !ou )i%% be dire(t%! moved to the =ntit! and

?oin page o !our ne) universe.4 it is on%! one vie)$ it )i%% disp%a! the avai%ab%e attributes. Bou (an'oin more entities i reuired.

3"


39/43

-3 a3 To E"it Entit an" ,oin

,o add a ne) entit! se%e(t an entit! rom the avai%ab%e entities %ist and use add

entit! button as sho)n be%o):

A re(tangu%ar bo7 )i%% appear in the b%an+ spa(e )here a%read! !ourbase entit! is present. 4 !ou (%i(+ on the entit! !ou )i%% be ab%e todeine its a%ias as sho)n be%o):

,his a%ias is useu% )hi%e deining the 'oin properties. 4 !ou )ant !ou

(an de%ete an entit! using button visib%e in the above pi(ture.

3H


40/43

ut i the entit! is 'oined )ith some other entit!$ it (ant be de%eted.Girst !ou have to de%ete the 'oin b! right (%i(+ing on the 'oin %ine andse%e(t option @De%ete ?oin as sho)n be%o). 9n(e the entit! is ree oa%% 'oins then that entit! (an be de%eted. Ater a%% the entities arede%eted$ universe (an be de%eted in turn.

,hen to 'oin this ne) entit! )ith !our base entit!$ (%i(+ on the base

entit! and start dragging !ou )i%% see a %ine )i%% appear drag it up tothe ne) entit!.

,hen (%i(+ on the %ine appeared (onne(ting both the entities andse%e(t the mapping attribute in the ?oin #appings pane situated 'ustabove Avai%ab%e =ntities pane as sho)n be%o):

>0


41/43

&arent (o%umn is the attribute o the base entit! and (hi%d (o%umn isthe attribute o the entit! )hi(h is 'oined )ith the base entit!. Bou

(an de%ete the 'oin mapping using the de%ete button sho)n inthe above pi(ture.

#ention the t!pe o 'oin in the ?oin &roperties pane situated abovethe ?oin #apping pane as visib%e in the above pi(ture.4 !ou )ant it to be an inner 'oin se%e(t @9n%! #at(hing oth optionunder the ,!pe se(tion.4 !ou )ant an outer 'oin$ se%e(t rom )hi(h tab%e !ou )ant it to. Assho)n above i it is @A%% romKd )i%% be an outer 'oin se%e(ting a%%re(ords rom d(od tab%e here d is the a%ias spe(iied or this tab%e.Deine )hether the 'oin has to be a mandator! or an optiona% one.

>1


42/43

,hen move to 9b'e(ts and Attributes tab. ase tab%e attributes )i%%be %isted in the Attributes pane$ a((ording%! the properties (an be setor ea(h o the attribute.

-3 b Delete 9niverse

,o de%ete a Universe$ a%% the entities have to be removed rom =ntities and

'oins tab. ,hen use de%ete button to de%ete the universe. De%eteuniverse button (an be ound on the too%bar situated 'ust be%o) theUniverse Se%e(tor tab as sho)n be%o):

>2


43/43

83 Im!ortant Consi"erations:

Jhenever )e do an! s(hema modii(ation )hi(h ae(ts SmartStudioEJeb Conne(t$ )e need to restart the )eb server in order tosee the (hanges in Smart StudioE Jeb Conne(t.ut i )e do on%! those (hanges )hi(h ae(t attributes avai%abi%it! ine(on Admin$ then need not restart the )eb server to see the(hanges$ instead %ogout and re/%ogin to e(on Admin )or+s.Ater modi!ing S(hema$ do not orget to use %o(+ button to %o(+ thes(hema.

END

smart schema design-v1.0

Documents