content embedding - businessobjects and tableau
TRANSCRIPT
Agenda
Web intelligence with TableauDrill down in a WebI Report to change Tableau Visualization
Tableau with Web IntelligenceDrill down a Tableau Chart to Change WebI report output
Best Practices BO with Tableau Co-existence
1
2
3
<iFrame> Container
="<iframe align = 'left' align = 'top' height='770px' width='1030px' frameborder='30' src='http://[…..url….]/'></iframe>"
Hyper Link Formula in WebI="<a href=<tableau Link>:refresh=yes&:linktarget=_self&Customer%20State="+[Customer State] +"\" + target=\"TableauView\">"+[Customer State]+"</a>"
<tableau Link> from your Tableau server
Iframe Formula="<iframe id=\"TableauView\" name=\"TableauView\" align = 'left' align = 'top' height='800px' width='1000px' frameborder='30' src='[Hyperlink]'></iframe>"
Tableau URL Parameters
• Adding Filters to Emded Code– https://help.tableau.com/current/pro/desktop/en-us/embed_filter_add.htm
• Sharing Web Content– https://help.tableau.com/current/pro/desktop/en-us/shareworkbooks.htm
• View URLS– https://help.tableau.com/current/pro/desktop/en-us/embed_structure.htm
Web Intelligence
• Popular SAP BusinessObjects Self-service reporting tool – Easy for end users
• Drag and drop
• Connects to any data base via Universe & Free hand SQL
• Native SAP Connections – BW/Bex , HANA
Best Practices
• Keep WebI for Reporting and Use Tableau for Dashbaording
• Keep in mind - No Semantic Layer in Tableau
• Use Tools such as InfoBurst to leverage BusinessObjects with Tableau
Data Sources
Burst
Excel Files
SQL Queries fromany Database
Web Intelligence
BusinessObjects + Tableau
References
• A Gazillion Examples of Web Intelligence Enhancements with HTMLhttps://www.youtube.com/watch?v=2RpyN5dH_v4
• HTML Examples
https://www.w3schools.com/html/default.asp
• Tableau Calculated Fields
https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_create.htm
• Tableau Parameters
https://help.tableau.com/current/pro/desktop/en-us/parameters_create.htm
• Tableau Level of Detail Calcs
https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm