Applying Filter Criteria


Concept


Steps:

  1. Begin by choosing a row in an existing matrix layout.

     

    Click the 3rd row header.

    Step 1
  2. Click the nVision menu.

    Step 2
  3. Click the Layout Definition... list item.

    Step 3
  4. Click the Filter tab.

    Step 4
  5. You have chosen a row of the matrix layout to define filter criteria. The next step is to add fields and dimensions.

     

    Click the Add button.

    Step 5
  6. Click the Lookup [?] button.

    Step 6
  7. Click the AUS01 ADJ-EURO ACCOUNT list item.

    Step 7
  8. Click the OK button.

    Step 8
  9. Click the Lookup [?] button.

    Step 9
  10. Click the AUS01 ACCOUNT ACCTROLLUP list item.

    Step 10
  11. Click the OK button.

    Step 11
  12. Click the OK button.

    Step 12
  13. Click the Lookup [?] button.

    Step 13
  14. Click the SHARE ACCTROLLUP DETAIL list item.

    Step 14
  15. Click the OK button.

    Step 15
  16. Click the By Name button.

    Step 16
  17. Click the ACCDEPREC list item.

    Step 17
  18. Click the OK button.

    Step 18
  19. Click the Apply button.

    Step 19
  20. Click the Add button.

    Step 20
  21. Click the Lookup [?] button.

    Step 21
  22. Click the AUS01 ADJ-EURO AFFLIATE list item.

    Step 22
  23. Click the OK button.

    Step 23
  24. Click the Selected Detail Values option.

    Step 24
  25. Click the OK button.

    Step 25
  26. Click the Lookup [?] button.

    Step 26
  27. Click the AFFILIATE GL_ACCOUNT_TBL list item.

    Step 27
  28. Click the OK button.

    Step 28
  29. Click the Lookup [?] button.

    Step 29
  30. Click the SHARE 100000 Petty Cash list item.

    Step 30
  31. Click the OK button.

    Step 31
  32. Click the Lookup [?] button.

    Step 32
  33. Click the SHARE 1000000 list item.

    Step 33
  34. Click the OK button.

    Step 34
  35. Click the Blank Value option.

    Step 35
  36. Click the Add To List button.

    Step 36
  37. Click the OK button.

    Step 37
  38. You have successfully added fields and field values. In the next few steps you will change the order of appearance of the field values and delete fields and field values.

     

    Click the 10000000 list item.

    Step 38
  39. Click the Up Arrow button.

    Step 39
  40. Click the 100000 list item.

    Step 40
  41. Click the Delete button.

    Step 41
  42. Click the ACCOUNT - ACCTROLLUP list item.

    Step 42
  43. Click the Delete button.

    Step 43
  44. Click the Apply button.

    Step 44
  45. Click the OK button.

    Step 45

You have successfully applied filter criteria to a row of an existing matrix layout.

Table of Contents  Start Topic