Sweet Summer Lovin OBIEE

rssBlogs of the week

Have a look at our blogger database.  Contact us if you would like to be added on.

1. OBIEE 11g: Unable to Add condition to run Agent during the Agent Creation or Insufficient Privileges.Access Condition Evaluation Service Service

Venkata Nagarjuna says that the scenario is as follows: 
“I would like to create a new agent. The Agent has to run as per another report. I would like to pass the other report as a condition for this Agent.”

2. Oracle SQL Developer: Code on Demand

Jeff Smith writes that he has recently spent a few hours debugging some user defined reports.

He said if the code that he detailed did not work then upgrade! He found that a few of his wouldn’t work, and he found a bug. It’s been fixed in v4. Another reason to go upgrade, like…today.

3. SAML – A go-to tool for Enterprise – Cloud Applications Security

Shiva writes, “SAML is the XML-based Security Assertion Markup Language being standardized at OASIS. It enables Single Sign-On and other security scenarios, and provide details about the authentication, attribute, and authorization information between security domains.

He then blogs about :

  • Terminology
  • How does SAML work?
  • Why is SAML Used? And how it is related to Cloud?
  • What are the benefits of SAML?
  • SAML usecase

4. OpenWorld on your iPad and iPhone

Keith Laker writes about how for this year’s conference, he has made all the information available in an HTML app that runs on most smartphones and tablets.

The app will include:

  • Getting to know 12c – a series of video interviews with George Lumpkin, Vice President of Data Warehouse Product Management
  • Your presenters – full biographies and links to social media sites for all the key data warehouse presenters
  • Must see sessions – list of all the most important data warehouse presentations at this year’s conference
  • Our customers – profiles our most important data warehouse customers
  • Must attend labs – list of all the most important data warehouse hands-on labs at this year’s conference
  • Links – a list of links to the most important data warehouse sites

5. Calculation Manager, BSO Planning, and ASO Planning combine for an awesome ASO Essbase procedural calculation hack — Part 3

Cameron Lackpour says, “This is the third and final installment of a three part series on ASO calculations, and specifically, ASO Planning calculations.  Thus far I’ve showed how to use the @CalcMgrExecuteEncryptMaxLFile via Calculation Manager which is pretty cool, and then how to make ASO procedural calculations in MaxL fast, fast, fast.”

6. Migrate Your SQL Developer User Defined Reports

Danny Byrant says, “I’m in the process of upgrading my work computer and in an effort to make sure it is configured the way I want it, I decided to forego the automated “side-by-side” migration.  Everything was going well until I got around to SQL Developer.  The install as we know is easy enough, and I even went so far as to download and configure the Oracle Instant Client (OCI).  You can read more about that on Jeff’s Blog post.”

7. Importing Data from SQL databases into Hadoop with Sqoop and Oracle Data Integrator (ODI)

Benjamin Perez-Goytia says, “This article illustrates how to import data from relational databases into Hadoop Distributed File Systems (HDFS) with Sqoop and Oracle Data Integrator (ODI).  This article features two ODI knowledge modules designed to work with Sqoop: IKM SQL to HDFS File (Sqoop) and IKM SQL to HDFS Hive (Sqoop).”

twitter logoThis week on Twitter

Jeff Smith shared Oracle SQL Developer 4 and Auto Spec – Body Toggles from the archives

Danny Byrant tweeted Migrate Your SQL Developer User Defined Reports

OracleBlogs posted New Oracle Program Eases Common Pains of Cloud Migration

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logoThis week on LinkedIn

Daisy Ding shared Grouping and Summarizing Data from Big Text Files in R Language, esProc and Python

Monica Hasebi asks Are you going to Oracle Openworld this year? 

Gerd Aiglstorfer shared New version of Oracle BI Mobile App

Stewart Bryson posted Podcast Show Notes: Redefining Information Management Architecture

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

paperliPaper.li

This week’s OBIEE news included stories from siebel-essentials.comthatjeffsmith.com and mandsconsulting.com.

Also videos such as Oracle Storage Cloud Service Overview

and Oracle Application Testing Suite 12: Oracle Flow Builder Demo: Create Project Management Flow

OBIEE did not have a Holiday

