This post by Praveen Reddy lists some direct links to various OBIEE User and Administration functions. These can be useful to know for efficiency and at times can also be useful for debugging security.
This post by Jean-Pierre Dijcks covers Software Focus, Hardware Update and Software Details about the 3rd generation Big Data Appliance.
The focus for this release is:
Comprehensive and Open – Big Data Appliance now includes all Cloudera Software, including Back-up and Disaster Recovery (BDR), Search, Impala, Navigator as well as the previously included components (like CDH, HBase and Cloudera Manager) and Oracle NoSQL Database (CE or EE).
Lower TCO then DIY Hadoop Systems
Simplified Operations while providing an open platform for the organization
Comprehensive security including the new Audit Vault and Database Firewall software, Apache Sentry and Kerberos configured out-of-the-box
This post says “If you are running Oracle BI on an Exalytics machine, you can use Summary Advisor to identify the aggregates that will increase query performance.” The post links to the Oracle Learning Library where a tutorial will explain further.
In this post, Paul McGarrick shares some of the interesting reads he has come across. This includes a post from Jeff McQuigg, a presentation from Peak Indicators and an Oracle White Paper.on My Oracle Support
In this blog post by Mark Rittman, he states to set up our own Hadoop cluster, there are a few options:
1. Get hold of a bunch of physical servers (maybe, old PCs or blade servers), install Linux and Hadoop on them, and then do the configuration and setup manually.
2. Buy a preconfigured solution – Oracle’s Big Data Appliance, for example, which has all the software pre-installed along with connectivity to ODI, Oracle Database etc
3. Spin-up a bunch of servers in the Cloud, or
4. Spin-up a bunch of Linux VMs, for example using VirtualBox or VMWare Fusion/Workstation
He explores this further in the post which can be read here.
In another post by Mark Rittman, he claims the reason we should be interested in Hadoop is because “Hadoop is the classic disruptive technology – cheap, and starting-off with far less functionality than regular, relational databases – but it’s improving fast, and as BI&DW developers it offers the potential of both massive benefits – significantly lower TCO for basic DW work, and support for lots of modern, internet-scale use-cases – and threats – in that if we don’t understand it and see how it can benefit our customers and end-users, we risk being left-behind as technology moves on.”
In this blog, Tarik Bouaziz discusses circumstances that require installing OHS with OBIEE such as:
1- OBIEE Performance Tuning
2- When deploying OBIEE 11g content outside an organization (firewall): this requires placing Oracle HTTP Server (OHS) into the DMZ side firewall (opening port 7777 for non SSL, port 4443 for SSL) and then redirecting calls to OBIEE installed inside the firewall/LAN using a secured port such as 9704
3- OBIEE URL Rewriting (configuring OBIEE 11g to use port 80): A detailed document will be posted in the near future on this topic.
This blog highlights the steps to install and configure OHS with OBIEE11g.
This blog post discusses security issues surrounding the new player – Mobile BI – and how to address this, the conclusion being, “Mobile BI will significantly expand the population of BI users and the decision makers from your company will want to use mobile devices to access corporate BI data from any place. Now you need to ensure that the current BI environment supports these demands without forgetting terms such as performance and security, an Oracle HTTP Server Web Tier installed within the DMZ firewall will help you to achieve the best results.”
Sunil S Ranka says, “Recently while upgrading the Exalytics box from PS1 to PS3 for OBIEE 220.127.116.11 patch-set, one of the requirements was to upgrade firmware and to complete the firmware we needed ILOM address. During the upgrade, the team found out the default ILOM IP was not working and there was a change in the ILOM ip address. To confirm the ip address, we used below command, thanks to Oracle Support to prompt reply . Thought would be a good piece of information as most of the existing Exalytics customers are going through the upgrade.”
Aravind Sai Ram posted, “Hello Friends, I am looking for a solution to perform Load Test on OBIEE Dashboards / Reports (Version 10) using any script or free load test tools / applications .
Scenario is :
> Login to OBIEE
> Apply load by ramping up the users on a specific dashboard / report
> Record the performance counters such as ‘Time taken for a report to retrieve the results’
and counters like Memory utilization, Load capability of BI Server
Can someone please help me in achieving this ?
In this blog post by M & S Consulting, there are detailed instructions and screenshots of how to format a field globally in 11g. They say, “Having to format the field each time that a user wants to use it becomes quite burdensome and gives a developer more room for error if they are formatting the field each time it is used. The saying “work smarter, not harder” comes to mind with this solution.”
Robin Moffat in his third article in his two-article set of posts on extending the monitoring of OBIEE within EM12c. It comes after a brief interlude discussing Metric Extensions as an alternative using Service Tests to look at Usage Tracking data.
He talks us through
The JMeter test script
Running JMeter from the command line
Making the script available to run on EM12c server
Building the JMeter EM12c Service Test
Measuring response times from additional locations
This blog displays a vacancy for a qualified OBIEE Architect / Developer. In this role you will be responsible for building out the OBIEE infrastructure. You will be required to design and implement new reporting meta data repositories and will also be instrumental in developing reports against those meta data repositories. See the blog post for full details.
In this blog by Srinivasan Software Solutions Pvt Ltd, SAML is described as a way of conveying identity information across systems. The writer describes a scenario where a situation required OBIEE 11g integration into SAML 2.0 SSO.
The post examines what can be done (and how) if this occurs.
This blog advises that when upgrading existing customized installations of OBIEE to 18.104.22.168, one thing that you may run into is a subtle change in the usage of the vanilla style and skin of the application.
Dr OBI says, “For the manager, it’s important to understand the RELATIVE impact of software development challenges, when you’re delivering solutions driven by software. Why the problem is easy or why it is hard, has a profound impact on programme planning and budgets. This can greatly increase cost for enterprise programmes, increasing the cash burn rate…”
Paul McGarrick states “When using Oracle BI Applications there is often the need to invalidate OBIEE’s query cache once new data has been loaded into the Data Warehouse to prevent users from seeing stale data in the reports. Perhaps the simplest and most elegant method to do this is to make use of the standard Event Polling Table mechanism.”
He then goes on to say there are three ways to do this:
1. Editing each Informatica Workflow to include post-ETL SQL insert statements
2. Configuration of new tasks within the DAC to handle inserts
3. Triggers in the database (Oracle only) to automate the inserts
He focuses on Method 3 in this blog. Read the blog here.
In this OBIEE Developer Blog, The question “Is there a way to display a list of dashboards based on permissions?” is answered. The writer gives credit to MTache who posted the Java Script on the OTN Forums.
Matt Bradley discusses different deployment options for Oracle EPM. Cloud services (SaaS), managed services, on-premise, off-premise all have their merits, and organizations need flexibility to easily move between them as their companies evolve.
In David Peake’s blog, he asks “What are the Long-term prospects for Oracle Application Express?”
He says that the simple answer is that Oracle is committed to the ongoing development and support of Application Express. Oracle itself utilizes Application Express extensively to meet business requirements and improve business processes.
In his conclusion, he says “I can’t guarantee that Oracle Application Express will always continue to have the incredible popularity, inside and outside Oracle, which it enjoys today. However, the above should give you confidence that Application Express has a very solid and promising future, and that Oracle will continue to invest in the tool’s ongoing development.”
In this blog post, Jeff McQuigg demonstrates visually how circles can not be compared easily but in a vertical bar, comparison is visually better. He says to keep this in mind when dealing with comparisons using area based visuals.