How to get multipe data set values from Decision Table.

[Former Member]

Hi All,

I need to use SAP BRM for one of the scenario where based one some Code Group I need to get a set of questions and for each question a set of possible answers.

The structure of Decision Table will be like below :

Table 1 : To get set of questions based on Project Code

Input                   Output           Output

Project Code	Question Id	Question Description

Table 2 : To get set of answers based on question

Input                   Output            Output

Question ID	Answer Id	Answer Description

I already searched in forum to get the multiple values based on some input and that works fine for a single field with multiple outcome.

In my scenario I need to get a set of Id and description as multiple outcome.

Can anyone please let me know how this can be achieved in BRM.

Thanks in advance

Ravindra

[rohit_j]

HI,

You use case can be implemented by changing the DTO a bit.

You can use the attached DTOs for your scenario. Your decision table should like the table below.

Since the decision table execution table is from left to right, in the setQuestionDescription method we will keep adding to the list as per the code in "QuestionsDto".

getProjectCode	getIdentifier	setQuestionId	setQuestionDescription
1	> 1	Q1	Question 1
1	> 2	Q2	Question 2
1	> 3	Q3	Question 3

Once the ruleset is invoked and you get the response, you just to QuestionsDto.getQuestionsOutputDto which returns the list of questions.

Best Regards,

Rohit

QuestionsDto.txt.zip

QuestionsOutputDto.txt.zip

[former_member191643]

Create an XSD in the BRM project with the desired data structure and import the XSD alias in the 'Project Resources'. Add this XSD alias as input/output of the decision table.

Refer this:

[Former Member]

Hi Siddhant,

thanks for reply but this xml approach works for flat structure only. I need to get the muliple action values for a single condition input. Also the output should be a data set like id and description.

Let me know if you have implemented such scenerio in BRM.

Thanks

Ravindra

[former_member186851]

Ravindra,

Did you solve this?