rssBlogs of the week

Have a look at our blogger database.  Contact us if you would like to be added on.

1. Partnering with Peak Indicators

Kevin and Stewart announce a planned partnership with Peak Indicators in delivering the following courses in North and South America:

  • OBIEE 11g Advanced Bootcamp
  • ODI 11g Advanced Bootcamp
  • OBIEE 11g Advanced Modelling
  • OBIEE Advanced REports and Dashboards
  • OBIEE 11g Advanced SOA Spatial
  • Oracle BI Publisher Basics

2. Privilege to see hidden objects in OBIEE 11g

Vishal Pathak suggested we:

1. Create a power user group 
2. Create a new role
3. Assign the group to the role
4. Assign the desired users to the group
5. Assign the privilege to the role

Read on for more details.

3. So you want to be a Presenter? Abstract selections for 2015 are open!

Kent Graziano says all you have to do is write some awe inspiring abstract with a catchy, SEO’d title and you are on your way to geek super-stardom. Read all about it here.

4. Reporting in SaaS or On Premises Fusion Applications – OTBI, Smart View, OBIA,BI Publisher & Other

Pravin says, “There are number of options for reporting in Fusion Applications. The most commonly used reporting technique in the implementation project is to leverage on BI Publisher. There are various tools and techniques supported by Fusion Application to generate reports for analytical and transactional reporting.”

5. Oracle BI 11g: Verifying Logical Table Sources in Analyses

Alex Hansal says, “Inspired by a nice instance of the Oracle BI 11g Build Repositories class I delivered last week as an LVC, I decided to share a little trick with you.” Read his blog to discover what it is…

6. OBIEE Change Analysis Subject Area

Gerd says, “Assume you created a more or less complex OBIEE analysis with a lot of views and settings. If you want to reuse the analysis and report settings in a new report, then there exists a very fast solution for changing the OBIEE subject area which keeps all the settings.”

7. Enhanced Planning Validations: Part 2

Cameron Lackpour writes, “At the end of July Tyler Feddersen very generously wrote part one of this two part series on data validation in Planning; you now are reading the concluding entry.”

8. An Essbase OBIEE integration walk through with tips and tricks – Finale

This is a continuation from this post.

9. OBIEE and Essbase a few observations

Glenn writes, “This post on OBIEE and Essbase is based on my creation of my KScope 14 presentation and quirks I noticed Note I was using Essbase 1112.3.5 and the latest patched version of OBIEE 11.1.1.7.1.X (I don’t remember the X). I was using a VM instance of the Sample Oracle supplies and was using Essbase Studio with it to create the cube. I then brought the cube back into OBIEE and also into Publisher to create a Mobile dashboard.”

10. My Oracle Data Miner Book

Brendan Tierney says, “Some of you may be aware that I have been writing a book on Oracle Data Miner. Actually the book covers the Oracle Data Miner GUI that is part of SQL Developer, the SQL and PL/SQL functions, procedures and packages that form the Oracle Data Mining option in the database and lots of other topics for the DBA, Developer and BI/DW people.”

11. A Kscope14 Review: Better Late Than Never!? (Ok, that’s debatable…)

Jeremy Harms shares his thoughts on KScope14

12. Enabling Usage Tracking for BI Publisher in OBIEE 11g

This article describes the steps for Enabling Usage Tracking for BI Publisher and how to visualize usage tracking data.

It covers:

  1. How to enable auditing from BI Publisher UI
  2. How to run RCU to create Audit Schemas
  3. How to create JDBC connection with Weblogic console
  4. How configure the Audit Policy Settings
  5. How register the Audit Storage Database to Your Domain
  6. How audit events in an Audit Table

13. BITeamwork 2.8.4 GA – Collaborative BI Focused

This version of the Collaborative BI Framework provides enhanced functionality and bug fixes.

BITeamwork 2.8.4 Features

  • Better Notifications with images and notifications
  • Better Scalability when expanded content exists in Comments
  • Comment Context Single Prompt Focus Sensitivity
  • Splash Page Administration Updates Refresh User’s Prompting Regardless of Hide
  • Print Comments functionality
  • Training Inside of Oracle BI

