Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For what and When do we use this brackets in SET Analysis,
( )
< >
[ ]
{ }
Thanks & Regards,
( ) = using for functions, Exp: Sum(Sales),Here Sum is function.
< >,{ } = using for expression.when u will start writting expression by using Set Analysis first {< exp> }
Exp : {<Year={$(vMaxYear)}>}
[] = Using for Field Name,If there is a gap between any FieldName,then u need to put field name in [ ]. Exp : [Product Code]
Exp of all brackets:
Sum({<Year={$(vMaxYear)}>},[Product Code]={AA001} Sales)
Regards-Bika
( ) not by themselves except in what is called dollar sign expansion
- this is where you refer to a variable $(varName) or a formula $(=x+y)
< > at the beginning and the end of the whole set, in the format {<....>}
[ ] around field names when they have spaces in them, e.g. [Order Number]
{ } at the beginning and the end of the whole set (see <> above). Also as the beginning and end of additional subsets
There are plenty of good references about set analysis that will explain this to you. See this post for a summary and some files. I would suggest looking at these and building knowledge from the ground up instead of trying to reverse engineer some existing code.
Jonathan
simply
( ) use for define the Aggrigate function like sum(), Avg(), count() etc
< > use for define the modifiers that is inside it we write the condition
[ ] use for define the field
{ } use for beginning and the end of the whole set analysis
( ) = using for functions, Exp: Sum(Sales),Here Sum is function.
< >,{ } = using for expression.when u will start writting expression by using Set Analysis first {< exp> }
Exp : {<Year={$(vMaxYear)}>}
[] = Using for Field Name,If there is a gap between any FieldName,then u need to put field name in [ ]. Exp : [Product Code]
Exp of all brackets:
Sum({<Year={$(vMaxYear)}>},[Product Code]={AA001} Sales)
Regards-Bika
Thanks Jonathan, viswaranjan, bika for the inputs...
if u have any more inputs related to SET or any helpfull application to train and build the logic please share with me, i tried reengineering but tht s providing me instant solution
but not enhancing my knowledge and understanding.