{"id":29347,"date":"2024-06-27T12:26:30","date_gmt":"2024-06-27T12:26:30","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=29347"},"modified":"2024-06-27T12:26:30","modified_gmt":"2024-06-27T12:26:30","slug":"dashboard-filtering-in-sage-enterprise-intelligencesei","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2024\/06\/27\/dashboard-filtering-in-sage-enterprise-intelligencesei\/","title":{"rendered":"Dashboard Filtering in Sage Enterprise Intelligence(SEI)"},"content":{"rendered":"\n<p>One of the most valuable features within SEI is dashboard filtering, a dynamic function that allows users to customize their data views to meet specific analytical needs. Dashboard filtering in SEI for SAGE X3 provides users with the flexibility to focus on the most relevant data, thereby transforming vast datasets into actionable insights. Whether you are monitoring sales performance, inventory levels, or financial metrics, mastering dashboard filtering can significantly enhance your ability to make informed decisions swiftly and accurately. There might be scenarios where it gets difficult to filter dashboards in SEI.<\/p>\n\n\n\n<p>In the below blog we are going to find out the best possible ways to filter a dashboard in Sage Enterprise Intelligence. Dashboard views can be filtered in below ways:<\/p>\n\n\n\n<p>1. Filtering Panel.<\/p>\n\n\n\n<p>2. Filtering using the Selection Page.<\/p>\n\n\n\n<p>3. Filtering using the External Link.<\/p>\n\n\n\n<p>4. Filtering on Click.<\/p>\n\n\n\n<p>1. <strong><u>Filtering Panel<\/u><\/strong>:<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; One of the quickest ways to filter your dashboard, based on the list of the possible values of a field.<\/p>\n\n\n\n<p>Note: For a Filtering Panel to be functional, at least one Global Parameter has to exist in the system. The Global parameter has to exist with a field within the data models where the dashboards views originate.<\/p>\n\n\n\n<p>Follow the below steps to use Filtering Panel:<\/p>\n\n\n\n<ol class=\"wp-block-list\" style=\"list-style-type:upper-roman\">\n<li>In the <strong>Setting<\/strong> menu on the right panel, click on the icon (<strong>Edit Dashboard<\/strong>) to enter into edit mode.<\/li>\n\n\n\n<li>In the <strong>Edit<\/strong> menu, select <strong>Dashboard Properties<\/strong>.<\/li>\n\n\n\n<li>Open the <strong>Filtering Panel <\/strong>section of the&nbsp;<strong>Properties<\/strong>&nbsp;menu to view the filters. From here you can add, edit, remove or reorder the filters.<\/li>\n<\/ol>\n\n\n\n<p>The remaining views in the dashboard can now be filtered automatically.<\/p>\n\n\n\n<p>2. <strong><u>Filtering using the Selection Page<\/u><\/strong>:<\/p>\n\n\n\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 The dashboard can also be filtered via the\u00a0<strong>Selection Page<\/strong>\u00a0window by clicking on next to the prompts or by setting a prompt in the\u00a0Prompt on open\u00a0property of the dashboard. Refer the below screenshot:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><imgtarget=\"_blank\" rel=\"noopener noreferrer\"><img fetchpriority=\"high\" width=\"1024\" height=\"411\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\"src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig1-Filtering-using-Selection-Page-1024x411.png\" alt=\"Filtering using Selection Page\" class=\"wp-image-29348\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig1-Filtering-using-Selection-Page-1024x411.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig1-Filtering-using-Selection-Page-300x120.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig1-Filtering-using-Selection-Page-768x308.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig1-Filtering-using-Selection-Page-660x265.png 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig1-Filtering-using-Selection-Page.png 1392w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><strong>Fig01: Filtering using Selection Page<\/strong><\/figcaption><\/figure>\n\n\n\n<p>3. <strong><u>Filtering using the External Link<\/u><\/strong>:<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; To filter a dashboard by year, insert the external link received at the end of the <strong>URL<\/strong>; for example:&nbsp;\u2018<strong>&amp;F=Year=2018\u2019<\/strong>, Refer the below screenshot.<\/p>\n\n\n\n<p>The dashboard will be updated with the specified year&#8217;s data only.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><imgtarget=\"_blank\" rel=\"noopener noreferrer\"><img width=\"1024\" height=\"310\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\"src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig2-Filtering-using-the-External-Link-1024x310.png\" alt=\"Filtering using the External Link\" class=\"wp-image-29349\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig2-Filtering-using-the-External-Link-1024x310.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig2-Filtering-using-the-External-Link-300x91.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig2-Filtering-using-the-External-Link-768x233.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig2-Filtering-using-the-External-Link-660x200.png 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig2-Filtering-using-the-External-Link.png 1392w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><strong>Fig02: Filtering using the External Link<\/strong><\/figcaption><\/figure>\n\n\n\n<p>4. <strong><u>Filtering on Click<\/u><\/strong>:<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; It is possible to filter the content of the&nbsp;Dashboard&nbsp;by clicking on any value of any type of&nbsp;View&nbsp;that has been predefined in the&nbsp;<strong>Dashboard Designer.<\/strong><\/p>\n\n\n\n<p>Note: Toggle the single-click selection in your dashboard to swiftly apply filters across different views (except Maps), enhancing your data analysis without disrupting your current view&#8217;s configuration. Refer the below screenshot.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><imgtarget=\"_blank\" rel=\"noopener noreferrer\"><img width=\"1024\" height=\"387\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\"src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig3-Filering-on-Click-1024x387.png\" alt=\"Filtering on Click\" class=\"wp-image-29350\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig3-Filering-on-Click-1024x387.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig3-Filering-on-Click-300x113.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig3-Filering-on-Click-768x290.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig3-Filering-on-Click-660x249.png 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig3-Filering-on-Click.png 1392w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><strong>Fig03: Filtering on Click<\/strong><\/figcaption><\/figure>\n\n\n\n<p>Hope the above blog helps you with filtering your dashboard views. Using the above mentioned ways, you can filter your dashboard views and have a smooth experience making it easier to create customized SEI views that highlights the most important information, saving time and boosting the productivity.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the most valuable features within SEI is dashboard filtering, a dynamic function that allows users to customize their data views to meet specific analytical needs. Dashboard filtering in SEI for SAGE X3 provides users with the flexibility to focus on the most relevant data, thereby transforming vast datasets into actionable insights. Whether you\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2024\/06\/27\/dashboard-filtering-in-sage-enterprise-intelligencesei\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3642,2,5,3162,8,10,2796,11],"tags":[4219,4218,1762,1780,1822,1839,2871,1943,1945,3624],"class_list":["post-29347","post","type-post","status-publish","format-standard","hentry","category-sage-x3","category-configuration","category-features","category-greytrix","category-sage-erp-x3","category-standard","category-technical","category-tips","tag-dashboard-views-in-sei","tag-filtering-dashboard-views","tag-sage-enterprise-management","tag-sage-erp-x3","tag-sage-x3","tag-sage-x3-blogs","tag-sage-x3-functional-blogs","tag-sage-x3-technical-blog","tag-sage-x3-technical-blogs","tag-sei"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=29347"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29347\/revisions"}],"predecessor-version":[{"id":29352,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29347\/revisions\/29352"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=29347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=29347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=29347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}