March 6, 2010

Valueset $Flex$

1. Create executable



Here the application name (“Application Object Library”) is the application (FND TOP) where the report (Execution file name: “CHUMMA.rdf”) resides.


2. Create validation set

While creating this value set “myset2” the set is a list of values from the CHUMMA table. But the parameter value where we are going to use this value set is depended on the previous parameter value. If first parameter value is 5 then this list of value should show only after 5. For that we should write a condition while creating this value set. The condition is
Here “:$FLEX$” is the keyword. “A” is the previous parameter name. We can also use “myset1” (parameter’s value set name). But while using the “myset1” it won’t depend on our desired parameter. Instead of the last parameter where value set (myset1) is used.



3. Create program




4. Run the request

A’s value set is myset1 C’s value set is myset1

B’s value set is myset1 with the following condition

A’s value set is myset1 C’s value set is myset1

B’s value set is myset1 with the following condition

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...