SAP BusinessObjects Dashboard Builder Content Linking

SAP BusinessObjects DashboardBuilder Content LinkingApplies to:SAP BusinessObjects Enterprise XI 3.1, SAP BusinessObjects Edge BI 3.1, and Crystal Reports Server2008 v1SummaryThis paper contains two quick tutorials how to link between two Dashboard Design analytics, and how to linkbetween Dashboard Design analytics and Web Intelligence/Crystal Reports, using the Dashboard Buildercontent linking feature.Author:Fritz FeltusCompany: SAPCreated on: 17 August 2010Author BioFritz works as a Presales Consultant in the EMEA region, focusing on Business Intelligence solutions.SAP COMMUNITY NETWORK 2010 SAP AGSDN - sdn.sap.com BPX - bpx.sap.com BOC - boc.sap.com UAC - uac.sap.com1

SAP BusinessObjects Dashboard Builder Content LinkingTable of ContentsIntroduction . 3SWF to SWF (Content Linking between two or more Dashboard Design analytics) . 3Create the Provider Analytic . 3Create the Consumer Analytic . 5Create dashboard with Content Linking . 6SWF (Dashboard Design) to Crystal Reports and Web Intelligence . 7Create the Provider Analytic . 7Create the Target Report . 8Crystal Reports . 8Web Intelligence . 9Create Dashboard with Content Linking . 9Related Content . 11Copyright. 12SAP COMMUNITY NETWORK 2010 SAP AGSDN - sdn.sap.com BPX - bpx.sap.com BOC - boc.sap.com UAC - uac.sap.com2

SAP BusinessObjects Dashboard Builder Content LinkingIntroductionIn SAP BusinessObjects Enterprise XI 3.1, SAP BusinessObjects Edge BI 3.1 and SAP Crystal ReportsServer 2008 v1, the new Interportlet Communication (IPC) feature in Dashboard Builder allows the transferof information between distinct analytics. Now you can pass parameters from a Dashboard Design(previously known as Xcelsius) analytic to Crystal Reports and Web Intelligence, and also between two ormore Dashboard Design analytics.Using the Dashboard Builder framework, this paper contains two simple tutorials how to link between: Two Dashboard Design analyticsDashboard Design and Web Intelligence/Crystal ReportsSWF to SWF (Content Linking between two or more Dashboard Design analytics)A Dashboard Design analytic when used as a source document has to be configured with a Portal ProviderConnection. The target analytic has to be configured with the Portal Consumer Connection.We will send parameter data between two analytics with the use of a simple example: sending informationfrom a radio button selector in one analytic to populate a label component in another.Create the Provider Analytic1. Create a radio button component in Dashboard Design. Enter some sample data in rows A1-A3 asbelow. Designate the location for the selected item (the B1 cell in the example).SAP COMMUNITY NETWORK 2010 SAP AGSDN - sdn.sap.com BPX - bpx.sap.com BOC - boc.sap.com UAC - uac.sap.com3

SAP BusinessObjects Dashboard Builder Content Linking2. Click the Fit canvas to components icon in the toolbar.3. Create a new Portal Data connection in the Data Manager. Choose Provider as connection type.Enter a name (e.g. “Sample”) for Range Name. Choose Cell for Range Type. Choose B1 as therange.4. In the Usage tab for the Provider Connection, choose the B1 cell for the Trigger Cell option. Selectthe When Value Changes option as well.5. Save the XLF file and export the SWF file as “Provider” to a folder on your BusinessObjects platform.SAP COMMUNITY NETWORK 2010 SAP AGSDN - sdn.sap.com BPX - bpx.sap.com BOC - boc.sap.com UAC - uac.sap.com4

SAP BusinessObjects Dashboard Builder Content LinkingCreate the Consumer Analytic1. Drag a Label component on to the blank canvas and designate the A1 cell as the input area for thecomponent (Link to cell). Then fit canvas to components.2. In Data Manager, create a consumer “Portal Data” connection. Enter the same name as before forRange Name (e.g. “Sample”), Range Type “Cell”, and choose “A1” as range.3. Save the file. Export the SWF as Consumer to your BusinessObjects platform.SAP COMMUNITY NETWORK 2010 SAP AGSDN - sdn.sap.com BPX - bpx.sap.com BOC - boc.sap.com UAC - uac.sap.com5

SAP BusinessObjects Dashboard Builder Content LinkingCreate dashboard with Content Linking1. Log on to InfoView. Create a new Corporate Dashboard. Drag the Provider and Consumer analyticsonto the dashboard.2. Activate Content Linking. Choose the Provider analytic as the Source Analytics. Choose Consumeras the Target Analytics.3. Save the dashboard. Test the content linking by choosing values in the radio buttons. The chosendepartment is displayed in the Consumer analytic.SAP COMMUNITY NETWORK 2010 SAP AGSDN - sdn.sap.com BPX - bpx.sap.com BOC - boc.sap.com UAC - uac.sap.com6

