Category: obiee

OBIEE – Testing Repository ”; Previous Next You can check the repository for errors by using the consistency checking option. Once it is done, next step is to load the repository into Oracle BI Server. Then test the repository by running an Oracle BI analysis and verifying the results. Go to File → click on Check Global Consistency → You will receive the following message → Click Yes. Once you click OK → Business model under BMM will change to Green → Click on save the repository without checking global consistency again. Disable Caching To improve query performance, it is advised to disable BI server cache option. Open a browser and enter the following URL to open Fusion Middleware Control Enterprise Manager: http://<machine name>:7001/em Enter the user name and password. Click Login. On the left side, expand Business Intelligence → coreapplication → Capacity Management tab → Performance. Enable BI Server Cache section is by default checked → Click on Lock and Edit Configuration → Close. Now deselect cache enabled option. It is used to improve query performance. Go to Apply → Activate Changes → Completed Successfully. Load the Repository Go to Deployment tab → Repository → Lock and Edit Configuration → Completed Successfully. Click on Upload BI Server Repository section → Browse to open the Choose file dialog box → select the Repository .rpd file and click Open → Enter Repository password → Apply → Activate Changes. Activate Changes → Completed Successfully → Click on Restart to apply recent changes option at the top → Click Yes. Repository is successfully created and loaded for query analysis. Enable Query Logging You can set up query logging level for individual users in OBIEE. Logging level controls the information that you will retrieve in log file. Set Up Query Logging Open the Administration tool → Go to File → Open → Online. Online mode is used to edit the repository in Oracle BI server. To open a repository in online mode, your Oracle BI server should be running. Enter the Repository password and user name password to login and click Open to open the repository. Go to Manage → Identity → Security Manager Window will open. Click BI Repository on the left side and double-click on Administrative user → User dialogue box will open. Click User tab in user dialogue box, you can set logging levels here. In normal scenario − The user has a logging level set to 0 and the administrator has a logging level set to 2. Logging level can have values starting from Level 0 to level 5. Level 0 means no logging and Level 5 means maximum logging level information. Logging Level Descriptions Level 0 No logging Level 1 Logs the SQL statement issued from the client application Logs elapsed times for query compilation, query execution, query cache processing, and back-end database processing Logs the query status (success, failure, termination, or timeout). Logs the users ID, session ID, and request ID for each query Level 2 Logs everything logged in Level 1 Additionally, for each query, logs the repository name, business model name, presentation catalog (called Subject Area in Answer) name, SQL for the queries issued against physical databases, queries issued against the cache, number of rows returned from each query against a physical database and from queries issued against the cache, and the number of rows returned to the client application Level 3 Logs everything logged in Level 2 Additionally, adds a log entry for the logical query plan, when a query that was supposed to seed the cache was not inserted into the cache, when existing cache entries are purged to make room for the current query, and when the attempt to udate the exact match hit detector fails Level 4 Logs everything logged in Level 3 Additionally, logs the query execution plan. Level 5 Logs everything logged in Level 4 Additionally, logs intermediate row counts at various points in the execution plan. To Set Logging Level In user dialogue box, enter value for logging level. Once you click OK, it will open the checkout dialogue box. Click Checkout. Close the Security Manager. Go to file → Click on check-in changes → Save the repository using the Save option at the top → To take changes in effect → Click OK. Use Query Log to Verify Queries You can check query logs once query logging level is set by going to Oracle Enterprise Manager and this helps to verify queries. To check the query logs to verify queries, go to Oracle Enterprise Manager OEM. Go to diagnostic tab → click Log messages. Scroll down to bottom in log messages to see Server, Scheduler, Action Services and other log details. Click on Server log to open log messages box. You can select various filters − Date Range, Message types and message contains/not contains fields, etc. as shown in the following snapshot − Once you click on search, it will show log messages as per filters. Clicking on collapse button allows you to check details of all log messages for queries. Print Page Previous Next Advertisements ”;

