Web intelligence report file extension

Geo-dimensions can be defined in universes that were created in Information Design Tool Request , i. In the business layer editor, select the dimension.

The data type of these details must be Numerical. Details Defined as Latitude and Longitude in Universe. When you query this published universe in Web Intelligence, the geo-dimension icon is not yet displayed in the Query Panel.

But if you select this geo-dimension and run the query, the associated latitude and longitude details are retrieved as well. In the document, the dimension appears as a geo-dimension and you can use it in a geographical chart. In addition to the data sources supported in previous releases, the following additional data sources have been added to the SAP BI 4.

The relational connection to Snowflake supports single sign-on. Once the BI Platform can authenticate to the Snowflake database, you can select the following options when you define a relational connection to Snowflake in Information Design Tool:. It allows you to use this connection offline in Web Intelligence Rich Client. Thank you. Stay tuned. Just a point. OData Web Service Links seems not working fine when document has property "Refresh on open" set to on.

A ticket is already opened on SAP Support. Let's see if issue might be fixed easily. Otherwise the feature become useless to us Skip to Content. December 8, More than 30 minute read. Without having to convert or upgrade your existing Web Intelligence documents, this new look and feel: Proposes one single experience, common to both the Web and Desktop accesses. Simplifies the workflows thanks to highly intuitive interfaces. Is aligned with the interfaces and principles of other SAP products.

Report Description In a document, reports can be: Always hidden: to hide instructions or intermediate calculations from the user. Conditionally hidden: to display a report with additional details depending on the result of a formula Request A document must always have at least one report that is always visible. To hide a report when users open the document in Reading mode, you must be in Design mode and: Select the Hide in the context menu of the report tab.

Report Hide Parameters In Design mode , even if reports have been defined as hidden, they remain visible. An icon is displayed beside the report name depending on its type: Always hidden Currently hidden, based on a formula. Currently visible, based on a formula. Design Mode: Hidden Reports In Reading mode, hidden reports are not displayed and cannot be exported. The Presentation Mode dialog box is opened and offers the following properties: Auto refresh every: To refresh the document when it is in Presentation mode.

If you enable the option, you may define the refresh period. Switch reports after: To switch from one report to another when in Presentation mode. If you select this option, you may define the delay between the reports and the list of reports to display. Display in full screen: To display the document in full screen mode, without the BI launch pad header. Show reports tabs: To display the reports tabs. Show refresh bar: To display the Refresh bar with the last refresh time.

If you decided to switch reports, you may define the list of reports to include. An icon is displayed beside the reports which are visible or not based on a formula. The result of the formula may change after a refresh and hence the list of visible reports might also change.

Warnings are not displayed on the screen. You quit the Presentation mode when you press the [Escape] key, click the Exit button in the Refresh bar or if an error is raised during a refresh. The service returns the number of available items up to but not greater than the specified value n. Basic Authentication.

If the document to query is stored in another BI Platform repository, then you need to configure how to authenticate against this other repository: Enable Basic Authentication in the other BI Platform repository. Add this Data Source Reference for the users who connect to this other repository. In the page that opens: Enter a name for the Reference Name. By default, Google OAuth 2.

This automatically fills the other fields for the OpenID Connect configuration. Click OK. The workflow to generate this token is the same for other data sources for which OAuth is supported Snowflake , OData ,… Using Google Drive as Data Source When you create a document or add a query, click the Google Drive category in the Select a Data Source dialog box, and select the type of document to query: Google spreadsheet, Excel or Text.

Google Spreadsheet Settings The Query Panel which has got the same look no matter the data source you use, is displayed. Schedule Destination When you schedule a Web Intelligence document, you may select Google Drive as a destination for the generated output Request Indeed, in this Query Panel, you can select the objects to include in the query, add filters to the query Request , preview query results, define a maximum number of rows,… Query Panel for Excel Data Source For the time being, the following capabilities are not yet supported for the new Text, Excel, Free-Hand SQL, Google Spreadsheet and OData data sources: Combined queries, Sub-queries and list of values of objects when defining a filter.

But these capabilities should be available in future releases. In addition to the unified Query Panel, we also offer the following enhancements: When you click an object or a filter used in the Objects Filter pane, the focus is moved on this object or this condition in the data source outline Request When you add an analysis dimension of a multi-dimensional universe in the Result Objects , the default hierarchy is used.

Formula Editor The Formula Editor has been improved to simplify formula edition with a more powerful code editor: The Objects , Functions and Operators panels have been moved to the left. This leaves more space to display the list in these panels and the Formula field Request You can display or hide the Objects , Functions and Operators panels through the three buttons at the top right.

The Operators panel is aligned with the two other panels. The buttons with the basic operators are no longer displayed but you can filter the list. Syntax analysis is applied on the fly: the strings in the formulas are colored depending on their type Request : functions, objects, strings, comments… Unrecognized parts are underlined in red.

When you move the cursor behind a parenthesis, the pairing parenthesis is highlighted Request Line numbers are displayed in the Formula text field. When hovering the mouse over an object or a function in the panels, a tooltip displays the object properties or the function help Request The Formula text field toolbar contains the following buttons: Undo : To cancel the most recent changes in the formula definition Request Redo : To reverse the most recent changes made with the Undo command. Validate Formula : To analyze the formula.