14. Timesten In-Memory Database – 1. Basics

Raja Malakar writes, “Oracle Timesten is an in-memory database that is either available as a standalone database system or comes bundled with Oracle Exalytics systems. The objective of Timesten is to hold the database in the server’s Main Memory so that data retrieval and processing are extremely fast, when compared to conventional disk-optimized database systems. We have recently implemented a migration of OBIEE reports from Oracle Rdbms to Timesten on Exalytics and have observed an average of 17 times faster data retrieval times, as compared to Oracle 11g database and that too across 92 reports!”

15. #OTNLATour has just started

Gurcan Orhan shares his session lists for each leg of the tour and the video that Bob Rhubart  posted on OTNArchBeat YouTube channel.

twitterThis week on Twitter

Daan Bakboord  shared Twitter Tuesday – Top 10 @ArchBeat Tweets – August 5-11, 2014 Top Tweets included KScope 2014 Preview: Stewart Bryson on OBIEE, ODI

OracleBlogs  tweeted OBIEE 11.1.1.6.x: Error Correction Support has Ended – What to do to keep receiving bug fixes and enhancements

Gerd Aiglstorfer posted OBIEE Performance Monitoring with Usage Tracking

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logoThis week on LinkedIn

Gerd Aiglstorfer shared OBIEE Performance Monitoring with Usage Tracking

 asked  if anyone could help?

I have tried following below link in order to setup auditing through database.

http://docs.oracle.com/cd/E28280_01/bi.1111/e22255/diagnostics.htm#enmon

Answer him here.

Ian Bristow posted OBIEE 11.1.1.6.x: Error Correction Support has Ended – What to do to keep receiving bug fixes and enhancements

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

paperli

OBIEE News

Stories from thatjeffsmith.comsiebel-essentials.com and artofbi.com

Videos such as Real Time BI with Kevin & Stewart: Ep 021

and ORACLE TEAM USA – Team Building the Tough Way

Live Racing on the inter web

Addidici and TracTrac have teamed up to provide live tracking. Could you use it for your event?

http://www.race-face.org.uk/?page_id=77

Addidici Race Tracking is LIVE

For sports fans out there Addidici have teamed up with Race-Face and TracTrac to run the race tracking system at this years Zhik 2014 29er UK National and Open Championships.

 

You can follow the racing live, play back at the end of the day and re-live those glory moments.

 

Apps are available to, so you can follow while at work or on the train!

 

See you at http://www.race-face.org.uk/

 

Tracking systems are available for Sailing, Cycling, Running, Triathlon, Car racing, Walking, dogs.  In Fact, anything that moves.

 

Back to the OBIEE Future

rssBlogs of the week

Have a look at our blogger database. Is yours there? Contact us if you would like to be added on.

 

 

I am planning on heading over to Kscope 15 next year.  Are you?

 

1. BUCKET_WIDTH: Calculating the size of the bucket

Brendan Tierney writes that he had a query about one of the functions BUCKET_WIDTH. The question was wondering if it was possible to get the width of the bucket in each case. There does not seem to be a build in feature to get this value, so we have to calculate this ourselves. He gives an example of how to calculate this.

2. OBIEE – Fines and Payments (or Orders and Order Lines) with correct totals

Boris Dahav says, “The problem is a “popular” one. You have 2 facts with different levels of aggregation. It’s often Orders fact and Order Lines fact (where there are Order Total in the Orders fact and Lines values in Lines Fact that might not the same due to shipping or general discount). In my case this is Fines fact and Payments fact. In this case they sums often don’t match since they might be only partial payment of the fine.”

3. Capturing Environment Variables in Oracle APEX

The post focuses on the Environmental Variables as they are vital in coding conditional statements , says Vishal Pathak.

4. Oracle BI Mobile App

Gerd lists the changes and new features as:

  • Support for action links, including action link navigation history
  • Support for dashboard sections
  • Support for Briefing Books
  • Add to Favorites now at the dashboard-page level
  • Location support on maps in dashboards
  • Bug fixes

5. Stupid Programming Trick No. 18 — Modifying the Period dimension in Planning

Cameron Lackpour says, “What you will see is how to manipulate custom periods in a Planning Period dimension to get quarter totals.  I will also show how custom Period members outside of YearTotal.”