SAP BusinessObjects Dashboard Builder Content LinkingSWF (Dashboard Design) to Crystal Reports and Web IntelligenceA Dashboard Design analytic used as a source document for Crystal Reports and Web Intelligence has to beconfigured with the FS Command connectivity. The parameters are then assembled in an OpenDocumentURL by the Dashboard Builder framework. For more information about the OpenDocument syntax, pleaserefer to Viewing Reports and Documents using URLs.The connectivity between Dashboard Design and Crystal Reports and Web Intelligence is particularlyinteresting when summary data is displayed in the dashboard analytic, and a facility is provided for analyzingrelated details in a separate report.Create the Provider Analytic1. Open the provider analytic created in the SWF to SWF tutorial above.2. Add a new FS Command connection using the Data Manager. Enter a name for the connection,“queryparams”, for Command (required). Choose cell B2 for the parameter input.3. In the FS Command Usage tab, choose cell B2 as the trigger cell, “When Value Changes”.4. A single parameter is sent to a target Webi or Crystal report. The parameter name will be“Department”. Adhering to the OpenDocument syntax (as mentioned in the introduction), theparameter name will be lsSDepartment.Create a formula in cell B2 which concatenates the value from B1 with “&lsSDepartment ” asfollows: "&lsSDepartment "&B1SAP COMMUNITY NETWORK 2010 SAP AGSDN - sdn.sap.com BPX - bpx.sap.com BOC - boc.sap.com UAC - uac.sap.com7

SAP BusinessObjects Dashboard Builder Content Linking5. Save the analytic back to the BusinessObjects platform.Create the Target ReportUsing either Web Intelligence or Crystal Reports, create a report which receives a parameter calledDepartment and displays the input back to the user.Crystal Reports1. In Crystal Reports, create a blank report and create a static parameter called Department.2. Drag the parameter onto the report to display the user input.3. Save the Crystal Report to the BusinessObjects platform.SAP COMMUNITY NETWORK 2010 SAP AGSDN - sdn.sap.com BPX - bpx.sap.com BOC - boc.sap.com UAC - uac.sap.com8

SAP BusinessObjects Dashboard Builder Content LinkingWeb Intelligence1. In Web Intelligence, create a new document with a prompt called “Department”.2. Display the prompt on the report in a blank cell using the UserResponse() function.3. Save the Webi report to the BusinessObjects platform.Create Dashboard with Content Linking1. Log on to InfoView. Create a new Corporate Dashboard. Drag your Provider and Consumeranalytics onto the dashboard.2. Activate Content Linking. Choose the Provider analytic as the Source Analytics, and ConsumerWebi, Crystal and DD analytics as the Target Analytics.SAP COMMUNITY NETWORK 2010 SAP AGSDN - sdn.sap.com BPX - bpx.sap.com BOC - boc.sap.com UAC - uac.sap.com9

SAP BusinessObjects Dashboard Builder Content Linking3. Save the dashboard. Exit edit mode. Test the content linking by choosing values in the radio buttons.The chosen department is displayed in the Consumer analytic.SAP COMMUNITY NETWORK 2010 SAP AGSDN - sdn.sap.com BPX - bpx.sap.com BOC - boc.sap.com UAC - uac.sap.com10

SAP BusinessObjects Dashboard Builder Content LinkingRelated ContentOpenDocument User GuideDashboard Builder User GuideSAP COMMUNITY NETWORK 2010 SAP AGSDN - sdn.sap.com BPX - bpx.sap.com BOC - boc.sap.com UAC - uac.sap.com11

SAP BusinessObjects Dashboard Builder Content LinkingCopyright Copyright 2010 SAP AG. All rights reserved.No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG.The information contained herein may be changed without prior notice.Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation.IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x, System z, System z10, System z9, z10, z9,iSeries, pSeries, xSeries, zSeries, eServer, z/VM, z/OS, i5/OS, S/390, OS/390, OS/400, AS/400, S/390 Parallel Enterprise Server,PowerVM, Power Architecture, POWER6 , POWER6, POWER5 , POWER5, POWER, OpenPower, PowerPC, BatchPipes,BladeCenter, System Storage, GPFS, HACMP, RETAIN, DB2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex, MVS/ESA, AIX,Intelligent Miner, WebSphere, Netfinity, Tivoli and Informix are trademarks or registered trademarks of IBM Corporation.Linux is the registered trademark of Linus Torvalds in the U.S. and other countries.Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe SystemsIncorporated in the United States and/or other countries.Oracle is a registered trademark of Oracle Corporation.UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks ofCitrix Systems, Inc.HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C , World Wide Web Consortium, MassachusettsInstitute of Technology.Java is a registered trademark of Sun Microsystems, Inc.JavaScript is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented byNetscape.SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentionedherein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries.Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, andother Business Objects products and services mentioned herein as well as their respective logos are trademarks or registeredtrademarks of Business Objects S.A. in the United States and in other countries. Business Objects is an SAP company.All other product and service names mentioned are the trademarks of their respective companies. Data contained in this documentserves informational purposes only. National product specifications may vary.These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies ("SAPGroup") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors oromissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in theexpress warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting anadditional warranty.SAP COMMUNITY NETWORK 2010 SAP AGSDN - sdn.sap.com BPX - bpx.sap.com BOC - boc.sap.com UAC - uac.sap.com12

Two Dashboard Design analytics Dashboard Design and Web Intelligence/Crystal Reports SWF to SWF (Content Linking between two or more Dashboard Design analytics) A Dashboard Design analytic when used as a source document has to be configured with a Portal Provider Connection. The target a