PrintNumber ErrorLocation Error Correction DateAdded
1 p iii First Printing September 2008 Second Printing May 2010 4/27/2010
1 p 461 Learning to work with the components is critical to understanding how to tap into the visualization power of Crystal Xcelsius. Let’s get started with the following steps: Learning to work with the components is critical to understanding how to tap into the visualization power of Xcelsius. Let’s get started with the following steps: 4/27/2010
1 p 472 • Insertion Type—The insert type dictates how labels, source data, and destination work together to create the desired selector functionality.
• Labels—The labels that end users view and interact within the selector interface.
• Source Data—The source data associated with each label. The insertion type dictates the source data.
• Insertion Type—The insert type dictates how labels, source data, and destination work together to create the desired selector functionality.
• Labels—The labels that end users view and interact within the selector interface.
• Source Data—The source data associated with each label. The insertion type dictates how source data is associated with labels.
4/27/2010
1 p 474 Container components streamline the process for navigating groups of components. Both the Panel Container and Tab Set components visually group objects as you add them from the Components window into the container canvases. The Tab Set component provides additional utility with multiple canvases and a tab navigation paradigm to navigate to each view. Container components streamline the process for navigating groups of components. Both the Panel Container and Tab Set components visually group objects as you add them from the Components window into the container canvases. The Tab Set component provides additional utility with multiple canvases and a tab navigation paradigm to toggle between each view. 4/27/2010
1 p 475 8. Drag and drop the sales chart and combo box selector from the previous exercise into the Sales tab. 8. Drag and drop the sales chart and combo box selector from the previous exercise into the canvas associated with the Sales tab. 4/27/2010
1 p 478 11. Click on the Auto Alerts icon, located on the right side of the Enable Auto Colors. A pop-up window displays multiple alert color options to satisfy color-blind users. Review these color options before moving back to your report to preview the results of your alert-activated gauge. 11. Click on the Auto Alerts icon, located on the right side of the Enable Auto Colors. A pop-up window displays multiple alert color options to satisfy all alert color combinations. Review these color options before moving back to your report to preview the results of your alert-activated gauge. 4/27/2010
1 p 479 The freeform approach of Xcelsius to designing dashboards provides maximum flexibility in layout and content options. The control that Xcelsius provides over color selection and stylized graphics is streamlined to easily create aesthetics that match or complement any design standards. Xcelsius enables a freeform approach to dashboard design, providing maximum flexibility in layout and content design. The control that Xcelsius provides over color selection and stylized graphics is streamlined to easily create aesthetics that match or complement any design standards. 4/27/2010
1 p 483 The Image component is recommended for JPGs and SWFs generated by Flash or Flex using ActionScript 3. Although you can nest a published Xcelsius dashboard inside a parent Xcelsius project, I recommend using the Slideshow component for multilayer dashboards. The Image component is recommended for JPGs and SWFs generated by Flash. Although you can nest a published Xcelsius SWF file inside a parent Xcelsius project, the Slideshow component is a better option for dashboards. 4/27/2010
1 p 486 The processes for matching technical Xcelsius features with functional dashboard requirements desired by end users presents several challenges. In Chapter 21, you will also learn how to integrate Xcelsius with Crystal Reports and Business Objects. The processes for matching technical Xcelsius features with functional dashboard requirements desired by end users presents several challenges. You can solve these issues using basic features from this chapter, and advanced features and connectivity that you will explore in the next chapter. In Chapter 21, you will also learn how to integrate Xcelsius with Crystal Reports and Business Objects. 4/27/2010
1 p 488 All the basic component categories introduced in the previous chapter have advanced features that you can harness to enhance a dashboard. Using existing components, you will learn how to apply advanced features and techniques to provide granular control over the user experience and to provide increasingly powerful data display and navigation. All the basic component categories introduced in the previous chapter have advanced features that you can harness to enhance a dashboard. Using existing components, you will learn how to apply advanced features and techniques to provide concise control over the user experience and to provide increasingly powerful data display and navigation. 4/27/2010
1 p 488 1. Open a new Xcelsius project with a blank Excel sheet.
2. Rename the Excel tab to Dynamic Visibility by double-clicking on the tab located in the lower-left corner of the Excel window. By default the tab will be Sheet1.
Navigate within the Components window to the Charts components category and insert both a pie chart and a column chart.
3. Navigate to the Selectors components category and insert a radio button selector.
4. Open the Radio Button Properties window by double-clicking or right-clicking on the component.
1. Open a new Xcelsius project with a blank Excel sheet.
2. Rename the Excel tab to Dynamic Visibility by double-clicking on the tab located in the lower-left corner of the Excel window. By default the tab will be Sheet1.
Navigate within the Components window to the Charts components category and insert both a pie chart and a column chart.
3. Navigate within the Components window to the Charts components category and insert both a pie chart and a column chart.
4. Navigate to the Selectors components category and insert a radio button selector.

