{"id":2690,"date":"2015-03-23T19:02:04","date_gmt":"2015-03-23T11:02:04","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=2690"},"modified":"2024-10-23T14:21:09","modified_gmt":"2024-10-23T06:21:09","slug":"show-dataset","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/show-dataset\/","title":{"rendered":"Show Dataset"},"content":{"rendered":"<p class=\"page-subheading\"><\/p>\n<p class=\"left-bar\">This article applies to versions 4.3.2 and earlier of IFS OI Explorer. This component has been deprecated.<\/p>\n<h3 class=\"page-subheading\">Overview<\/h3>\n<p class=\"intro-text\">The Show Dataset component\u00a0allows the user to view the data in the dataset in a tabular format.<\/p>\n<p class=\"intro-text\">Configuration is simple: you simply supply the name of the dataset, as follows:<\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdataset.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3307 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdataset.png\" alt=\"showdataset\" width=\"852\" height=\"316\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdataset.png 852w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdataset-150x56.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdataset-768x285.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdataset-24x9.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdataset-36x13.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdataset-48x18.png 48w\" sizes=\"auto, (max-width: 852px) 100vw, 852px\" \/><\/a><\/p>\n<div style=\"position: relative;\">\u00a0<\/div>\n<table>\n<tbody>\n<tr>\n<td width=\"130\"><strong>Dataset Name<\/strong>:<\/td>\n<td>The name of the <a title=\"Add Data\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/add-data\/\">dataset<\/a>, as displayed below the canvas. This dataset must be a properly configured <a title=\"Add a Relational Dataset\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/add-data\/add-a-dataset\/\">tabular<\/a>\u00a0or <a title=\"Add Time Series Data\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/add-data\/add-time-series-data\/\">time series<\/a> dataset. This component will display the same data, in the same format, as the Preview button on the dataset itself.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr \/>\n<p>&nbsp;<\/p>\n<h3 class=\"page-subheading\"><span id=\"Tutorial\">Tutorial<\/span><\/h3>\n<div>\n<p class=\"intro-text\">Show Dataset is a useful component that enables users to view the data contained within a dataset.<\/p>\n<p class=\"intro-text\">In this tutorial, we\u2019ll look at adding a Show Dataset component that will display the\u00a0data in a dataset\u00a0created for a <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/pivot-table\/\">Pivot Table<\/a>.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f6fe0b6.png\" rel=\"lightbox-1\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-67392\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f6fe0b6-600x311.png\" alt=\"\" width=\"1000\" height=\"518\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f6fe0b6-600x311.png 600w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f6fe0b6-768x398.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f6fe0b6-150x78.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f6fe0b6-1080x560.png 1080w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f6fe0b6-48x25.png 48w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f6fe0b6.png 1271w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/p>\n<p class=\"intro-text\">Let\u2019s go through this process, step-by-step.<\/p>\n<hr \/>\n<h3 class=\"page-subheading\"><span id=\"Step_by_Step_Creating_a_Pivot_Table_Driven_by_a_Range_Picker_and_Entity_Selector\"><span id=\"Step_by_Step_Creating_a_Time_Menuthat_Drives_a_LineChart\">Step by Step: Displaying a Dataset\u00a0Table on a Page\u00a0<\/span><\/span><\/h3>\n<p class=\"intro-text\">Before you start, open a new tab in Explorer and click the \u201cCreate a New Page in Studio Mode\u201d thumbnail. Choose the <a title=\"Grid Layout\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/grid-layout\/\">grid<\/a>\u00a0layout \u2013 you can adjust the rows and columns if you like but it\u2019s not important for this exercise.<\/p>\n<p class=\"intro-text\">You will need to adjust the configuration to suit your data at your site.<\/p>\n<p class=\"intro-text\"><strong>Step 1. Add the\u00a0source data<\/strong><\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f714d18.png\" rel=\"lightbox-2\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-67393\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f714d18-600x416.png\" alt=\"\" width=\"800\" height=\"555\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f714d18-600x416.png 600w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f714d18-768x533.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f714d18-150x104.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f714d18-48x33.png 48w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f714d18.png 1068w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p class=\"intro-text\">As Show Dataset is\u00a0designed to display data, the first thing we want to do is <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/add-data\/\">add\u00a0the data<\/a> we want to display.<\/p>\n<ul class=\"intro-text\">\n<li>Add the <em>MiningDowntimePivot<\/em>\u00a0<a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/add-data\/add-a-dataset\/\">dataset<\/a>, and configure it as follows:\n<ul class=\"intro-text\">\n<li>StartDate:\u00a0(Datetime) 01\/04\/2015 12:00:00 AM<\/li>\n<li>EndDate: (Datetime) 30\/04\/2015 12:00:00 AM<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p class=\"intro-text\">\u00a0<\/p>\n<p class=\"intro-text\"><strong>Step 2.\u00a0\u00a0Add the Show Dataset component to the page<\/strong><\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f728104.png\" rel=\"lightbox-3\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-67394\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f728104-600x351.png\" alt=\"\" width=\"1000\" height=\"585\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f728104-600x351.png 600w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f728104-768x450.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f728104-150x88.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f728104-1080x632.png 1080w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f728104-48x28.png 48w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f728104.png 1266w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/p>\n<p class=\"intro-text\">Drag and drop the Show Dataset\u00a0component\u00a0onto a grid cell.<\/p>\n<p class=\"intro-text\">\u00a0<\/p>\n<p class=\"intro-text\"><strong>Step 3. Configure the Show Dataset component<\/strong>\u00a0<\/p>\n<\/div>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f733a51.png\" rel=\"lightbox-4\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-67395\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f733a51-600x415.png\" alt=\"\" width=\"800\" height=\"554\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f733a51-600x415.png 600w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f733a51-768x531.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f733a51-150x104.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f733a51-48x33.png 48w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/06\/Snag_1f733a51.png 1068w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p class=\"intro-text\">Configure the Show Dataset component as follows:<\/p>\n<ul class=\"intro-text\">\n<li>Dataset Name: MiningDowntimePivot1<\/li>\n<\/ul>\n<p class=\"intro-text\">The name of the dataset must be the same as the name of the dataset shown below the canvas.<\/p>\n<p class=\"intro-text\">As you can see, the data will immediately appear in the table. If there is more data than will fit on the page, scrollbars will also appear.<\/p>\n<p class=\"intro-text\">\u00a0<\/p>\n<div>\n<p class=\"intro-text\"><strong>Step 4. All done!\u00a0\u00a0<\/strong><\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdatasetfinal.png\" rel=\"lightbox-5\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3485\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdatasetfinal.png\" alt=\"\" width=\"1000\" height=\"518\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdatasetfinal.png 1271w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdatasetfinal-150x78.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdatasetfinal-768x398.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdatasetfinal-24x12.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdatasetfinal-36x19.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/showdatasetfinal-48x25.png 48w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/p>\n<p class=\"intro-text\">Great work! You now have a fully functioning Show Dataset that displays the data in a specified dataset.<\/p>\n<ul class=\"intro-text\">\n<li>Click the preview\u00a0<a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/preview.png\" rel=\"lightbox[1419] lightbox-6\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2896\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/preview.png\" alt=\"preview\" width=\"13\" height=\"14\" \/><\/a>\u00a0button on the Studio toolbar\u00a0to see what your page\u00a0will look like in run-time.<\/li>\n<\/ul>\n<p class=\"intro-text\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1348\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/save.png\" alt=\"save\" width=\"48\" height=\"53\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/save.png 48w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/save-22x24.png 22w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/save-33x36.png 33w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/save-43x48.png 43w\" sizes=\"auto, (max-width: 48px) 100vw, 48px\" \/>\u00a0Don\u2019t forget to <a title=\"Saving Your Page\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-create-your-first-page\/saving-your-page\/\">save your page<\/a>!<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This article applies to versions 4.3.2 and earlier of IFS OI Explorer. This component has been deprecated. Overview The Show Dataset component\u00a0allows the user to view the data in the dataset in a tabular format. Configuration is simple: you simply supply the name of the dataset, as follows: \u00a0 Dataset\u2026<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/show-dataset\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":4622,"parent":1407,"menu_order":579,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[11],"tags":[20],"class_list":["post-2690","page","type-page","status-publish","has-post-thumbnail","hentry","category-tutorial","tag-dataset","Product-ex"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/2690","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=2690"}],"version-history":[{"count":5,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/2690\/revisions"}],"predecessor-version":[{"id":67397,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/2690\/revisions\/67397"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/1407"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/4622"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=2690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=2690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=2690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}