通用查询：避免典型陷阱.pdf

1、Generic Inquiries:Avoiding Typical PitfallsGregg Mercede2AgendaIntroductionLearning ObjectivesSession OverviewLearning Objective 1 Typical IssuesBusiness Scenario Use Case and SolutionDemoBenefits and ConsiderationsLearning Objective 2 FormulasLearning Objective 3 PerformanceLearning Objective 4 Agg

2、regationsQuiz Q&ASummary and Key Takeaways3Presented byGregg MercedeCEO4CPE DisclaimerThis session is NASBA-compliant,and you may get 1 CPE credit if you fulfill the following requirements:Participate in at least one quizProvide your full name and email address when you complete a quizFailure to pro

3、vide your full name and email address will result in Acumaticas inability to recognize you in our reports;thus,we will be unable to issue a CPE certificate for you.If you are not interested in getting the CPE credit,specifying your personal details is optional.Session Overview6Session OverviewRetrie

4、ving and making Information about your business actionable is critical for success.Generic Inquiries are a key tool in making information available to decision makers.Generic Inquiries have powerful capabilities such as formulas and aggregations which make your inquiry results even more meaningful a

5、nd impactful.Generic Inquiries can also negatively impact the performance of your transactional system.This session highlights things to avoid while working with a Generic Inquiry.Learning Objectives8Learning ObjectivesNew Field-Avoid Typical IssuesoRunning into performance problemsFormulas:Friend o

6、r FoeoStruggling with incorrect formulasoImproperly linking formulasAggregations:Dos and DontsoUsing inaccurate aggregationsPerformance:How to Quickly/Easily Improve/OptimizeoRequesting too much dataLearning Objective 1New Field-Avoid Typical Issues10Learning Objective 1 New Field:Avoid Typical Issu