Admin: Allow Usage Measures to pull from MDA table
None
We've worked with support over the last few months in troubleshooting rule timeouts that ultimately led to uncovering a limitation where (if I recall correctly) querying a large number of records fails because Salesforce has a 2 minute timeout limit on queries. This requires us to split rules out into segmented multiples (for the same rule) so that we can parse through all the records without incurring the timeout.
There were also concerns about how much space it takes up on the Salesforce backend to capture the data in an SFDC object.
It was suggested to us from GS that we should move the Usage Data into MDA where no timeout exists. Discussing further though revealed that moving to MDA would render the Usage widget on the Customer360 useless and we would have to create multiple reports to try and emulate that functionality. It also revealed that if we want to use the trending over time capabilities of Scorecard, we have to continue using Usage Data table in Salesforce because that is from where the Usage Measures are pulled. Also, in order to use Calculated Fields in a rule, it needs to exist as a Number field in Usage Measures (?).
If we opted to pull out everything except Scorecard from Usage Data, the space issue is also negated because apparently once a row is created, the space is allocated anyway (?).
Assuming all of the above to be true, this request is to enable Usage Measures to be pulled from an MDA table directly so that we can move all Usage Data to MDA without jumping through too many hoops and workarounds to get there.
There were also concerns about how much space it takes up on the Salesforce backend to capture the data in an SFDC object.
It was suggested to us from GS that we should move the Usage Data into MDA where no timeout exists. Discussing further though revealed that moving to MDA would render the Usage widget on the Customer360 useless and we would have to create multiple reports to try and emulate that functionality. It also revealed that if we want to use the trending over time capabilities of Scorecard, we have to continue using Usage Data table in Salesforce because that is from where the Usage Measures are pulled. Also, in order to use Calculated Fields in a rule, it needs to exist as a Number field in Usage Measures (?).
If we opted to pull out everything except Scorecard from Usage Data, the space issue is also negated because apparently once a row is created, the space is allocated anyway (?).
Assuming all of the above to be true, this request is to enable Usage Measures to be pulled from an MDA table directly so that we can move all Usage Data to MDA without jumping through too many hoops and workarounds to get there.
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.
Would check your availability in separate email thread to validate the approach tomorrow (May 24, 2016).
Regards,
Ajit
We are designing this capability now. Since a key item we want to replicate (and improve) is the Usage Widget - some guidance on areas that you love or features you would like to see available in a similar widget?
We have considered things like: Date Range selection, measure selection, seeing milestones as a few of the top must haves. Are there others?
From over a year ago: https://community.gainsight.com/gainsight/topics/usage-configuration-need-ability-to-remove-specific...
You can use other objects besides the Usage Data object to create calculated fields. I've attached a photo of the Account object as the source and the calculated field being present. The only caveat is that calculated fields are not available at the Relationship level, but as long as your rule is at the Account level, you should be set.