To ease formula correction, error messages now contain the line number Request Cancel Formula : To revert the formula back to its initial definition. Wrap text : To wrap long lines or use a horizontal scroll bar to show it. Syntax highlighting : To disable the syntax analysis and use the previous code editor. This may be useful to avoid lag when displaying long formulas.

Creating and Managing Shared Elements Any report element can be saved as a shared element. When it is saved, all items required to create this report element are also saved: The report element itself and its properties: type, description, … The objects and variables if any used by the report element, The queries used by these objects and variables, The data sources of these queries, The format defined for the report element: labels, colors, chart, and their properties… Shared elements can be saved in the public or user folders or sub-folders of the repository.

Save Shared Element Dialog Box Select the destination folder, the save options, the categories to assign to the shared element and click Save. Inserting a Shared Element into a Document To use a shared element in a document, you must be in Design mode. Insert Shared Element Select the shared element and click Insert. Shared Elements Tab: Currently Used Shared Elements You can also insert another occurrence of a shared element that is already used in the document.

Updating Shared Elements When a shared element is inserted into a document, its content is explicitly copied into the document. Unlinking Shared Elements To remove the link between a shared element and a document, select the shared element in the Shared Elements tab and click the Unlink button.

Or in the Shared Elements tab, click the Unlink button beside this specific instance. Once you have selected the document, first click the Customize URL Parameters button to edit the URL, then the Analyze document button to obtain all available document parameters Request The name of the target document is displayed. The corresponding document path is available in a tooltip. You can decide to open the document in the same frame by selecting the Open in Current Window option Request Mandatory prompts present in the URL and optional prompts are not displayed.

Mandatory and optional prompts present in the URL are not displayed. Input Control If you base an input control on a variable the definition of which is a constant, its scope can be the document or the current report Request Input Control: Hierarchy The input control dialog boxes can be resized using the handle at the bottom-right corner.

Freeze Header The Freeze Header functionality is back Request and offers the following improvements: It is available in both Reading and Design modes. You can enable it for all tables of the report by clicking the Freeze Headers button on the toolbar Request You can enable it for every individual table and additionally define the number of rows or columns you wish to freeze Request This opens the Freeze Header dialog box in which you can define these options.

Scroll through the report in Freeze Header mode is smoother Request If you want to select a universe, note that you can display them in folder or list mode Request Local : Web Intelligence Rich Client only, to select a data source saved locally. Format Painter Click the different elements to which you want to apply the same format. Warning Message Management When a document is refreshed, several queries may display the same warning message s , for example No retrieved data or Partial data.

Prompts Dialog Box The left panel displays the list of prompts. An icon displayed before a prompt identifies its type: : Mandatory prompt that has been answered. No icon is displayed for an optional prompt that has not been answered. Date-Time Selection If you type the date-time manually, an analysis is performed on the fly to highlight syntax errors and auto complete your input when this is possible.

Refresh When a document refresh is taking long and the Query Panel is not open, you can switch to another document by returning to the BI Launch Pad Home page or, if it is already open, by selecting it in the BI Launch Pad header. Cross-Table Fold Menu Toolbar In Reading mode, the toolbar has been reviewed and displays more toolbar buttons at a time.

Web Intelligence is a Business Intelligence reporting tool for business users to analyze data in Data Warehouse. It assists business managers in the decision-making process for building future strategies. On the Report Execution tab, choose Report Directory. Choose Create New. At a minimum, you must enter a name for your report and select a reporting template. Business Objects Reporting is a tool used by companies to collate and disseminate valuable information to employees or management to make key decisions.

It is also used to provide intelligent information to people outside the organization, such as customers or vendors. To create a query simply drag and drop data from the left side panel to the select area. It will open the Report Filter dialog box. You can add objects , operand and value to apply filter at the report level.

Wharton e-Business Initiative. TIP 3. When you combine both the queries in a single Webi report , objects from both the queries are shown in the list of available objects. Select the unique object from both the queries and click Ok as shown in the following screenshot. It will create a Merge Dimension under the list of available objects.

Business Objects is a reporting system that allows the reporting of data from different systems that the university uses to run its business. SQL tuning techniques such as creating index can be applied on tables or materialized views which will improve performance of BO reports.

It consists of a number of reporting applications that allow users to discover data, perform analysis to derive insights and create reports that visualize the insights. It allows simplify data manipulation, allowing users to access, navigate, analyze, format, and share information across a corporate environment. The report opens in the BusinessObjects XI web intelligence interface.

Under Create Basic Task, type in the name you like and click Next. From the Trigger select the option you like and click Next. I chose Daily and clicked next, which brought me to this screen.

Then click on Start a Program and click Next. Now click on Browser and select the batch file above saved in step 3. Finally click on Finish to create the Task. Now that we have created a Task, we have to make sure it runs with the highest privilege. Since we have UAC settings we have to make sure that when you run the file it should not fail if it does not bypass the UAC settings.

So click on Task Scheduler Library. Then double click on the Task you just created to give full authorization. Click on Run with Highest privilege then click OK. Finally we have successfully created a Scheduled Task to automate a batch file.

So webi report will be transferred to BO server path and then moved to shared folder in the company network using batch file. Regards, Joseph. Alert Moderator.

Alerting is not available for unauthorized users. Assigned Tags. Similar Blog Posts. Related Questions. You must be Logged on to comment or reply to a post. Former Member.

Appreciate all your help. Like 0 Share.