Need a Batch Macro to use Dynamic input to run HANA input

Question

Greetings,

There is a HANA model that provides the Bill of Materials, takes one material and provides all the sub assemblies and raw material needed.

There is a table that is generated with around 3k materials that I need to batch pass through the HANA model, where each material represents the input parameter for the model.

Using the action I can replace the field and update by adding a record count and sampling the first.

However not sure the order of the workflow so that it processes all the records.

Something like this:

Row 1: Cake A

Row 2: Cake B

Row 3: Cake C

Row 1 Cake A is feed to the HANA model as the IP that produces this list

* 1 box Vanilla Powder cake mix
* 2 Eggs
* 1 Tbsp. of Apple sauce
* 1 Tbsp. of olive oil

Once row 1 is processed we proceed to row 2

Row 2: Cake B is feed to the HANA as the IP model that produces this list

* 1 box gluten free Vanilla Powder cake mix
* 2 Eggs
* 1 Tbsp. of Apple sauce
* 1 Tbsp. of olive oil

Row 3: Cake C is feed to the HANA model as the IP that produces this list

* 1 box Vanilla Powder cake mix
* 2 Eggs
* 2 Tbsp. of olive oil

Result desired report would be a listing:

Cake A

* 1 box Vanilla Powder cake mix
* 2 Eggs
* 2 Tbsp. of olive oil

Cake B

* 1 box gluten free Vanilla Powder cake mix
* 2 Eggs
* 1 Tbsp. of Apple sauce
* 1 Tbsp. of olive oil

Cake C

* 1 box Vanilla Powder cake mix
* 2 Eggs
* 2 Tbsp. of olive oil

BAvitia88 · Answer

Thank for the info on the macros. It resulted I needed the dynamic input and not a macro. over complicated myself.

BAvitia88 · Answer

Thank you

Forgot to mention that some of the components can be builds them selves, so we would need to identify and get the bom for that lower level as well.

For example

Row 2: Cake B

* We Make the White Cake gluten free* We would need the ingredients for that flour mix

Kind of an iterative macro until all the items are buys

ChrisTX · Answer

Have you worked with batch macros before?  Can you create a sample workflow, and describe specific challenges?

If you have a unique list of a single input parameter like

like:

Row 1: Cake A

Row 2: Cake B

Row 3: Cake C

You can pass the single data stream into both input anchors of a batch macro, and use the Control GroupBy Field.

If you're new to batch macros, try

Learn > Academy > Learning Paths and

Learn > Academy > Videos

Chris