How do I change the universe of a Web Intelligence report?

How do I change the universe of a Web Intelligence report?

Assigned Tags

1. Open your report in WebI (if BI Launch pad, modify mode.)
2. Click on “Data Access” tab.
3. Click on “Tools” tab under “Data Access”
4. Select your query to change your universe.
5. After you select your query, you will be prompted to select the new universe.
6. Select the universe you want.

How do I change the universe connection in Business Objects?

To edit the connection to the database

1. In the Universe Design Tool window, select Tools > Connections.
2. Select the ITSM connection.
3. Click Edit.
4. Provide the values required to connect to your data source.
5. Click Test Connection.
6. After the connection is verified, click Next.
7. On the Configuration Parameters page, click Next.

How do I change the data source in Business Objects?

Procedure

1. In the list of data providers, right-click the query whose source you want to change and select Change Source.
2. In the Data tab in the Side Panel, right-click the data source or query and select Change Source.

How do you find the source of a WebI report?

You can follow following steps to get the required info.

1. Open your WebI Report.
2. In Top Right corner you can see “Data” button to the right of “Design” Button.
3. Once you click it, you can see the data source of your WebI report.
4. If you want to see further details, right click on the data source and select change source.

How do I refresh the IDT universe structure?

Login to IDT and retrieve the Universe which you want to refresh. Go to the Data Foundation Layer(. dfx) . Click Detect and select “Refresh Structure” from the drop down.

How do I edit a query in Business Objects?

Click the Data tab. Navigate to Events – Event Information, and drag and drop Event SMQ (Broad) into the Result Objects panel. Click Run Query. Click Edit Query.

How do I change the report name in Business Objects?

To rename a report

1. In a Web Intelligence document in Design mode, right-click the Report tab of the report you want to rename.
2. Select Rename Report on the menu and type the new report name.
3. Click outside the report name tab and save the document.

How do I import an Excel file into WEBI?

Use the Excel File as a Data Provider

1. Select Applications > Web Intelligence.
2. Click New .
3. Click Excel in the Create a Document dialog box.
4. Select the Excel file from your Favorites folder and click Open.
5. Select desired options in the Custom Data Provider – Excel dialog box.

Where can I find BEx query in WEBI report?

Open Webi Rich Client → New Document. Click on select a BEx query as data source. In the new window, select BICS connection in the right pane and corresponding BEx query → Ok. All the objects from BEx will be added to Query Panel on the left side.

How do you refresh a table structure in universe designer?

To refresh the structure on a single table, left click on the table then choose View->Refresh Structure from the menu. To refresh the structure of the entire universe, left click on a blank area of the schema window to make sure no tables are selected, then choose View->Refresh from the menu.

How do you refresh structure in information design tool?