Does anyone have questions on Bionic rules ?

  • 2
  • Question
  • Updated 1 year ago
  • In Progress
Does anyone have questions on Bionic rules, please share them with us.We will add them as part of the documentation and share them with you.
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 12,426 Points 10k badge 2x thumb

Posted 1 year ago

  • 2
Photo of Lane H

Lane H, Employee

  • 9,144 Points 5k badge 2x thumb
Hi Sai,

Can you shed some like on why there is a limit to how many tasks you can put in a Bionic rule?

I was creating a rule to push usage data into MDA instead of SFDC, and I hit this limitation. I was able to work around it, but if we want to add another metric into Usage I would need to create a new rule.
Photo of Lane H

Lane H, Employee

  • 9,144 Points 5k badge 2x thumb
Hi Sai! 

Yes, however, I hit that limit with our usage rule. 
Photo of Nitin Pawar

Nitin Pawar, Employee

  • 372 Points 250 badge 2x thumb
Lane, can you please reach us through a support ticket. We would like to understand the problem you are trying to solve and help you with the limits you are hitting. 
Photo of Lane H

Lane H, Employee

  • 9,144 Points 5k badge 2x thumb
Thanks Nitin! I submitted a ticket yesterday.
Photo of Nitin Pawar

Nitin Pawar, Employee

  • 372 Points 250 badge 2x thumb
Hi Lane, We will communicate over the ticket. 
We are reviewing the rule you created so that we understand and do the needful accordingly. 
Photo of Jitin Mehndiratta

Jitin Mehndiratta, Product Manager

  • 3,254 Points 3k badge 2x thumb
Lane, 

We are planning to increase the task limit from 15 to 20. Also, in the long run, we plan to support merging of more than 2 dataset tasks that should further reduce the need to have more tasks in a rule.

Regards,
Jitin
Photo of Mendy Peugh

Mendy Peugh

  • 312 Points 250 badge 2x thumb
Are bionic rule data sets supposed to be done in a certain order so they work correctly?  Does doing Data Sets in any order impact results success?
Photo of Nitin Pawar

Nitin Pawar, Employee

  • 372 Points 250 badge 2x thumb
We do run the tasks in a single bionic rule in parallel if their dependencies are solved. 

For eg: If you have 2 fetch tasks, 2 independent transform tasks and 1 merge tasks.
We run the 2 fetch tasks independently. The dependent transform task is started when its parent fetch task is finished. At last when both transform tasks if used in merge task, then merge task will only start after its parent tasks are over.

So good news is if you are using a bionic rule, you do not have to worry on ordering the tasks. We take care of the dependency of the tasks inside the bionic rule 
(Edited)
Photo of Lyubov Penyugalova

Lyubov Penyugalova

  • 430 Points 250 badge 2x thumb
Hi Sai, why does bionic rule export dump empty date values as ,"", (string) instead of ,,? Are there any settings on this?
Photo of Nitin Pawar

Nitin Pawar, Employee

  • 372 Points 250 badge 2x thumb
An export from a bionic rules is done as a csv file or a tsv file. 

CSV Files just understand two kinds of data, either the data in the cell is a text value or numeric value. CSV represents any text value enclosed in quotes (either single or double based on the data patterns). Anything which is not enclosed in quotes is assumed as null or numeric. 

To represent a date (which essentially is a text value with date context), it needs to be wrapped in quotes. 
CSV does not allow us to provide the context as date as it treats it as any other text value. 

This approach lets the readers such as MS Excel or OpenOffice read the values for the cells in the sheet based on field delimiter and quote char for field enclosing. 

Thanks,
Nitin
Photo of Lyubov Penyugalova

Lyubov Penyugalova

  • 430 Points 250 badge 2x thumb
Thank you very much, Nitin! Excel does work well for this purpose. For analytics needs we export CSV files directly from S3 bucket to our internal DB and had to make work arounds to push data smoothly. The problem with dates was solved, so all is good now.