Then renumber the remaining steps.
4/27/2010
1 p 494 The Map Components category in Xcelsius features an extensive collection of maps that you can use as navigation controls and as visual alert indicators. Xcelsius maps are configured to work similar to selectors, but with a few variances due to the Region Labels property already defined. In the next exercise, a world map enables the user to display values and drill into detailed information. The Map Components category in Xcelsius features an extensive collection of maps that you can use as navigation controls and as visual alert indicators. Xcelsius maps incorporate selector functionality except for Region Labels, which are hardcoded into each map. In the next exercise, a world map enables the user to display values and drill into detailed information. 4/27/2010
1 p 498 Multilayer dashboards are extremely powerful for scaling a dashboard that might contain a high volume of charts and analytics. This feature also provides a nice way to “componentize” a large dashboard project as multiple files, making it much easier to manage and edit. Although Dynamic Visibility and container components provide a similar end user experience, a multilayer dashboard is the only way to combine multiple disconnected Xcelsius dashboards into a single seamless interface. Multilayer dashboards are extremely powerful for scaling a dashboard that might contain a high volume of charts and analytics. This feature also provides a nice way to “componentize” a large dashboard project as multiple files, making it much easier to manage and edit. Although Dynamic Visibility or container components are capable of providing a similar end user experience, a multilayer dashboard is the only way to combine multiple disconnected Xcelsius SWFs into a single seamless interface. 4/27/2010
1 p 500 The logic evaluates a logical statement and then enters designated value when the condition is TRUE or FALSE. The logic first evaluates a statement and then enters a defined value if the statement is TRUE or FALSE. 4/27/2010
1 p 503 13. Insert the following INDEX function into cell C1:
=INDEX(B4:C4,1,B1)
14. Insert the following INDEX function into cell C2:
=INDEX(A5:A6,B2,1)
13. Insert the following INDEX function into cell C1 to lookup the region.
=INDEX(B4:C4,1,B1)
14. Insert the following INDEX function into cell C2to lookup the region.
=INDEX(A5:A6,B2,1)
4/27/2010
1 p 506 The connection refresh options provide granular control over events that trigger a single query to refresh. Xcelsius can trigger a query to refresh when a dashboard is loaded, on a time-based interval, or using a Trigger Cell event. A Trigger Cell is a single cell that serves as a listener for a specific event. When one of the following events occur, the query will refresh. The connection refresh options provide concise control over events that trigger a single query to refresh. Xcelsius can trigger a query to refresh when a dashboard is loaded, on a time-based interval, or using a Trigger Cell event. A Trigger Cell is a single cell that serves as a listener for a specific event. When one of the following events occur, the query will refresh. 4/27/2010
1 p 508 With the exception of a Live Office connection, all web service connectors have a bindable web service URL. That URL can be controlled through Flash variables to provide a seamless transition from production to development. Flash variables are covered later in this chapter. All web service connectors have a bindable URL that can be modified using Flash variables, which can facilitate a seamless migration from development to production environments. Flash variables are covered later in this chapter. 4/27/2010
1 p 514 QaaWS comes packaged with BusinessObjects Enterprise Professional and employs a client tool that resembles the Web Intelligence query panel to generate web services. Xcelsius can leverage these web services using a native QaaWS connector in the Xcelsius Data Manager. The primary benefit of using QaaWS is the alleviation of writing reports or a reliance on Live Office for configuring connectivity. The following exercise explains the process for binding an existing Universe query into the Data Manager. QaaWS comes packaged with BusinessObjects Enterprise Professional and employs a client tool that resembles the Web Intelligence query panel to generate web services. Xcelsius can leverage these web services using a native QaaWS connector in the Xcelsius Data Manager. The primary benefit of using QaaWS is the alleviation of writing reports or a reliance on Live Office for configuring connectivity. 4/27/2010
1 p 518 8. Test the connection by clicking on the File menu and then on Export Preview. Export preview will generate an SWF and load it inside your default Internet browser. XML Maps connectivity will not work inside the Xcelsius designer.
Launching Parameterized Reports from Xcelsius
Xcelsius can launch parameterized reports that provide additional analysis to supplement the dashboard. A URL Button component coupled with Excel logic will transform a static URL into a dynamic URL driven by a selector to launch Crystal and Web Intelligence reports.
8. Test the connection by clicking on the File menu and then on Export Preview. Export preview will generate an SWF and load it inside your default Internet browser.
Launching Parameterized Reports from Xcelsius
Xcelsius can launch parameterized reports, enabling an end user to explore detailed information associated with a dashboard. This seamless navigatin to Crystal and Web INtelligence reports, is configured using parameterized URLs. Extending a dashboard to launch parameterized reports also creates contextual drill through for end users as they transition between technologies.
4/27/2010
1 p 519 Using Flash Variables
Xcelsius dashboards are capable of consuming variables from HTML using the Flash variables connection. Flash variables provide a data push method to Xcelsius, using comma-
separated values or XML. Flash variables can originate as nested variables inside HTML or as appended parameters to the end of a URL string. Flash variables are the first events that trigger when an SWF initializes before any other connector or event. In both examples shown later, the variable name is XcelsiusVar1, which is defined as a Flash variable inside the Data Manager.
Using Flash Variables
Xcelsius dashboards are capable of consuming variables from HTML using the Flash variables connection. Flash variables provide a data push method to Xcelsius, using comma-
separated values or XML. Flash variables are the first events that trigger when a SWF initializes before any other connector or event. In the example shown later, the variable name is XcelsiusVar1, which is defined as a Flash variable inside the Data Manager.
4/27/2010
1 p 520 URL String
http://servername/ RevenueDashboard.swf?XcelsiusVar1=Product
HTML
<OBJECT classid=”clsid:D27CDB6E-AE6D-11cf-96B8-444553540000”
codebase=”http://fpdownload.adobe.com/pub/shockwave/cabs/flash/
swflash.cab#version=9,0,0,0”
HTML
<OBJECT classid=”clsid:D27CDB6E-AE6D-11cf-96B8-444553540000”
codebase=”http://fpdownload.adobe.com/pub/shockwave/cabs/flash/
swflash.cab#version=9,0,0,0”
4/27/2010