Read on!

6. How to report on two datasets across different database in OBIEE

Bojie talks about the feature in OBIEE that allows cross db reporting.  He talks us clearly through how to do it, complete with screenshots.

7. ODI Agents

Ram Reddy links to Oracle Data Integrator 12c - Creating a Standalone Agent and Oracle Data Integrator 12c - Creating a Collocated Agent

twitter logoThis week on Twitter

OraNa info tweeted 10 tips for getting started with MAF

Bernard Marr shared The 25 KPIs every manager must know

Doug Correa posted #Kscope14 Video: Ron Dimon

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logo

This week on LinkedIn

Kevin Hsu posted Keeping big data small 

Gerd Aiglstorfer shared Oracle BI Coaching

Daisy Ding linked to An Illustration of Processing Big Text Files with esProc Cursor

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

paperliPaper.li

OBIEE News – Edition of 28th July

Stories from kentgraziano.com and obiee-oracledb.blogspot.com

Videos such as

Foiling camp finale: “Everyone has a smile on their face”

and What Does Real-World Performance Mean?

Phew, is it just me or is OBIEE HOT?

12c, more like 30C.

 

blogBlogs of the week

Have a look at our blogger database. Not listed? Contact us to be added on.

1. OTN The World’s Biggest Oracle Community

Debra posted a link to this infographic

2. Table to Table Mapping in ODI 12C

Praveen told us how to create Table to Table mapping in ODI 12C

3. String Aggregation in OBIEE

Vishal says, “In the BI world, we talk about measures and aggregation, but we don’t talk about string aggregation.”

He says the question is How do we do it?

4. Copy & Paste Imports from Excel to Oracle using SQL Developer

Jeff Smith says, “Oh, I so DO love hearing about things that ‘we cannot do.’ This morning I read that in an article that Oracle doesn’t allow you to copy data from Excel and paste directly to a table.”

Read the post and the discussion that results from this post here.

5. Oracle 12c Release 1 is here!

Get it here!

Also, get more detail about In Memory Database

6. Enhanced Planning Validations: Part 1

Cameron recruited Tyler Feddersen of Performance Architects to write about this really clever technique to enhance validations in Hyperion Planning. He concludes, saying, “And there you have it – a really clever way to handle validations in Planning using the functionality built into the tool.  Thanks again Tyler for sharing this.”

7. OBIEE Sum of Average

Gerd’s latest blog post also includes a link to his Oracle BI expert class.

linkedin logoThis week on LinkedIn

Gerd Aiglstorfer shared OBIEE Sum of Average

Nicola Sandoli posted Oracle BI Metadata dictionary

Eduardo Arroyo shared Analytics means business

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

twitter logo

This week on Twitter

3 Sixty Analytics shared 6 Tips for Using Big Data to Hunt Cyberthreats

Wes Fang posted ADF Directed Acyclic Graphs

Daan Bakboord tweeted Oracle Endeca Information Discovery Learning Library

Follow Addidici on twitter for daily OBIEE news and updates.

paperli

Paper.li

This week’s OBIEE News – Edition of 21st July 

Stories from kentgraziano.com and obiee-oracledb.blogspot.com

Videos such as:

Fly boys

and Register for Oracle OpenWorld 2014

Are you good at OBIEE Dashboard Building?

The art of writing superb analyses and building popular interactive dashboards is not something that we see much of in the OBIEE blogsphere.  Sure we have to build fast databases, and configure the servers, but what the customer sees is the dashboard.

I will look a bit harder this week for front end tips, so please get yours published on the groups, blogs and tweets.

I am actually trying to hire a couple of dedicated dashboard developers, so please take a look at the jobs page to see if you are what I am looking for.

rssBlogs of the week

Have a look at our blogger database. Not listed? Contact us to be added on.

1. How to update report and automatically store updated by and updated time through writeback in OBIEE

Bojie says, “Today I am going to talk about writeback in OBIEE. As you know, writeback is a feature in OBIEE that allows users to update reports that they see in OBIEE without having to deal with the ETL process and reloading table.”

Read more here.

2. Installation check “diskspace” failed…..

