Announcements
cancel
Showing results for
Did you mean:
Not applicable

## SET Brackets

For what and When do we use this brackets in SET Analysis,

( )

< >

[ ]

{ }

Thanks & Regards,

1 Solution

Accepted Solutions
Not applicable
Author

( ) = 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

4 Replies
Anonymous
Not applicable
Author

( )    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

Not applicable
Author

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

Not applicable
Author

( ) = 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 applicable
Author

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.

Community Browser