OBIEE – Views ”; Previous Next Oracle BI Enterprise Edition enables you to look at results of analyses in a meaningful way using its presentation capabilities. Different types of views can be added, such as graphs and pivot tables that allow drilling down to more detailed information and many more options like using filters, etc. The results of the analysis is displayed using a table/Pivot table view and depends on the type of columns that the analysis contains − Table view is used if the analysis contains only attribute columns/only measure columns or a combination of both. Pivot table is the default view if the analysis contains at least one hierarchical column. A title view displays the name of the saved analysis. You can edit or delete an existing view, add another view to an analysis and can also combine views. Types of Views There are different types of views available − Sr.No Views & Description 1 Title Title view displays a title, a subtitle, a logo, a link to a custom online help page and timestamps to the results. 2 Table Table view is used to display results in a visual representation of data organized by rows and columns. It provides a summary view of data and enables users to see different views of data by dragging and dropping rows and columns. 3 Pivot Table It displays results in a pivot table, which provides a summary view of data in cross-tab format and enables users to see different views of data by dragging and dropping rows and columns. Pivot tables and standard tables are similar in structure but Pivot table can contain column groups and can also display multiple levels of both row and column headings. Pivot table cell contains a unique value. Pivot table is more efficient than a row-based table. It is best suited for displaying a large quantity of data, for browsing data hierarchically, and for trend analysis. 4 Performance Tile Performance tiles are used to display a single aggregate measure value in a manner that is visually simple but provides a summary metrics to the user that will likely be presented in more detail within a dashboard view. Performance tiles are used to focus the user”s attention on simple, need-to-know facts directly and prominently on the tile. Communicate status through simple formatting by using color, labels, and limited styles, or through conditional formatting of the background color or measure value to make the tile visually prominent. For example, if revenue is not tracking to target, the revenue value may appear in red. Respond to prompts, filters, and user roles and permissions by making them relevant to the user and their context. Support a single, aggregate or calculated value. 5 Treemap Tree map are used to display a space-constrained, 2-d visualization for hierarchical structures with multiple levels. Treemaps are limited by a predefined area and display two levels of data. Contain rectangular tiles. The size of the tile is based on a measure, and the color of the tile is based on a second measure. Treemap are similar to a scatter plot graphs in that the map area is constrained, and the graph allows you to visualize large quantities of data and quickly identify trends and anomalies within that data. 6 Trellis Trellis displays multi-dimensional data shown as a set of cells in a grid form and where each cell represents a subset of data using a particular graph type. The trellis view has two subtypes − Simple Trellis and Advanced Trellis. Simple trellis views are ideal for displaying multiple graphs that enable comparison of like to like. Advanced trellis views are ideal for displaying spark graphs that show a trend. A simple trellis displays a single inner graph type, Example − a grid of multiple Bar graphs. An advanced trellis displays a different inner graph type for each measure. Example: A mixture of Spark Line graphs and Spark Bar graphs, alongside numbers. 7 Graph Graph displays numeric information visually which makes it easier to understand large quantities of data. Graphs often reveal patterns and trends that text-based displays cannot. A graph is displayed on a background, called the graph canvas. 8 Gauge Gauge are used to show a single data value. Cos of its compact size, a gauge is often more effective than a graph for displaying a single data value Gauges identify problems in data. A gauge usually plots one data point with an indication of whether that point falls in an acceptable or unacceptable range. Thus, gauges are useful for showing performance against goals. A gauge or gauge set is displayed on a background, called the gauge canvas. 9 Funnel Funnel displays results in 3D graph that represents target and actual values using volume, level, and color. Funnel graphs are used to graphically represent data that changes over different periods or stages. Example: Funnel graphs are often used to represent the volume of sales over a quarter. Funnel graphs are well suited for showing actual compared to targets for data where the target is known to decrease (or increase) significantly per stage, such as a sales pipeline. 10 Map view Map view is used to display results overlain on a map. Depending on the data, the results can be overlain on top of a map as formats such as images, color fill areas, bar and pie graphs, and variably sized markers. 11 Filters Filter are used to displays the filters in effect for an analysis. Filters allows you to add condition to an analysis to obtain results that answer a particular question. Filters are applied before the query is aggregated. 12 Selection Steps Selection steps are used to displays the selection steps in effect for an analysis. Selection steps, like filters, allow you to obtain results that answer particular questions. Selection steps are applied after the query is aggregated. 13 Column Selector Column selector is a set of drop-down lists that contain pre-selected columns. Users can dynamically select columns

