{"id":27411,"date":"2023-09-25T10:36:37","date_gmt":"2023-09-25T10:36:37","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=27411"},"modified":"2024-12-03T04:53:44","modified_gmt":"2024-12-03T04:53:44","slug":"how-to-use-dockable-filter-control-in-sei-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2023\/09\/25\/how-to-use-dockable-filter-control-in-sei-sage-x3\/","title":{"rendered":"How To Use Dockable Filter Control in SEI Sage X3."},"content":{"rendered":"\n<p>Sage Enterprise Intelligence is an intuitive business intelligence solution integrated with your Sage Business Management system to help business users reduce time spent on analysis and reporting and make faster and better-informed decisions.<\/p>\n\n\n\n<p>It empowers all users with a simple solution to access and analyse data in a self-sufficient manner, which eliminates the need for different tools and specialised skills and can reduce time to decision.<\/p>\n\n\n\n<p>Click the Miscellaneous Controls icon, click and hold Dockable Filter Control and drag it onto your dashboard.<\/p>\n\n\n\n\n\n<p>Once we have added the Dockable Filter Control your dashboard should look something like this:<\/p>\n\n\n\n<p>As shown in Figure 2.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><imgtarget=\"_blank\" rel=\"no opener noreferrer\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"530\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/09\/Image_2-1024x530.png\" alt=\"\" class=\"wp-image-27413\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/09\/Image_2-1024x530.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/09\/Image_2-300x155.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/09\/Image_2-768x397.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/09\/Image_2-1536x795.png 1536w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/09\/Image_2-660x341.png 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/09\/Image_2.png 1782w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><center>Fig. 2<\/center><\/figcaption><\/figure>\n\n\n\n<p>&nbsp;Click on the icon at the top right (highlighted below) of the Dockable Filter Control to access the Properties window, shown expanded in the image below with \u201cCustomer Type\u201d used for this example. From here you can define the layout and field you want to filter on as shown in Fig 3.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><imgtarget=\"_blank\" rel=\"no opener noreferrer\"><img decoding=\"async\" width=\"795\" height=\"203\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/09\/Images_3.jpg\" alt=\"\" class=\"wp-image-27414\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/09\/Images_3.jpg 795w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/09\/Images_3-300x77.jpg 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/09\/Images_3-768x196.jpg 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/09\/Images_3-660x169.jpg 660w\" sizes=\"(max-width: 795px) 100vw, 795px\" \/><figcaption><center>Fig.3<\/center><\/figcaption><\/figure>\n\n\n\n<p>The first button we will define is the customer type (customer stat group 1). Please see screenshots to review General, Layout and Dashboard Filtering settings. The \u201cParameter\u201d drop down under the General tab is where you specify what field you will be filtering. The \u201cViews to apply filter\u201d area on the Dashboard Filtering tab is where you link the filter to the specific views you have on your dashboard. As shown in Figure 4<\/p>\n\n\n\n\n\n\n\n<p>&nbsp;Also&nbsp; as shown in Figure 6.<\/p>\n\n\n\n\n\n<p>For the Product Stat Group 1 (Product Type) to add another Dockable Filter below the Customer Type filter, as seen in the following screenshot:<\/p>\n\n\n\n<p>As shown in Figure 7.<\/p>\n\n\n\n\n\n<p>Once all of your filters are set up it\u2019s a good idea to test your filters to ensure they are working correctly. Test your Dockable Customer Type &amp; Product Type Filters by clicking the dimensions you want to filter and clicking the + to add or \u2013 to exclude the filter. Depending on what graphs you linked the filters to in above screenshot, they will update the corresponding graph to only include the dimensions you specified. If you linked both filters to both graphs, then they should update together! As shown in figure<\/p>\n\n\n\n\n\n<p>Next, go to your date filtering panel on the top left of your dashboard and test it by clicking on the year and month drop downs at the top of the dashboard and applying some filters (shown up close in the cropped image below). By applying this filter your graphs should only include data from the years and\/or months you selected.<\/p>\n\n\n\n<p>As shown in Figure 9.<\/p>\n\n\n\n\n\n<p>Once you are happy with the layout and filter settings of your Dashboard, on the right vertical toolbar, click the floppy disk icon to see the Save options. Click the Save button to overwrite your version or Save As to create a new version. Once saved, you can click Exit Edit Mode to close out of the design view.<\/p>\n\n\n\n<p>In this way we can use Dock able filter in SEI.<\/p>\n\n\n\n<p><strong>About Us<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>&nbsp;\u2013 a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>&nbsp;caters to a wide range of Sage X3 (Sage Enterprise Management) offerings \u2013 a Sage Business Cloud Solution. Our&nbsp;unique GUMU&#x2122; integrations include&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-x3-integration\">Sage X3 for Sage CRM<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/gumu-x3-salesforce-integration\">Salesforce.com<\/a>&nbsp;and&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/magento-sage-integrations\/sage-x3-magento\">Magento eCommerce<\/a>&nbsp;along with Implementation and Technical Support worldwide for&nbsp;<a href=\"https:\/\/www.greytrix.com\/africa\/product\/consulting\/implementation-planning\">Sage X3<\/a>&nbsp;(Sage Enterprise Management). Currently we are&nbsp;<a href=\"https:\/\/www.greytrix.com\/africa\">Sage X3 Implementation Partner<\/a>&nbsp;in East Africa, Middles East, Australia, Asia.&nbsp;We also offer best-in-class&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-x3\">Sage X3 customization and development services<\/a>,&nbsp;integrated applications such as&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/pos-system\">POS<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/warehouse-management-system\">WMS<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/payment-gateway\">Payment Gateway<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/shipping-system\">Shipping System<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/business-intelligence\">Business Intelligence<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/ecommerce-magento-integration\">eCommerce<\/a>&nbsp;and have developed add-ons such as&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/catch-weight\">Catch \u2013 Weight&nbsp;<\/a>&nbsp;and&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/letter-of-credit\">Letter of Credit<\/a>&nbsp;for Sage X3 to Sage business partners, end users and Sage PSG worldwide.<\/p>\n\n\n\n<p>Greytrix is a recognized&nbsp;<a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/07\/26\/greytrix-on-boards-sage-global-rockstar-isv-program-with-gumu-for-sage-crm-sage-x3-solution\/\">Sage Rockstar ISV Partner<\/a>&nbsp;for GUMU&#x2122; Sage X3 \u2013 Sage CRM integration also listed on&nbsp;<a href=\"https:\/\/www.sage.com\/marketplace\/asb_ListingDetail?listingId=a1h24000007PC3aAAG\" target=\"_blank\" rel=\"noreferrer noopener\">Sage Marketplace<\/a>; GUMU&#x2122; integration for Sage X3 \u2013 Salesforce is a 5-star app listed on&nbsp;<a href=\"https:\/\/appexchange.salesforce.com\/listingDetail?listingId=a0N30000000psM5EAI\" target=\"_blank\" rel=\"noreferrer noopener\">Salesforce AppExchange<\/a>.<\/p>\n\n\n\n<p>For more information on Sage X3 Integration and Services, please contact us at&nbsp;<a href=\"mailto:x3@greytrix.com\">x3@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sage Enterprise Intelligence is an intuitive business intelligence solution integrated with your Sage Business Management system to help business users reduce time spent on analysis and reporting and make faster and better-informed decisions. It empowers all users with a simple solution to access and analyse data in a self-sufficient manner, which eliminates the need for\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2023\/09\/25\/how-to-use-dockable-filter-control-in-sei-sage-x3\/\">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":[1,3162,13,8,3642,9,10,2796,11],"tags":[3868,3869,1780,1822,1871,2871,1945,3624,3734,3657],"class_list":["post-27411","post","type-post","status-publish","format-standard","hentry","category-uncategorized","category-greytrix","category-integration","category-sage-erp-x3","category-sage-x3","category-sage-x3-consulting","category-standard","category-technical","category-tips","tag-dockable-filter-control","tag-dockable-filter-control-in-sei-sage-x3","tag-sage-erp-x3","tag-sage-x3","tag-sage-x3-features","tag-sage-x3-functional-blogs","tag-sage-x3-technical-blogs","tag-sei","tag-sei-blogs","tag-sei-dashboard"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/27411","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=27411"}],"version-history":[{"count":8,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/27411\/revisions"}],"predecessor-version":[{"id":30378,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/27411\/revisions\/30378"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=27411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=27411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=27411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}