{"id":104,"date":"2015-10-05T05:07:34","date_gmt":"2015-10-05T05:07:34","guid":{"rendered":"http:\/\/www.biconnector.com\/blog\/?p=104"},"modified":"2019-08-27T10:05:21","modified_gmt":"2019-08-27T10:05:21","slug":"mash-up-sales-revenue-data-in-obiee-and-revised-target-revenue-in-csv-file-with-tableau-using-bi-connector","status":"publish","type":"post","link":"https:\/\/www.biconnector.com\/blog\/mash-up-sales-revenue-data-in-obiee-and-revised-target-revenue-in-csv-file-with-tableau-using-bi-connector\/","title":{"rendered":"Mash-up sales revenue data in OBIEE and revised target revenue in CSV file with Tableau using BI connector"},"content":{"rendered":"

The Blue Bell Company uses Oracle BI(OBIEE) to store the sales revenue and sales planning data. \u00a0The Blue Bell team likes the meta data management capabilities of OBIEE. \u00a0The sales team likes the ease and simplicity of Tableau. \u00a0They are using BI connector to connect to OBIEE with Tableau.<\/p>\n

For one of the territories\u00a0– Blue Bell sales\u00a0management has provided a revised target revenue. The data has been provided\u00a0in a comma separated value (CSV) file. \u00a0 Meg, the VP\u00a0of Sales asks Mark, the\u00a0Sales Analyst in her office, to prepare a report comparing the revenue data in OBIEE to the target revenue for this\u00a0territory from the CSV file while comparing against the target revenue for other territories from OBIEE. \u00a0<\/span><\/p>\n

So, how can Mark\u00a0bring together data from OBIEE and CSV file into a single report?<\/p>\n

In the past, the only way for Mark\u00a0to do such an analysis was to export data from OBIEE into Excel and then manipulating it in Excel\u00a0based on the revised target revenue. \u00a0But, thanks to BI connector, \u00a0Mark does not have to go through this hassle\u00a0anymore. \u00a0 Mark\u00a0connected directly to OBIEE with Tableau using BI connector and mashed-up the sales revenue data in OBIEE with the revised target revenue data in CSV file. \u00a0Mark was able to generate the\u00a0Revenue vs. Target Revenue Comparison Report in minutes for his VP of sales.<\/p>\n

See the video for how Mark did the mash-up:<\/p>\n