OBIEE – Filters ”; Previous Next Filters are used to limit the results that are displayed when an analysis is run, so that the results answer a particular question. Based on the filters, only those results are shown that matches the criteria passed in the filter condition. Filters are applied directly to attribute and measure columns. Filters are applied before the query is aggregated and affect the query and thus the resulting values for measures. For example, you have a list of members in which the aggregate sums to 100. Over time, more members meet the set filter criteria, which increases the aggregate sum to 200. Column Filters Following are the ways to create filters − Create a Named Column Filter Go to Oracle Business Intelligence homepage → New menu → Select filter. The Select Subject Area dialog is displayed. From the Select Subject Area dialog, choose the subject area for which you want to create a filter. The “Filter editor” is displayed from the “Subject Areas pane”. Double-click the column for which you want to create the filter. New Filter dialog is displayed. Create an Inline Filter Either create an analysis or access an existing analysis for which you want to create a filter. Click the Criteria tab → Locate the “Filters pane” → Click create a filter for the current subject area button. The analysis selected columns are displayed in the cascading menu. Select a column name from the menu or select the More Columns option to access the “Select Column dialog” from which you can select any column from the subject area. Once you select a column, the “New Filter dialog” is displayed. Print Page Previous Next Advertisements ”;

OBIEE – Dashboards ”; Previous Next OBIEE dashboard is a tool that enables end users to run ad-hoc reports and analysis as per business requirement model. Interactive dashboards are pixel perfect reports which can be directly viewed or printed by end users. OBIEE dashboard is part of Oracle BI Presentation layer services. If your end user is not interested in seeing all the data in the dashboard, it allows you to add prompts to the dashboard that allows the end user to enter what he wants to see. Dashboards also allow end users to select from drop-down lists, multi-select boxes and selection of columns to display in the reports. Dashboard Alerts Oracle BI dashboard allows you to set up alerts for sales executives that comes up on the interactive dashboard whenever the company’s projected sales is going to be below forecast. Create a New Dashboard To create a new Dashboard, go to New → Dashboard or you can also click on Dashboard option under create on the left side. Once you click on Dashboard, new dashboard dialog box opens up. Enter the name of Dashboard and description and select the location where you want Dashboard to save → click OK. If you save the dashboard in the Dashboards subfolder directly under the /Shared Folders/first level subfolder → dashboard will be listed in the Dashboard menu on the global header. If you save it in a Dashboards subfolder at any other level (such as /Shared Folders/Sales/Eastern), it will not be listed. If you choose a folder in the Dashboards subfolder directly under the /Shared Folders/first level subfolder in which no dashboards have been saved, a new Dashboards folder is automatically created for you. Once you enter the above fields, Dashboard builder will open up as shown in the following snapshot − Expand the catalog tab, select analysis to add to Dashboard and drag to page layout pane. Save and run the dashboard. Edit a Dashboard Go to Dashboard → My Dashboard → Edit Dashboard. To edit Dashboard. Click on below icon → Dashboard properties. A new dialog box will appear as shown in the following snapshot. You can perform the following tasks − Change the styles (Styles control how dashboards and results are formatted for display, such as the color of text and links, the font and size of text, the borders in tables, the colors and attributes of graphs, and so on). You can add a description. You can add hidden prompts, filters, and variables. Specify the links that will display with analyses on a dashboard page. You can rename, hide, reorder, set permissions for, and delete dashboard pages. You can also edit Dashboard page properties by selecting page in the dialog box. You can make the following changes − You can change the name of your dashboard page. You can add a hidden prompt. Hidden prompts are used to set default values for all corresponding prompts on a dashboard page. You can add permissions for the dashboard and can also delete the selected page. Dashboard pages are permanently deleted. If more than one dashboard page is in this dashboard, the arrange order icons are enabled using up and down arrows. To set the report links at the dashboard level, dashboard page, or analysis level click the edit option of Dashboard reporting links. To add a dashboard page, click on new Dashboard page icon → Enter the name of dashboard page and click OK. In Catalog tab, you can add the new another analysis and drag it to page layout area of new dashboard page. To edit the properties of dashboard like cell width, border, and height, click on column properties. You can set background color, wrap text and additional formatting options. You can also add a condition on dashboard data display by clicking on condition option in column properties − To add a condition, click on &plus; sign in condition dialog box. You can add a condition based on analysis. Select the condition data and enter the condition parameter. You can also test, edit or remove the condition by clicking on ‘more’ sign next to &plus; button. Save a Customized Dashboard You can save your customized dashboard by going to page options → Save current customizations → Enter the name of customization → Click OK. To apply customization to a dashboard page, go to page option → Apply saved customization → Select name → Click OK. It allows you to save and view dashboard pages in their current state such as filters, prompts, column sorts, drills in analyses, and section expansion and collapse. By saving customizations, you do not need to make these choices manually each time you access the dashboard page. Print Page Previous Next Advertisements ”;

