Hands-on dashboards
Now it's time for you to create your data sources. In order to display the results from the queries, in the next chapter, you should create a CDA file with the following content:
<?xml version="1.0" encoding="utf-8"?> <CDADescriptor> <!—-Data source for the dashboard, a unique data source is used for all connections--> <DataSources> <Connection id="SampleData" type="mondrian.jndi"> <Jndi>SampleData</Jndi> <Catalog>mondrian:/SteelWheels</Catalog> <Cube>SteelWheelsSales</Cube> </Connection> </DataSources> <!-—Data Access to get the territories values--> <DataAccess id="territories" connection="SampleData" type="mdx" access="public"> <Name>territories</Name> <BandedMode>compact</BandedMode> <Query> WITH MEMBER [Measures].[UID] ...
Get Learning Pentaho CTools now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
