Friday, May 30, 2014
Future Big Data Concept getting applied to Oracle Products
Everyone is talking about Big Data and how it's going to transform Data Warehousing. What I'm wondering is when is Oracle going to make Oracle BI products work across multiple servers and use multiple CPUs and RAM? I would expect within the next 5 years Oracle DB, Essbase, OBIEE, etc, to be re-written to take advantage of increased abilities and as a result, increased performance. What do you think?
Thursday, February 13, 2014
Oracle BIWA Summit 2014--and more on Essbase/OBIEE Integration (Key Factors)
As I touched down in San Fransisco ready for my talk on Essbase and OBIEE integration, I considered all of the factors that go into making the integration work well.
One: Having Essbase cubes built properly. Having ETL work take place on the database side, and not in Essbase Studio or another tool. Having Essbase cube that doesn't use ragged hierarchies.
Two: Having Oracle or another Relational Source that matches the Essbase Cube. Also having a relational source that does not use ragged hierarchies.
Three: Then, understanding the RPD, how to integrate and combine these sources. Essbase needs to integrate with OBIEE here. Mixing the levels together of Essbase and OBIEE. I recommend creating a standalone Essbase model, a standalone relational model, and then once those are working properly try to integrate the two models separately.
The conference and the setting were great, hope to see everyone again next year!
One: Having Essbase cubes built properly. Having ETL work take place on the database side, and not in Essbase Studio or another tool. Having Essbase cube that doesn't use ragged hierarchies.
Two: Having Oracle or another Relational Source that matches the Essbase Cube. Also having a relational source that does not use ragged hierarchies.
Three: Then, understanding the RPD, how to integrate and combine these sources. Essbase needs to integrate with OBIEE here. Mixing the levels together of Essbase and OBIEE. I recommend creating a standalone Essbase model, a standalone relational model, and then once those are working properly try to integrate the two models separately.
The conference and the setting were great, hope to see everyone again next year!
Sunday, June 30, 2013
2013 ODTUG Kscope was a great EPM conference learned a ton of great things, and some things to test out.
Really enjoyed 2013 ODTUG Kscope in New Orleans, and learned some great things.
Some things to test out later:
SmartView Plug-in interaction with OBIEE for OBIEE 11.1.1.7, while it allows the retrieval of answers created Dashboards and Reports, it is not a fully functional ad-hoc tool. Word is they are trying to figure the ad-hoc part out.
Parrallel Restructuring edit to essbase.cfg file in Essbase 11.1.2.2 and later does speed up restructure time. This would of course be dependent upon having multiple processes to parallel process with :)
OBIEE runs smarter queries in latest versions of Essbase(11.1.2.3) and OBIEE(11.1.1.7).
Oracle SQL you can use recursive queries in place of using connect by.
Liked Planning and it's offering,when I queried some developers/users, no one seemed to be using the workflow part of it. They complained it was too much work/necessary process.
Let me know if you have already tested these things out and how they are working for you.
Some things to test out later:
SmartView Plug-in interaction with OBIEE for OBIEE 11.1.1.7, while it allows the retrieval of answers created Dashboards and Reports, it is not a fully functional ad-hoc tool. Word is they are trying to figure the ad-hoc part out.
Parrallel Restructuring edit to essbase.cfg file in Essbase 11.1.2.2 and later does speed up restructure time. This would of course be dependent upon having multiple processes to parallel process with :)
OBIEE runs smarter queries in latest versions of Essbase(11.1.2.3) and OBIEE(11.1.1.7).
Oracle SQL you can use recursive queries in place of using connect by.
Liked Planning and it's offering,when I queried some developers/users, no one seemed to be using the workflow part of it. They complained it was too much work/necessary process.
Let me know if you have already tested these things out and how they are working for you.
Monday, July 30, 2012
Oracle BIWA Virtual Summit 2012 - Aug 15-16
Oracle BIWA Virtual Summit 2012 - Aug 15-16
The First ever BIWA Virtual
Summit will be held on Aug 15 - 16, 2012. This will be a virtual only
event spread over two days. Each day the event will be between 11 AM ET
and 5 PM ET, mostly in 1 hr sessions.
I am speaking at Noon ET on August 16th on Essbase Predictive Analytics and Budgeting. Will be some great content and other speakers as well.
I am speaking at Noon ET on August 16th on Essbase Predictive Analytics and Budgeting. Will be some great content and other speakers as well.
http://oraclebiwasig.blogspot.com/2012/07/oracle-biwa-virtual-summit-2012-aug-15.html
Friday, November 25, 2011
It's time to do more statistical analysis with less
Oracle R is an open source statistical analysis tool that is open source and runs off of Oracle DBs, You do need to have Oracle 11g.
Statistical analysis is something that all places need to do more of, and having something free to use can be a great boon. It's an easy sell, hey, we need to install this for free, and then see if it will help us manage our business better.
An example, a company that makes a great product but cannot ship product because it is so backlogged is not managing inventory correctly. They will lose customers because they haven't planned out their demand properly.
Great uses for Statistical analysis:
--Investigate and Minimize Fraud
--Inventory planning based on prior trends
--Sales and Cash flow planning
Learn about
Statistical analysis is something that all places need to do more of, and having something free to use can be a great boon. It's an easy sell, hey, we need to install this for free, and then see if it will help us manage our business better.
An example, a company that makes a great product but cannot ship product because it is so backlogged is not managing inventory correctly. They will lose customers because they haven't planned out their demand properly.
Great uses for Statistical analysis:
--Investigate and Minimize Fraud
--Inventory planning based on prior trends
--Sales and Cash flow planning
Learn about
Tuesday, March 15, 2011
IOUG Conference this year
I'm speaking again, for the third time this year at IOUG conference in Orlando. I'm speaking on Thursday morning. This time I'm speaking on Forecasting with business and technology tips, focusing on using Essbase to create Forecasts.
Monday, September 6, 2010
2010 the year of OBIEE
2010 is officially the year of OBIEE integrating with Essbase, finally we are getting closer to one vision of true reporting--relational and OLAP sources married together in a way that actually works and makes sense.
BUT...OBIEE doesn't work super well with Essbase, it doesn't play together all that great in pre-11 OBIEE releases. I need to try out release 11 and see how well it integrates.
Maybe 2011 will be a better year for reporting integration. And, when are we going to see Reporting and Analytics integration? OBIEE and crystall ball all rolled up together--man, that would be sweet.
BUT...OBIEE doesn't work super well with Essbase, it doesn't play together all that great in pre-11 OBIEE releases. I need to try out release 11 and see how well it integrates.
Maybe 2011 will be a better year for reporting integration. And, when are we going to see Reporting and Analytics integration? OBIEE and crystall ball all rolled up together--man, that would be sweet.
Subscribe to:
Comments (Atom)