OBIEE – Dimension Hierarchies ”; Previous Next Hierarchies is a series of many-to-one relationships and can be of different levels. A Region hierarchy consists of: Region → Country → State → City → Street. Hierarchies follow top-down or bottom-up approach. Logical dimensions or dimension hierarchies are created in BMM layer. There are two types of dimensional hierarchies that are possible − Dimensions with level-based hierarchies. Dimension with Parent-Child hierarchies. In level-based hierarchies, members can be of different types and members of the same type come only at single level. In Parent-Child hierarchies, all members are of the same type. Dimensions with Level-based Hierarchies Level-based dimension hierarchies can also contain parent-child relationships. The common sequence to create level-based hierarchies is to start with grand total level and then working down to lower levels. Level-based hierarchies allows you to perform − Level-based calculated measures. Aggregate navigation. Drill down to child level in dashboards. Each dimension can only have one grand total level and it doesn’t have a level key or dimension attributes. You can associate measures with grand total level and default aggregation for these measures are grand total always. All lower levels should have at least one column and each dimension contains one or more hierarchies. Each lower level also contains a level key which defines unique value at that level. Types of Level-based Hierarchies Unbalanced Hierarchies Unbalanced hierarchies are those where all the lower levels don’t have the same depth. Example − For one product, for one month you can have data for weeks and for other month you can have data available for day level. Skip Level Hierarchies In skip-level hierarchies, few members don’t have values at higher level. Example − For one city, you have state → country → Region. However for other city, you have only state and it doesn’t fall under any country or region. Dimension with Parent-child Hierarchies In parent-child hierarchy, all the members are of the same type. The most common example of parent-child hierarchy is the reporting structure in an organization. Parent-child hierarchy is based on a single logical table. Each row contains two keys – one for the member and another for the parent of the member. Print Page Previous Next Advertisements ”;

OBIEE – Calculation Measures ”; Previous Next Calculated measures is used to perform calculation of facts in logical tables. It defines Aggregation functions in Aggregation tab of logical column in the repository. Create New Measure Measures are defined in logical fact tables in repository. Any column with an aggregation function applied on it is called a measure. Common measure examples are − Unit Price, quantity sold, etc. Following are the guidelines to create measures in OBIEE − All aggregation should be performed from a fact logical table and not from a dimension logical table. All columns that cannot be aggregated should be expressed in a dimension logical table and not in a fact logical table. Calculated measures can be defined in two ways in logical tables at BMM layer in Administration tool − Aggregations in logical tables. Aggregations in logical table source. Create Calculated Measures in Logical Tables using Administration Tool Double-click on the column name in the logical Fact table, you will see the following dialog box. Go to Aggregation tab and select the Aggregate function from the drop-down list → Click OK. You can add new measures using functions in Expression builder wizard in Column source. Measures represent data that is additive, such as total revenue or total quantity. Click on the save option at the top to save the repository. This is also called creating measures at logical level. Create Calculated Measures in Logical Table Source using Administration Tool You can define Aggregations by a double-click on Logical table source to open logical table dialogue box. Click on Expression builder wizard to define expression. In Expression builder, you can choose multiple options like – Category, functions, and mathematical functions. Once you select the category, it will show the subcategories inside it. Select the subcategory and mathematical function, and click on the arrow mark to insert it. Now to edit the value to create measures, click on source number, enter the calculated value like multiple and divide → Go to Category and select logical table → Select column to apply this multiple/division to an existing column value. Click OK to close the Expression builder. Again click OK to close the dialog box. Print Page Previous Next Advertisements ”;

