This article provide an overview of the XDC. Please review content in Dashboard Data Management & Delivery for details about XDC usage scenarios.


What is an XDC?


The XML Data Cache (XDC) is a unit of execution containing one or more blocks of cache data to be used in an dashboard. The XDC can include data from multiple sources and includes options for formatting and aggregating the data. When executed manually or via a schedule, the XDC results in one or more caches of data. The data cache is then accessed from the dashboard via a proprietary connector component or embedded in the dashboard (SWF) for offline delivery. When consumed from a dashboard, the cache can be secured in a variety of ways, including Windows authentication.


XDC Data sources include:

  • SAP BusinessObjects Web Intelligence
  • Database Query
  • Excel

 XDC Panel


lfldAfONCF1ZERdCr63vY39k72_FXH9QOw.png

  1. Name: XDC Name
  2. Description: XDC description
  3. ID: XDC ID number
  4. Disable: Option to disable the XDC
  5. Data Sources: Data source(s) in the XDC
  6. Source: Configure selected data source
  7. Source Optimizations: Optimization options for selected data source
  8. Data Linking and Security: Define data source parameters and cache security
  9. Cache Queries: Define SQL queries against a data source
  10. History: XDC activity log and execution history
  11. XDC Properties: XDC properties and XDC-level actions
  12. Summary: XDC summary information
  13. Refresh Now: Refresh the XDC

Data Sources

Database

Add data from a database query to a cache. Options available for this data source type include:
  • Data Souce: Selected data source
  • Query: Available queries from data source
  • Name: User-supplied name for selected data set
  • Columns: Columns available from selected query
  • CrossTab: Optional crosstab formatting
  • Options: Cache options
  • Optimizations: Data source optimization options

CrossTab

The CrossTab option enables creation of a simple crosstab using the available columns. The resulting data will be stored and provided to the dashboard in crosstab format. Select and drag a column to the appropriate section of the crosstab.

CrossTab Options
  • Select the mF8HkA4fsqMpktDvOVFDUY7szuQy4HiKmA.png button to expand the Options panel
  • Row/Column Totals: Select placement of results of row or column level calculations then select calculation type
  • Summary Formatting: Select formatting type of summary data
  • Select the Set button to commit selections

Web Intelligence

Add a Web Intelligence document to utilize a part or block of data from that document. A part is a table of data contained within the document. Options available for this data source type include:
  • Data Source: Selected data source
  • Report Tab: Available report tabs from selected Web Intelligence document
  • Selected Part: Selected report part
  • Name: User-supplied name for selected report part
  • Optimizations: Data source optimization options
  • Select the Add or Set button to commit selections

Excel

Add an Excel document to utilize a part or range of data from an Excel worksheet. A part is a table of data contained within the document. Options available for this data source type include:
  • Data Source: Selected data source
  • Sheets: Available worksheets from selected Excel document
  • Parts in Worksheet: Available parts from selected worksheet. Select the magnifying glass button to preview a part.
  • Selected Part: Selected report part
  • Manual Range: Select to define a range manually
    • Syntax: [SHEET]@[RANGE]
  • Name: User-supplied name for selected report part
  • Optimizations: Data source optimization options
  • Select the Add or Set button to commit selections

Optimizations
  • Max number of rows to generate: Select the number of rows to generate in XML (Default=500, Max=9999)
    • The data resulting from an XDC refresh is stored in the InfoBurst database repository (cache). XML is generated from this data for use by a dashboard using the Cache Connector. Due to the functional limitations of Xcelsius, the XML generated from a single cache cannot exceed 9999 rows. There is no functional limit on the size of the cache. Only the XML resulting from a cache has a limit. It is recommended that Cache Query be used for larger data sets.
  • Decimal output rounding: Select this option to round decimals and control precision
  • Number of header rows (WebI/Excel only): Define the number of header rows in a multi-header row crosstab table. Used in conjunction with Header row for cache query columns.
  • Header row for cache query columns (WebI/Excel only): Define which row in a multi-header row crosstab table will be used as the header row for a cache query
  • Keep Original Formatting (WebI only): Retain data formatting defined in the WebI report
    • Example: Report cell contains number 3.50. Cell is formatted $3.50. This option converts the value to a string to retain the formatting.
  • Optimize Cache Load (Database Query only)Generate data caches that exceed the 4GB RAM limit for 32bit applications

Data Linking and Security

Cache Queries

Create and manage cache queries.


History


View current and past Activity Logs.


XDC Properties

Configure XDC options.


Preview Cache

The XML resulting from an XDC can be previewed via web browser.
  • Cache: http://[SERVER]:8551/infoburst/rest/get/xdc/[XDCID]
  • Cache with Key: http://[SERVER]:8551/infoburst/rest/get/xdc/[XDCID]?k=[VALUE]
  • Cache Query: http://[SERVER]:8551/infoburst/rest/exec/xdcqry/[XDCID]?q=[QUERY]
  • Cache Query with Parameter: http://[SERVER]:8551/infoburst/rest/exec/xdcqry/[XDCID]?q=[QUERY]&[PARAMETER]=[VALUE]

See Also