In this topic, you learn how to create an analysis with a Pivot Table view, format, add a calculated column to a pivot table, add a Gauze view, and create a master-detail linking. You also learn how to filter your results using Selection Steps in...
Read MoreYou create a Narrative view to provide information such as context, explanatory text, or extended descriptions along with column values for an analysis. You can include values from attribute, hierarchical, and measure columns. If you want to include hierarchy levels in a Narrative view, use...
Read More1. To change Brand Name (Next to Oracle Logo) on the Business Intelligence home page , Alter kmsgHeaderBIBrandName attribute of productmessages.xml file under <Middleware_Home>\Oracle_BI1\bifoundation\web\msgdb\l_en\messages. 2. To change OBIEE 11G browser TitleTo change the OBIEE 11G browser Title name to your custom text Open productmessages.xml from <Middleware_Home>\Oracle_BI1\bifoundation\web\msgdb\l_en\messages. Search for kmsgProductPortalattribute and change its value with your custom...
Read MoreWe can open any sites or drill down report from our dashboard page by clicking on data value of report. Here is the original JavaScript for it… <script language="javascript" type="text/javascript"> <!-- function popitup(url) { newwindow=window.open(url,'name','height=200,width=150'); if (window.focus) {newwindow.focus()} return false; } // --> </script> Then, you link to it by: <a href="popupex.html" onclick="return popitup('popupex.html')" >Link to...
Read MoreRecently I came across a customer requirement to allow a user’s interaction to hide/show certain sections of a dashboard. In this particular case the user wanted to choose either ‘Quarterly’ or ‘Monthly’ and the appropriate sections of a dashboard would be shown. To achieve this I...
Read MoreOne of the interesting attributes that OBIEE provides is the facility to enable users to add/update data back to the database. The user can have a column for which values can be entered in the user interface (UI) section on their platform and this can...
Read MoreEnterprises uses various BI tools like Cognos, Oracle Business Intelligence Enterprise Edition (OBIEE), Tableau, SQL Server Reporting Services (SSRS) etc to analyse swathe of data and convert raw data into more presentable format like Dashboard, Key Performance Indicators(KPIs) to make well informed decision. The success...
Read MoreMode Use This Mode For: Example Use Cases Example Operations Information Online • Small changes that are required to fix things in a running system • Changes that need to be deployed quickly • Renaming Presentation Layer metadata • Reorganizing Presentation Layer metadata 1 Connect to the RPD in online mode. 2 Check out, modify,...
Read MoreOpen localhost:7002/analytics Catalog > CD Analysis > Dashboard > Unarchive Select setting like below Test Dashbaord has populated If any answer not appearing than follow below Is any Answer showing Breakdown sign –in my case it is all ok. In case of breakdown remove...
Read MoreUsage Tracking is used to monitor system and ad-hoc query performance and to provide input on usage trends for use in billing users and departments for resources. Usage tracking is particularly useful in determining user queries that are creating performance bottlenecks, based on query frequency...
Read More