OBIEE – Presentation Layer ”; Previous Next Presentation layer is used to provide customized views of Business model in BMM layer to users. Subject areas are used in Presentation layer provided by Oracle BI Presentation Services. There are various ways you can create subject areas in Presentation layer. Most common and simple method is by dragging Business Model in BMM layer to Presentation Layer and then making changes to it as per requirement. You can move columns, remove or add columns in presentation layer so it allows you to make changes in a way that the user shouldn’t see columns that has no meaning for them. Create Subject Areas/Presentation Catalogues and Presentation Tables in Presentation Layer Right-click on Presentation area → New Subject Area → In General tab enter the name of subject area (Recommended similar to Business Model) → Click OK. Once Subject area is created, right click on subject area → New Presentation table → in General tab, Enter name of presentation table → OK (Add number of presentation tables equal to number of parameters required in the report). Click the Permissions tab → Permissions dialog box, where you can assign user or group permissions to the table. Delete a Presentation Table In the Presentation layer, right-click on subject Area → Presentation Catalog dialog box, click the Presentation Tables tab → Go to Presentation Tables tab, select a table and click Remove. A confirmation message appears → Click Yes to remove the table or No to leave the table in the catalog → Click OK. Move a Presentation Table Go to Presentation Tables tab by a right-click on Subject Area → In the Name list, select the table you want to reorder → Use drag-and-drop to reposition the table or you can also use the Up and Down buttons to reorder the tables. Presentation Columns Under Presentation Table The name of presentation columns are normally same to the logical column names in the Business Model and Mapping layer. However, you can also enter a different name by unchecking Use Logical Column Name and the Display Custom Name in the Presentation Column dialog box. Create Presentation Columns The most simple way to create columns under Presentation tables is by dragging the columns from logical tables in BMM layer. Select the objects under logical tables in BMM and drag them to Presentation tables under subject area (Use Ctrl key to select multiple objects for dragging). Repeat the process and add the logical columns to the remaining presentation tables. Create a New Presentation Column − Right-click on Presentation table in the Presentation layer → New Presentation Column. Presentation Column dialog box appears. To use the name of the logical column, select the Use Logical Column checkbox. To specify a name that is different name, uncheck the Use Logical Column check box, and then type a name for the column. To assign user or group permissions to the column, click Permissions → In the Permissions dialog box, assign permissions → click OK. Delete a Presentation Column Right-click on presentation table in the Presentation layer → Click on Properties → Click on the Columns tab → Select the column you want to delete → Click Remove or press the Delete key →Click Yes. To Reorder a Presentation Column Right-click on presentation table in the Presentation layer → Go to Properties → Click the Columns tab → Select the column you want to reorder → Use drag-and-drop or you can also click Up and Down button → Click OK. Print Page Previous Next Advertisements ”;