John Booth says, “We’re working with a client on an upgrade where Essbase and Essbase Studio are on a Red Hat 5.6 Linux box.”

He then goes through a diskspace error and the solution!

3. Oracle EPM 11.1.2.4 – What’s Coming – The Rumor Mill

Eric Helmer goes through the rumours for:

  • The Big Bullet Points for 11.1.2.4
  • HFM
  • FDMEE
  • Financial Reports
  • Disclosure Management
  • OFMA
  • Planning
  • HPCM
  • Oracle Cloud
  • Data Relationship Management
  • Essbase

4. Calculation Manager, BSO Planning, and ASO Planning combine for an awesome ASO Essbase procedural calculation hack — Part 1

Cameron Lackpour introduces the first part of a three part blog post on how to achieve awesomeness in ASO Planning and beyond.  In Part 1 he gives an introduction to the CDFs you most likely don’t know about.

To come are:

Part 2 – The genius of Joe Watkins

Part 3 – Tying it all together across three different Oracle EPM products with of course a glorious hack.

Keep reading!

5. How to unlock the locked table in Oracle

Kashinathan talks us through how to unlock it!

6. OBIEE Substitute a Filter Variable

Gerd says, “In ISO calendar the week turns on Mondays. When not reporting on real-time data and having a one day load frequency you will see no results each Monday. So it would be best to see previous week data on Mondays and of course having not change the filter criteria in the report.”

He then talks us through how to do this.

7. OBIEE BUNDLE PATCH 11.1.1.7.140715 AKA 11.1.1.7.8 (?) is available

The patch is available for:

  • HP-UX Itanium
  • IBM AIX on POWER Systems (64-bit)
  • Linux x86
  • Linux x86-64
  • MS Windows (32-bit)
  • MS Windows (64-bit)
  • Oracle Solaris on SPARC (64-bit)
  • Oracle Solaris on x86-64 (64-bit)

8. Sorting Control on Grand Total in Pivot Table – OBIEE 11g

Praveen says, “Unfortunately, OBIEE doesn’t have a sort Control on the Grand Total and, creating a column with a total doesn’t get me what I have required. It has ends up being another metric in the pivot.”

For that we need add another metric name which Praveen shows us how to achieve.

9. OBIA 7.9.6.3 Pre-requisites, System Configuration, Performance improvements (Server Side & Development Side), Query Performance Tuning, Maximum connections

This blog goes through the:

  • OBIA Pre-requisites
  • System Configuration
  • Performance improvements (Server Side)
  • BI APPS Performance Tuning (Development Side)
  • Query Performance Tuning
  • Maximum connections

10. OBIEE 11.1.1.7 Port conflict

Anjum Ara blogs about Error message : INST-08010: Error in validing the port range for auto port allocation. At Least 2 ports should be free within the range 7500-7500 for the Adminserver and Adminserver SSL

He goes through the reason and the solution

11. Five Reasons to Attend Oracle OpenWorld (Part Two)

In part two of this post, Meghan Fritz gives the final two reasons to attend!! They are:

Reason #2: Get a vision of Oracle’s future. Hear all about Oracle’s roadmap straight from the source.

Reason #1: Fill in the blanks… fast. Expand your knowledge and get the answers you want and need. All in just five days. 

twitter logo

This week on Twitter

Abhinav Agarwal shared ORACLE BIG DATA APPLIANCE X4-2

OraNA.info tweeted Oracle Big Data SQL – Bringing Structured Queries to an Unstructured World

Bernard Marr posted Facebook And Big Data (No, Big Brother?)

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logoThis week on LinkedIn

Daisy Ding shared How to Process Text Files in the Data Analytics

Ian Bristow posted OBIEE Version 11.1.1.7.140715

Jordi Gonzalez shared Oracle In-Memory Higlights including “Oracle Database In-Memory: Powering the Real-Time Enterprise”

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

paperli

Paper.li

This week’s OBIEE News – Edition of 14th July

Stories from blog.3sixty-analytics.com and  thatjeffsmith.com

Videos such as:

The 11.1.1.8 Oracle WebCenter Content User Interface

and Larry Ellison: “throw a switch and everything runs faster”