SAP技术资料文档 -12 Designer 6.ppt

BusinessObjectsDesignerModule12:Using@Functions

HowTheCourseisOrganized:Day28.ResolvingLoopsinaUniverse9.Restrictions10.Using@Functions11.ListsofValues12.Hierarchies2Copyright?2004BusinessObjectsSA-AllRightsReserved

WhatYouWillBeAbleToDoKnowwhat@FunctionsareavailableNote:@AggregateAwareiscoveredlaterinthecourseBeabletoapplythemKnowwhat@Functionsdo3Copyright?2004BusinessObjectsSA-AllRightsReserved

The@FunctionsThe@Functionsavailableare:TheseFunctionsareappliedintheSelectandWhereboxesofobjectsTheyareusedtoprovideflexiblemethodsofspecifyingSQL4Copyright?2004BusinessObjectsSA-AllRightsReserved

@Prompt@PromptisplacedinanobjectaspartoftheSelectorWherepropertiesWhenaqueryisrunthatincludestheobject,the@promptoftheobjectforcesapromptboxtoappear5Copyright?2004BusinessObjectsSA-AllRightsReserved

@PromptSyntaxSHOWROOM.SHOWROOM_NAME=@PROMPTFreeorconstrained(tovalueinLoV)..Constrained‘EnterShowroomName’,Theprompt……………….‘A’,DataType(A,NorD)..….‘Showroom\Showroom’,LoVPointer..……………..Orhardcodedlist:{‘A’,‘B’,‘C’}Mono,Monoormulti(LoVselection)………..()Operatordependentonoperand6Copyright?2004BusinessObjectsSA-AllRightsReserved

@Select@SelectfunctionactsasapointertotheSelectboxofanotherobject:@Select(Class_Name\Object_Name)Createsadynamiclinkbetweenobjects,sothatupdateoftheoriginalobjectSelectstatementautomaticallyupdatestheotherobjects7Copyright?2004BusinessObjectsSA-AllRightsReserved

@WhereThe@WherefunctionactsasapointertotheWhereboxofanotherobjectCreatesadynamiclinkbetweenobjects,sothatupdateoftheoriginalobjectWhereclauseautomaticallyupdatestheotherobjectsorconditionobjects8Copyright?2004BusinessObjectsSA-AllRightsReserved

@Where-DesignerStrategyYoucancreateaClasscontainingonly