OBIEE – Repositories ”; Previous Next OBIEE repository contains all metadata of the BI Server and is managed through the administration tool. It is used to store information about the application environment such as − Data Modeling Aggregate Navigation Caching Security Connectivity Information SQL Information The BI Server can access multiple repositories. OBIEE Repository can be accessed using the following path − BI_ORACLE_HOME/server/Repository -> Oracle 10g ORACLE_INSTANCE/bifoundation/OracleBIServerComponent/coreapplication_obisn/-> Oracle 11g OBIEE repository database is also known as a RPD because of its file extension. The RPD file is password protected and you can only open or create RPD files using Oracle BI Administration tool. To deploy an OBIEE application, the RPD file must be uploaded to Oracle Enterprise Manager. After uploading the RPD, the RPD password then must be entered into Enterprise Manager. Designing an OBIEE Repository using Administration Tool It is a three layer process − starting from Physical Layer (Schema Design), Business Model Layer, Presentation Layer. Creating the Physical Layer Following are the common steps involved in creating the Physical Layer − Create physical joins between the Dimension and Fact tables. Change the names in the physical layer if required. The physical layer of repository contains information about the data sources. To create the schema in the physical layer you need to import metadata from databases and other data sources. Note − Physical layer in OBIEE supports multiple data sources in a single repository – i.e. data sets from 2 different data sources can be performed in OBIEE. Create a New Repository Go to Start → Programs → Oracle Business Intelligence → BI Administration → Administration Tool → File → New Repository. A new window will open → Enter the name of Repository → Location (It tells the default location of Repository directory) → to import metadata select radio button → Enter Password → Click Next. Select the connection type → Enter Data Source name and User name and password to connect to data source → Click Next. Accept the meta types you want to import → You can select Tables, Keys, Foreign Keys, System tables, Synonyms, Alias, Views, etc. → Click Next. Once you click Next, you will see Data Source view and Repository view. Expand the Schema name and select tables you want to add to Repository using Import Selected button → Click Next. Connection Pool window opens up → Click OK → Importing window → Finish to open the repository as shown in the following image. Expand the Data Source → Schema name to see the list of tables Imported in Physical Layer in the new Repository. Verify Connection and Number of Rows in Tables Under Physical Layer Go to tools → Update all rows counts → Once it is completed you can move the cursor on the table and also for individual columns. To see Data of a table, right-click on Table name → View Data. Create Alias in Repository It is advisable that you use table aliases frequently in the Physical layer to eliminate extra joins. Right-click on table name and select New Object → Alias. Once you create an Alias of a table it shows up under the same Physical Layer in the Repository. Create Primary Keys and Joins in Repository Design Physical Joins When you create a repository in OBIEE system, physical join is commonly used in the Physical layer. Physical joins help to understand how two tables should be joined to each other. Physical joins are normally expressed with the use of Equal operator. You can also use a physical join in BMM layer, however, it is very rarely seen. The purpose of using a physical join in BMM layer is to override the physical join in the physical layer. It allows users to define more complex joining logic as compared to physical join in the physical layer so it works similar to complex join in the physical layer. Therefore, if we are using a complex join in the physical layer for applying more join conditions, there is no need to use a physical join in BMM layer again. In the above snapshot, you can see a physical join between two table names − Products and Sales. Physical Join expression tells how the tables should be joined with each other as shown in the snapshot. It is always recommended to use a physical join in the physical layer and complex join in BMM layer as much as possible to keep Repository design simple. Only when there is an actual need for a different join, then use a physical join in BMM layer. Now to join tables while designing Repository, select all the tables in the Physical layer → Right-click → Physical diagram → Selected objects only option or you can also use Physical Diagram button at the top. Physical Diagram box as shown in the following image appears with all the table names added. Select the new foreign key at the top and select Dim and Fact table to join. Foreign Key in Physical Layer A Foreign key in the physical layer is used to define Primary key-Foreign key relation between two tables. When you create it in the physical diagram, you have to point first the dimension and then the fact table. Note − When you import tables from schema into RPD Physical Layer, you can also select KEY and FOREIGN KEY along with the table data, then the primary key-foreign key joins are automatically defined, however it is not recommended from performance point of view. The table you click first, it creates one-to-one or one-to-many relationship that joins column in first table with foreign key column in the second table → Click Ok. The join will be visible in Physical Diagram box between two tables. Once tables are joined, close the Physical diagram box using ‘X’ option. To save the new Repository go to File → Save or click the save button at the top. Creating Business Model and Mapping Layer of a Repository It

