O GoConqr está de visual novo! Conte para nós o que você achou.

Registre-se grátis

Flashcards

Reporting

Usuário eliminado O usuário eliminou as informações de disciplina Inglês 69 flashcards

Flashcards do conjunto (69)

  1. 1Any Pega Platform class with ____ instances, such as ____, can be mapped to a database tableconcrete, case types
  2. 2Reports use ____ to locate the data from one or more database tablesclass mappings
  3. 3When you combine data in a report, you use ____ to identify the tables where the information is storedclass names
  4. 4By default, Pega Platform always contains the ____ and ____ database recordsPegaRULES – Maps to the database where all Pega Platform rules and system data are saved.
    PegaDATA – Maps to the database where data and work instances are saved.
  5. 5Pega Platform uses two rule types to identify the database table the class is mapped to: ____ and ____.Database, Database Table
  6. 6Database records can be configured to use either ____ or ____ URL for the database connectionJNDI, JDBC
  7. 7Database Table records exist for every ____ and identify the corresponding database and tableclass
  8. 8How could you save instances of several classes in the same table?You designate a class, usually the parent class, as a class group (also referred to as a work pool).
  9. 9____ cause the system to store instances of similar or related case types together in a single database tableClass groups
  10. 10When a case is created, the properties from the work class and the inherited classes are used to generate reports. Some commonly used properties are: (5)pyID – Case identifier
    pyWorkParty – Work parties participating
    pxUpdateOperator – Last user to update the case
    pxUpdateDateTime – Time of the last update
    pyStatusWork – Work status of the case
  11. 11To optimize performance, properties referenced in reports must be ____ in the database tableexposed as columns
  12. 12When joining to the class of a case type, the assignment class ____ is used to match with the ____ of the case typepxRefObjectKey, pzInsKey
  13. 13What are the three commonly used reporting classes?Work-
    Assign-
    History-
  14. 14If ____ is significantly lower than ____, that value indicates the assignment has been idle for a long time.pyPerformTaskTime, pxTaskElapsedTime
  15. 15If an assignment is routed to an operator, Pega Platform saves the object to the database table named ____. If the assignment is routed to a work queue, Pega Platform saves the object in a database table named ____pc_assign_worklist, pc_assign_workbasket
  16. 16You can combine data from different classes by ____, ____, or ____.configuring class joins, referencing association rules, creating subreports
  17. 17What combination method do you use when you want a report that identifies the current assignment and operator working on each candidate case?Class Join
  18. 18When can't you join to another class?When the class is in a different database than the Applies To class of the report
  19. 19Unlike a class join (unique to each report), ____ can be reused in any reportassociations
  20. 20If you want to combine records in the Assign-WorkBasket class with records in work classes, you use the standard ____ association rule to join the classes.WorkBasket Assignment (pxWorkbasketAssignments)
  21. 21____ enable you to reference results from any report definition in the main reportSubreports
  22. 22You commonly use subreports to...satisfy complex reporting requirements
  23. 23Using subreports to filter results allows you to ____. You can also use subreports to ____ on specific rows in the main report.include or exclude data, display aggregate calculations
  24. 24For example, in your main report about managers, you can reference a ____ that fetches the number of all employees who directly report to those managers. You can set a filter condition to display only the managers who have more than 10 subordinates.subreport
  25. 25____ can be defined in classes that are different from the main report using join filtersSubreports
  26. 26Subreports can be defined in classes that are different from the main report using ____join filters
  27. 27Implementing a ____ and ____ can help with the long-term performance of your reports.data-archiving strategy, partitioning tables
  28. 28If an organization requires heavy trending reporting and business intelligence (BI) reporting, a ____ may be a good fit.data warehouse
  29. 29If you need dynamic queries, you can also use freeform searching on text such as ____ instead of constructing a report definition to gather the dataElasticsearch
  30. 30A ____ is a system used for reporting and data analysisdata warehouse
  31. 31The data warehouse is a central repository of integrated data from one or more separate sources of data. The ____ process prepares the data for use by the data warehouseextract, transform, and load (ETL)
  32. 32The key factor to determining whether you design your reports in the Pega application or leverage an external reporting tool, is whether it ____impacts application performance
  33. 33____ allows you to extract data from your production application and format it to make it suitable for loading into a data warehouse.Business Intelligence Exchange (BIX)
  34. 34BIX is an optional add-on product consisting of ____ and ____a ruleset, a standalone Java program run from a command line
  35. 35BIX data from the BIX process can be formatted as ____ or ____ or ____XML, comma-separated (CSV), can be output directly to a database
  36. 36The three configurable files used by BIX are:boostrap.properties, prconfig.xml, and bix.xml
  37. 37To improve report generation performance, you can run report definitions against ____ indexes instead of using SQL queries directly against the databaseElasticsearch
  38. 38Running report definitions against Elasticsearch indexes is ____ by defaultdisabled
  39. 39____ is a third-party search engine that ensures a quick way to find relevant information within applications by effectively analysing huge volumes of data.Elasticsearch
  40. 40Pega Platform uses the ____ engine for full-text searches to retrieve specific data from the system such as rules, assignments, attachments, or data instances.Elasticsearch
  41. 41What issues can be caused by poor report performance?Memory, CPU and Network impact
  42. 42You can choose to take an entirely different approach for gathering data, such as using ____ or ____.Robotic automation, Elasticsearch
  43. 43What are the 7 best practices for configuring reporting rules within the application?Using data pages when possible
    Paginating results
    Optimizing properties
    Using declare indexes
    Leveraging a reports database
    Avoiding outer joins (include all rows)
    Using Report on descendant class instances
  44. 44The best approach to optimizing your report is to ____ as a source for the user interface, and using ____ instead.avoid the use of report definition, data pages
  45. 45If you expect to use a property in your selection criteria, ____ that propertyoptimize
  46. 46What does Optimizing a property do?Optimizing a property creates a column in the database table, which you can then index as needed.
  47. 47____ allow you to expose embedded page list dataDeclare indexes
  48. 48You can expose only ____ properties as columns, unless you use the ____ or ____ approachtop-level Single Value, Copy, Declare Index
  49. 49What's the difference between the Copy and Declare Index approaches for exposing embedded properties?Copy when you only need a single embedded property. Declare Index when you need some or all values of a Value List or Value Group.
  50. 50Use the Declare Index approach if some or all values of a ____ or ____ are needed as exposed columns.Value List, Value Group
  51. 51How do you implement the Copy approach for embedded properties? 5 Steps.Create a top-level Single Value property to hold a copy of this value.
    Create a one-step activity to copy the value to the new top-level property, with Activity Type set to Trigger.
    Create a Declare Trigger rule that calls the activity each time the work item is saved.
    Expose the top-level property.
    Reference the top-level property in the report definition rule.
  52. 52How do you implement the Declare Index approach for embedded properties? 6 steps.Create a concrete class derived from the Index- base class.
    Create Single Value properties in the new class to hold values of the embedded values.
    Create a Declare Index rule with the appropriate embedded Page Context value that copies the embedded values into a new Index- instance.
    Save the Declare Index rule. This rule runs immediately, adding and deleting instances of the new class.
    Expose the database columns corresponding to the Index- class.
    Reference the Index- properties in the report definition rule.
  53. 53When using the Declare Index approach for embedded properties, create a ____ derived from the ____ base class.concrete class, Index-
  54. 54To reduce the impact of queries on the production database, you can run reports against a ____ (also known as an ____). This approach offloads the demand of the production database to a replicated database.reports database, alternate database
  55. 55If Report on descendant class instances is selected, you can choose to include ____ or ____ (all ____ and ____ classes).only the implementation class, all descendant classes, framework, implementation
  56. 56What are three methods to tune the database to improve report performance?Executing Explain Plans on your queries
    Creating table indexes
    Purging and archiving data
  57. 57When should you create an index on an exposed column?The column is queried frequently.
    A referential integrity constraint exists on the column.
    A UNIQUE key integrity constraint exists on the column.
  58. 58How do you refer ancestors in a query / report?If it's direct, you can use pxCoverInsKey. If you need to go higher, you will need to define a property and propagate it (use a meaningful name like ClaimKey).
  59. 59When would you use generated or reformatted data for a query / report?If the report uses only a few properties, but on a lot of complex instances. Or when the data you need is not saved on the class as it's only used for reporting purposes. Or if the query would not be supported by Pega Reports otherwise. Example: create Data-SimpleCaseHistory to define 4 properties which are purely for a report.
  60. 60In the App Explorer, you can filter on the ____ class to see only SQL Functions.Embed-UserFunction
  61. 61In the App Explorer, you can filter on the Embed-UserFunction class to see only ____.SQL Functions
  62. 62What options are there for when values in a Report Definition need to be translated to be shown in a report?SQL Functions, SELECT subquery
  63. 63As a best practice, where should associations be created for reporting?In the Enterprise layer or a reusable layer for use across the organization and top-level application layers.
  64. 64LSAs should encourage the creation of ____ wherever possible while designing a reporting solution to increase reusabilityassociations
  65. 65Once an association is created in a class, it is available for use ____anywhere in the class hierarchy
  66. 66Managers can create a new report from the Report Browser and drag and drop the required columns from the available ____associations
  67. 67The ____ help to join two classes only when both classes have the same columns.class joins
  68. 68You can use two different methods to create a subreport: ____ or ____.join filters, aggregation
  69. 69Which report definition data access method should be used to include Work Parties?Declare Index

Informações

Descrição
O usuário eliminou as informações de disciplina FlashCards sobre Reporting, criado por Usuário eliminado em 14-09-2022.
Criado por
Usuário eliminado · set 2022
Atualizado
14 set 2022
Visualizações
9
Histórico
  • Criado por Nika Houkes · 4 set 2022
  • Copiado por Nika Houkes · 14 set 2022
Avaliação

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?