{"id":84,"date":"2015-09-09T08:07:16","date_gmt":"2015-09-09T08:07:16","guid":{"rendered":"http:\/\/www.biconnector.com\/blog\/?p=84"},"modified":"2019-08-27T10:05:21","modified_gmt":"2019-08-27T10:05:21","slug":"extract-obiee-data-in-tableau-desktop","status":"publish","type":"post","link":"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/","title":{"rendered":"Visualizing OBIEE data in Tableau Desktop"},"content":{"rendered":"<p>In the two previous blogs, we looked at how to install and connect to OBIEE subject area in Tableau using BI Connector within a matter of minutes, without any changes to OBIEE and without any help from your IT.<\/p>\n<p>Now, let\u2019s see how the OBIEE subject area folders look like in the worksheet.<\/p>\n<p><a href=\"http:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/10\/Tableau-Image_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-113\" title=\"BI connector - Bar chart visualization of OBIEE data in Tableau\" src=\"http:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/10\/Tableau-Image_2-300x179.png\" alt=\"BI connector - Bar chart visualization of OBIEE data in Tableau\" width=\"302\" height=\"180\" \/><\/a><\/p>\n<p>We saw that the folders in the OBIEE subject area &#8220;Sample Sales Lite&#8221; are tables in Tableau. The fields in the folders in OBIEE are now columns inside the table in Tableau. Now OBIEE just looks like connecting to a database like Oracle from Tableau\u2019s viewpoint!<\/p>\n<p>We recommend hitting the &#8220;Auto pass updates&#8221; at the top before dragging any column on to the worksheet. This will prevent getting more data than needed into Tableau.<\/p>\n<p>Once the pause button is hit, drag the required fields on to the worksheet. In this case we are pulling the Quarter from Time, brand and product from Product table and Order Number from order table and finally the Revenue amount from the Base Facts table. Now to get only the data we need filter by quarter. Then hit the Play button. Now it will run the query on OBIEE get the data into Tableau and you are all set on visualizing the data the way you want in your favorite BI tool!<\/p>\n<p><a class=\"downloadButton\" href=\"https:\/\/www.biconnector.com\/freetrial\/\">Try BI connector Free<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the two previous blogs, we looked at how to install and connect to OBIEE subject area in Tableau using BI Connector within a matter of minutes, without any changes to OBIEE and without any help from your IT. Now, let\u2019s see how the OBIEE subject area folders look like in the worksheet. We saw [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":80,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[76],"tags":[12,14,11,13],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Extract OBIEE data using Tableau Desktop | BI Connector<\/title>\n<meta name=\"description\" content=\"Learn how to extract and incrementally refresh OBIEE data with Tableau desktop using BI Connector.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Extract OBIEE data using Tableau Desktop | BI Connector\" \/>\n<meta property=\"og:description\" content=\"Learn how to extract and incrementally refresh OBIEE data with Tableau desktop using BI Connector.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/\" \/>\n<meta property=\"og:site_name\" content=\"BI connector Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/biconnector\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-09T08:07:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-08-27T10:05:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/09\/Visualize_1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"975\" \/>\n\t<meta property=\"og:image:height\" content=\"549\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"BI Connector Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@bi_connector\" \/>\n<meta name=\"twitter:site\" content=\"@bi_connector\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"BI Connector Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/\"},\"author\":{\"name\":\"BI Connector Team\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9\"},\"headline\":\"Visualizing OBIEE data in Tableau Desktop\",\"datePublished\":\"2015-09-09T08:07:16+00:00\",\"dateModified\":\"2019-08-27T10:05:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/\"},\"wordCount\":232,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/09\/Visualize_1.png\",\"keywords\":[\"OBIEE\",\"Oracle Business Intelligence Enterprise Edition\",\"Tableau\",\"Tableau Desktop\"],\"articleSection\":[\"Solution Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/\",\"url\":\"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/\",\"name\":\"Extract OBIEE data using Tableau Desktop | BI Connector\",\"isPartOf\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/09\/Visualize_1.png\",\"datePublished\":\"2015-09-09T08:07:16+00:00\",\"dateModified\":\"2019-08-27T10:05:21+00:00\",\"description\":\"Learn how to extract and incrementally refresh OBIEE data with Tableau desktop using BI Connector.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#primaryimage\",\"url\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/09\/Visualize_1.png\",\"contentUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/09\/Visualize_1.png\",\"width\":975,\"height\":549,\"caption\":\"OBIEE Subject Area in Tableau, Extract OBIEE Data\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.biconnector.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Visualizing OBIEE data in Tableau Desktop\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#website\",\"url\":\"https:\/\/www.biconnector.com\/blog\/\",\"name\":\"BI connector Blog\",\"description\":\"Blog on BI, Analytics, and Integration\",\"publisher\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.biconnector.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#organization\",\"name\":\"BI Connector\",\"url\":\"https:\/\/www.biconnector.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2018\/09\/logo-1.svg\",\"contentUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2018\/09\/logo-1.svg\",\"width\":1,\"height\":1,\"caption\":\"BI Connector\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/biconnector\",\"https:\/\/x.com\/bi_connector\",\"https:\/\/www.linkedin.com\/company\/bi-connector\",\"https:\/\/www.youtube.com\/channel\/UCDZO-hi2HzjeGChmbjQAW-w\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9\",\"name\":\"BI Connector Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7160ad63033671078ece993f850d16b3?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7160ad63033671078ece993f850d16b3?s=96&d=wavatar&r=g\",\"caption\":\"BI Connector Team\"},\"sameAs\":[\"https:\/\/www.biconnector.com\"],\"url\":\"https:\/\/www.biconnector.com\/blog\/author\/bi-connector-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Extract OBIEE data using Tableau Desktop | BI Connector","description":"Learn how to extract and incrementally refresh OBIEE data with Tableau desktop using BI Connector.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/","og_locale":"en_US","og_type":"article","og_title":"Extract OBIEE data using Tableau Desktop | BI Connector","og_description":"Learn how to extract and incrementally refresh OBIEE data with Tableau desktop using BI Connector.","og_url":"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/","og_site_name":"BI connector Blog","article_publisher":"https:\/\/www.facebook.com\/biconnector","article_published_time":"2015-09-09T08:07:16+00:00","article_modified_time":"2019-08-27T10:05:21+00:00","og_image":[{"width":975,"height":549,"url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/09\/Visualize_1.png","type":"image\/png"}],"author":"BI Connector Team","twitter_card":"summary_large_image","twitter_creator":"@bi_connector","twitter_site":"@bi_connector","twitter_misc":{"Written by":"BI Connector Team","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#article","isPartOf":{"@id":"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/"},"author":{"name":"BI Connector Team","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9"},"headline":"Visualizing OBIEE data in Tableau Desktop","datePublished":"2015-09-09T08:07:16+00:00","dateModified":"2019-08-27T10:05:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/"},"wordCount":232,"commentCount":0,"publisher":{"@id":"https:\/\/www.biconnector.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#primaryimage"},"thumbnailUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/09\/Visualize_1.png","keywords":["OBIEE","Oracle Business Intelligence Enterprise Edition","Tableau","Tableau Desktop"],"articleSection":["Solution Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/","url":"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/","name":"Extract OBIEE data using Tableau Desktop | BI Connector","isPartOf":{"@id":"https:\/\/www.biconnector.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#primaryimage"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#primaryimage"},"thumbnailUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/09\/Visualize_1.png","datePublished":"2015-09-09T08:07:16+00:00","dateModified":"2019-08-27T10:05:21+00:00","description":"Learn how to extract and incrementally refresh OBIEE data with Tableau desktop using BI Connector.","breadcrumb":{"@id":"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#primaryimage","url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/09\/Visualize_1.png","contentUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/09\/Visualize_1.png","width":975,"height":549,"caption":"OBIEE Subject Area in Tableau, Extract OBIEE Data"},{"@type":"BreadcrumbList","@id":"https:\/\/www.biconnector.com\/blog\/extract-obiee-data-in-tableau-desktop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.biconnector.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Visualizing OBIEE data in Tableau Desktop"}]},{"@type":"WebSite","@id":"https:\/\/www.biconnector.com\/blog\/#website","url":"https:\/\/www.biconnector.com\/blog\/","name":"BI connector Blog","description":"Blog on BI, Analytics, and Integration","publisher":{"@id":"https:\/\/www.biconnector.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.biconnector.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.biconnector.com\/blog\/#organization","name":"BI Connector","url":"https:\/\/www.biconnector.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2018\/09\/logo-1.svg","contentUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2018\/09\/logo-1.svg","width":1,"height":1,"caption":"BI Connector"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/biconnector","https:\/\/x.com\/bi_connector","https:\/\/www.linkedin.com\/company\/bi-connector","https:\/\/www.youtube.com\/channel\/UCDZO-hi2HzjeGChmbjQAW-w"]},{"@type":"Person","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9","name":"BI Connector Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7160ad63033671078ece993f850d16b3?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7160ad63033671078ece993f850d16b3?s=96&d=wavatar&r=g","caption":"BI Connector Team"},"sameAs":["https:\/\/www.biconnector.com"],"url":"https:\/\/www.biconnector.com\/blog\/author\/bi-connector-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/84"}],"collection":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/comments?post=84"}],"version-history":[{"count":9,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/84\/revisions"}],"predecessor-version":[{"id":656,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/84\/revisions\/656"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/media\/80"}],"wp:attachment":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/media?parent=84"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/categories?post=84"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/tags?post=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}