OBIEE – Architecture ”; Previous Next OBIEE Architecture involves various BI system components which are required to process the end user’s request. How OBIEE System Actually Works? The initial request from the end user is sent to the Presentation server. The Presentation server converts this request in logical SQL and forwards it to BI server component. BI server converts this into physical SQL and sends it to database to get the required result. This result is presented to the end user through the same way. The following diagram shows detailed OBIEE Architecture − OBIEE Architecture contains Java and non-Java components. Java components are Web Logic Server components and non-Java components are called Oracle BI system component. Web Logic Server This part of OBIEE system contains Admin Server and Managed Server. Admin server is responsible for managing the start and stop processes for Managed server. Managed Server comprises of BI Plugin, Security, Publisher, SOA, BI Office, etc. Node Manager Node Manager triggers the auto start, stop, restart activities and provides process management activities for Admin and Managed server. Oracle Process Manager and Notification Server (OPMN) OPMN is used to start and stop all components of BI system. It is managed and controlled by Fusion Middleware Controller. Oracle BI System Components These are non-Java components in an OBIEE system. Oracle BI Server This is the heart of Oracle BI system and is responsible for providing data and query access capabilities. BI Presentation Server It is responsible to present data from BI server to web clients which is requested by the end users. Scheduler This component provides scheduling capability in BI system and it has its own scheduler to schedule jobs in OBIEE system. Oracle BI Java Host This is responsible for enabling BI Presentation server to support various Java tasks for BI Scheduler, Publisher and graphs. BI Cluster Controller This is used for load balancing purposes to ensure that the load is evenly assigned to all BI server processes. Print Page Previous Next Advertisements ”;

OBIEE – Basics ”; Previous Next OBIEE stands for Oracle Business Intelligence Enterprise Edition, a set of Business Intelligence tools and is provided by Oracle Corporation. It enables the user to deliver robust set of reporting, ad-hoc query and analysis, OLAP, dashboard, and scorecard functionality with a rich end-user experience that includes visualization, collaboration, alerts and many more options. Key Points OBIEE provides robust reporting which makes data easier for business users to access. OBIEE provides a common infrastructure for producing and delivering enterprise reports, scorecards, dashboards, ad-hoc analysis, and OLAP analysis. OBIEE reduces cost with a proven web-based service-oriented architecture that integrates with existing IT infrastructure. OBIEE enables the user to include rich visualization, interactive dashboards, a vast range of animated charting options, OLAP-style interactions, innovative search, and actionable collaboration capabilities to increase the user adoption. These capabilities enable your organization to make better decisions, take informed actions, and implement more-efficient business processes. Competitors in the Market The main competitors of OBIEE are Microsoft BI tools, SAP AG Business Objects, IBM Cognos and SAS Institute Inc. As OBIEE enables the user to create interactive dashboards, robust reports, animated charts and also because of its cost-effectiveness, it is widely used by many companies as one of main tool for Business Intelligence solution. Advantages of OBIEE OBIEE provides various types of visualizations to insert in dashboards to make it more interactive. It allows you to create flash reports, report templates, and ad-hoc reporting for end users. It provides close integration with major data sources and can also be integrated with third party vendors like Microsoft to embed data in PowerPoint presentations and word documents. Following are the key features and benefits of OBIEE tool − Features Key Benefits of OBIEE Interactive Dashboards Provides fully interactive dashboards and reports with a rich variety of visualizations Self-serve Interactive Reporting Enable business users to create new analyses from scratch or modify existing analyses without any help from IT Enterprise Reporting Allows the creation of highly formatted templates, reports, and documents such as flash reports, checks, and more Proactive Detection and Alerts provides a powerful, near-real-time, multi-step alert engine that can trigger workflows based on business events and notify stakeholders via their preffered medium and channel Actionable Intelligence Turns insights into actions by providing the ability to invoke business processes from within the business intelligence dashboards and reports Microsoft Office Integration Enables users to embed up-to-the-minute corporate data in Microsoft PowerPoint, word, and Excel documents Spatial Intelligence via Map-based Visualizations Allows users to visualize their analytics data using maps, bringing the intuitiveness of spatial visualization to the world of business intelligence How to Sign in to OBIEE? To sign into OBIEE, you can use web URL, user name and password. To sign into Oracle BI Enterprise Edition − Step 1 − In the Web browser address bar, enter URL to access OBIEE. The “Sign In page” is displayed. Step 2 − Enter your user name and password → Select the language (You can change the language by selecting another language in the User Interface Language field in the My Account dialog Preferences tab”) → Click on Sign In tab. It will take you to the next page as per configuration: OBIEE homepage as shown in the following image or to My Dashboard page/Personal Dashboard or a Dashboard specific to your job role. Print Page Previous Next Advertisements ”;