Web Intelligence Training. You will need the assistance of your BusinessObjects Administrator to carry out these instructions in your default eFashion universe. I am using BO4.0. I have installed client in my Machine. Now I am importing the efashion Universe. Its giving me connection error. I have tried creating System DSN in my machine. But I didnot get MDB file for efashion universe. In privious version we used to get these Demo universes files in DataConnetion folders But here I.

Lesson 6: Synchronizing Data Creating multiple queries in a document Projecting data from a single query in different blocks In this example, you will create a document to analyze the Sales revenue figures for the last three years and display the Sales revenue per store: Block 1 will show the sales revenue of the stores in the eFashion database for different years. Block 2 will show only a subset of this information from the same query. To project data from a single query in multiple blocks • In the Java Report Panel, create a new document using the eFashion universe using the Store name, Year and Sales revenue objects.

• Click Run Query. The Edit Report view appears and a new vertical table has been created, showing sales revenue calculated for each store and per year. • In the Report Manager Data tab, click the Store name object, hold down the Ctrl key and click Sales revenue.

• Drag both objects together and drop them in the space next to the first block of data. The new report now displays two blocks of data: • Block 1: Shows sales revenue calculated for each store and per year. • Block 2: Shows the overall sales revenue calculated per store, all years combined. Both blocks were built using data from a single query. • Save the document to Favourites as Multi Block 1. Projecting data from multiple queries using a single universe Now you are going to add a third block of data to the report. This time you will add a new query to retrieve new data from the eFashion universe.

Continue working with the same document. To project data from two queries in multiple blocks • Click Edit Query to begin adding the second query. • While in Edit Query view, click the Add Query button on the toolbar. The Universe dialog box displays. • Select eFashion as the data source for the second query.

A second Edit Query view appears. Note that at the bottom of the panel, there are two tabs now: Query 1 and Query 2. Matrox Rt2500 Installation Cd. You can use these tabs to toggle back and forth between the two query definitions. • In the Query 2 tab, move the Store name and Margin objects into the Result Objects pane. • Click the Properties tab The Query Properties panel for Query 2 displays.

• In the Name field, type Margin Query and press the Return key to replace the default name of this query. • Click the Query 1 tab. The Edit Query view switches to the query definition for Query 1.

• Right-click the Query 1 tab. • Select Rename Query from the drop-down menu. • In the Name field, type Revenue Query and press the Return key to replace the default name of the first query as well. Click the drop-down arrow next to the Run Queries button.

The drop-down menu allows you to decide if you want to run only one of the queries in the document, or all of them at once. • Select Margin Query from the Run Queries drop-down menu. The New Query dialog box displays. The options to include the data from the new query in the report are listed. • In the New Query dialog box, select the Insert a table in the current report option and click OK. Web Intelligence executes both queries and projects the new data in a new table in the report.

Note: The new table may be positioned anywhere in the report, even on top of the existing tables. Scroll in the report to find where the new table has been projected, then drag and drop it to the appropriate blank space in the report.

The objects you selected in the Margin query appear in the Edit Report Data tab. • Click + next to the Store name object in the Data tab. The folder expands. Expanded, the folder displays two Store name objects. This indicates that the same object has been used in two different queries, once in the Margin query and once in the Revenue query.

The top-level Store name object is identified by a double-cubed, blue dimension icon, indicating that the two have been automatically merged to create a single-dimension object. Now you are ready to project the data from both queries into a single block in the report. Continue working with the same document. To project data from a merged dimension into a single block • Insert a new report in the document.

• In the Data tab, click the Store name merged object, hold down the Ctrl key and click the Sales Revenue and Margin objects. • Drag all objects and drop them into the new report. The aggregate data to calculate sales revenue per store and margin per store has been retrieved by two different queries, but you are still able to combine both in a single block of data. • Save the document to Favourites as Multi Block 2. Projecting data from queries using multiple universes Your first report now shows sales revenue and margin for each of the stores in two blocks of data. Your second report shows data from both queries in a single block, because you have been able to project the automatically merged dimension into a column in the table.

So far, you have used data only from the eFashion universe to produce the blocks in both reports. These blocks are views of data providers with data retrieved using the eFashion universe. Now you are going to add a second block to Report 2 using data retrieved from a different universe. This block will show the number of employees that work at each store. This can help you analyze how a store's staffing level affects the sales revenue. In this next step, you add a query to the document using the eStaff universe.

Continue working with the document from the previous exercise. To display data from two data sources in multiple blocks • Make sure the Multi Block 2 document is still open in the Java Report Panel. Elusidasi Struktur Senyawa Organik Pdf Files. • Click Edit Query to begin adding the second query. • While in the Edit Query view, click the Add Query button on the toolbar. The Universe dialog box displays. • Select eStaff as the data source for the third query.

A third Edit Query view appears. Note that at the bottom of the panel, there are three tabs now: Revenue query, Margin query and Query 3. You can use these tabs to toggle back and forth between the three query definitions. • In the Query 3 tab, move the Store and Number of Employees objects into the Result Objects pane. • Click the Properties tab. • In the Name field, type Employee query and press the Return key to replace the default name of the first query as well.

• Click the drop-down arrow next to the Run Queries button. • Select Employee query. • In the New Query dialog box, this time select the Include the results objects without generating a table option and click OK. The Store and Number of Employees objects in the 'Employee query', from the eStaff universe, now appear in the Data tab. • In Report 2, click the Store object, hold down the Ctrl key, click the Number of Employees object, then drag them from the Data tab until they are positioned next to the existing table in the document zone.

A new table is inserted next to the existing table and the table from the Employee query is projected into the new table. • Save the document to Favourites as Multi Block 3.

You have now displayed data from two different data sources in two tables side-by-side in the report. These tables allow you to compare each store's margin with the number of employees per store. However, it is clear that both data sources, eFashion and eStaff, contain data concerning the same stores. In the next exercise, you are going to learn how to show the same data but this time in a single block of data, or a single table. To do this, you will manually merge two dimension objects, so that you can project the store names in a single column in the table. This is known as synchronizing data.