Solved
Creating a bionic rule that doesn't return billions (yes, billions!) of results.
I am attempting to create a bionic rule that will fetch data from multiple tables and load it into another one. However, when I test my rule, I receive billions, even trillions of data points. It seems like there is a crossjoin in a couple of tasks which is multiplying data but I don't really know what that means or how to fix it.
Best answer by ashok_dugaputi
Kate- As Denise mentioned, when you are joining 4 Utilization data objects, ensure that you are joining them based on unique keys on each object..
Ex: When you are joining two Usage data objects, you need join them on Account, Date and (User if exists) at a minimum. If you are joining only on Account, It must be creating Cross join.
If you need further help, please send an email to support@gainsight.com.
View originalEx: When you are joining two Usage data objects, you need join them on Account, Date and (User if exists) at a minimum. If you are joining only on Account, It must be creating Cross join.
If you need further help, please send an email to support@gainsight.com.
+4Kate - Sounds like a join problem. Two thoughts:
- Do you want to outline what you are trying here? What is the data you are fetching and what is your end goal for the rule? Might be good for others to learn from as well
- You can reach out to our support team for some help
- Do you want to outline what you are trying here? What is the data you are fetching and what is your end goal for the rule? Might be good for others to learn from as well
- You can reach out to our support team for some help
Thanks Denise - I'm trying to create one MDA Object that an email template can pull from. I am fetching data from:
- Native SFDC
- Existing MDA objects (4 separate objects) that contain utilization data
The first 5 tasks in my bionic rule are fetches, and then I have 4 merge tasks that join the data according to Account ID.
I am happy to reach out to support, should I submit a ticket via Gainsight Go?
- Native SFDC
- Existing MDA objects (4 separate objects) that contain utilization data
The first 5 tasks in my bionic rule are fetches, and then I have 4 merge tasks that join the data according to Account ID.
I am happy to reach out to support, should I submit a ticket via Gainsight Go?
Kate- As Denise mentioned, when you are joining 4 Utilization data objects, ensure that you are joining them based on unique keys on each object..
Ex: When you are joining two Usage data objects, you need join them on Account, Date and (User if exists) at a minimum. If you are joining only on Account, It must be creating Cross join.
If you need further help, please send an email to support@gainsight.com.
Ex: When you are joining two Usage data objects, you need join them on Account, Date and (User if exists) at a minimum. If you are joining only on Account, It must be creating Cross join.
If you need further help, please send an email to support@gainsight.com.
1 person likes this
Thanks Ashok - I was able to join on multiple fields and this greatly reduced the number of results. I better understand the process now!
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.