Oracle Data Miner 4.2 EA : New Features

A couple of weeks ago during the madness of Oracle Open World there was some new product releases and lots of updates to existing products.

One such product was SQL Developer. They released an Early Adopter version (EA1). This is where you can try out the new version of the product, but you need to be careful as it is not the GA/Production version. So it may have some "features".

One component of SQL Developer (more...)

Machine Learning notebooks (and Oracle)

Over the past 12 months there has been an increase in the number of Machine Learning notebooks becoming available.
What is a Machine Learning notebook?
As the name implies it can be used to perform machine learning using one or more languages and allows you to organise your code, scripts and other details in one application.
The ML notebooks provide an interactive environment (sometimes browser based) that allows you to write, run, view results, share/collaborate (more...)

Thoughts/Info on Essbase/EssCS after Oracle Open World 2016

I was at Oracle Open World last week and have some notes to share on the upcoming EssCS (Essbase Cloud Service) product and on Essbase in general.

EssCS will be Infrastructure as a Service (IaaS) product and will be priced on the number of cores and memory.  I believe there will be a metered and an unmetered pricing as well (metered meaning pay per cycle or some other usage measure).  According to presentations at Open (more...)

Cool Essbase MDX Stuff – Dimension Properties Edition

I have always liked MDX as it exposes very powerful operations for creating member sets.  It has this amazing ability to take a set of members, union it with another set of members, intersect it with yet another set of members, and then exclude members from yet another set.  This is very powerful.

Recently, I was talking with a customer about some creative uses for MDX and they told me about some cool things they (more...)

What is Oracle Business Intelligence Cloud Service ( BICS )

| Aug 11, 2016

Recently we have been getting lots of traction on BICS , existing OBIEE customers been asking for BICS . In nutshell :

BI Cloud Service enables organisations of all sizes to quickly and cost effectively deploy business intelligence with the simplicity of the cloud..

Silent features of BICS :

  • No need of software installation
  • No need of software maintenance
  • No upfront costs, low monthly subscription
  • Customers can get started in hours
  • 100% cloud based
  • Robust reporting (more...)

OBIEE 11g: Outer join in the Physical Layer now possible

We know that we can perform outer joins in OBIEE in the Logical Layer. The problem with this mechanism is that it is not possible for one logical table sources (LTS) to join to a fact by an inner join and the other to join to the fact by an outer join. Let us (more...)

ODTUG Leadership Program / ODTUG Board Elections

As many of you know, I have spent many years helping the Hyperion community in many ways.  I have wrote this blog for quite some time, have taken on the OlapUnderground Utilities and provided free support through my company,  In other words, I have worked hard to give back to the community and, in return, have had many kind words from people we have helped.

As a result of this spirit of giving back, I (more...)

Privacy – InMobi Pays $1M In Penalties



image credit: WDnet Agency, pexels.com
In 2015 I had written a series of articles on the e-commerce battle between Flipkart and Amazon, one of which focused on why companies are so obsessed with apps Mobile Apps: There’s Something (Profitable) About Your Privacy.
Now it turns out that InMobi has agreed to pay a US$950,000 in civil penalties to "settle charges it violated federal law." InMobi is described by the US Federal Trade (more...)

Cloud Allergy – Clouds Security and Changing Notion

| Jun 29, 2016

With my recent role as CTO/Advisor with www.analytos.com, during most of my conversation with Analytics leaders within the company, all are concern over security. At a recent conversation with another entrepreneur friend, one of his solution was stalled due to SQL injection issue on the cloud ( a valid concern , but is it valid ?) .

During my recent startup sting, cloud Allergy word was coined, and it did make sense, because allergies do exist and (more...)

Announcing the Dodeca Spreadsheet Management System, Version 7 and the Dodeca Excel Add-In for Essbase

After 18 months of hard work, Applied OLAP is proud to announce the general availability of the Dodeca Spreadsheet Management System, version 7, and the all-new Dodeca Excel Add-In for Essbase.

The Dodeca Spreadsheet Management System provides customers the ability to automate spreadsheet functionality, reducing the risk of spreadsheet errors while increasing productivity.  It combines unprecedented ease-of-use for business users using spreadsheets for planning, budgeting, forecasting, reporting and analysis tasks.  It also provides a robust, (more...)

Are you worried about what to do now that Discoverer is almost out of support

Hello everyone
Like me, if you are a big user of Discoverer, you would have been alarmed at the news a few years ago that Oracle was dropping the tool.

Well, once I got over my alarm I started to think about how my clients could maximize their use of the at times millions of dollars of investment.

Oracle Corporation’s statement of direction implies that they will not force you off of Discoverer and (more...)

Are you having trouble starting Weblogic from a Windows service

Are you having trouble starting Weblogic on Windows and thus unable to start the WLS_DISCO service? If so, you can start Wenlogic from the command line.

To start Weblogic from the command line, follow these steps:
  1. Open a CMD window
  2. Navigate to the bin folder for Weblogic. Mine is located at C:\oracle\Middleware\user_projects\domains\ClassicDomain\bin
  3. Run startweblogic.cmd
  4. Provide a username - in my case weblogic
  5. Provide the password
  6. When started, leave the CMD window open

Next, I (more...)

More Animals in Big Data Zoo – Big Data Landscape for 2016

| Mar 25, 2016

Hi All

While surfing net stumbled upon Big Data Landscape for 2016 image and it was very impressive to see many more new Animals in Big Data Zoo.

 

New Animals

Hope This Helps

Sunil S Ranka


Issue in using EJB Actions in OBIEE 11.1.1.9

This blog is less about a solution and more about an information.

If you have written an EJB that uses a obiee report saved in the catalog as an arguement and you are trying to invoke this EJB using Actions in OBIEE 11.1.1.9 then you might get the following error.


Assertion failure: false at line 1320 of project/webhttp/httpstream.cpp[[ 
File:parametervalueresolvers.cpp 
Line:480 
Location: 
saw.httpserver.processrequest 
saw.rpc.server.responder 
saw.rpc. (more...)

Migrating application roles in OBIEE 11g

My last article talked about a maintenance and hassle free mechanism to implement security. The article moved the security architecture to roles created in EM. The next logical step is to move the roles from one environment to another because lets face it, manually creating roles is a lot of effort.


Oracle has a process to migrate the policy store from one environment to another and is described @ http://docs.oracle.com/cd/E14571_01/core.1111/e10043/addlsecfea.htm#JISEC3593

This (more...)

Big Data – Tez, MR, Spark Execution Engine : Performance Comparison

| Feb 25, 2016

There is no question that massive data is being generated in greater volumes than ever before. Along with the traditional data set, new data sources as sensors, application logs, IOT devices, and social networks are adding to data growth. Unlike traditional ETL platforms like Informatica, ODI, DataStage that are largely proprietary commercial products, the majority of Big ETL platforms are powered by open source.

With many execution engines, customers are always curious about their usage (more...)

Maintenance free security implementation in OBIEE 11g

This blog talks about a hassle free mechanism of OBIEE security implementation with almost zero overhead.
We will first look at the data level security implementation and then extend it to object level security.


Data Level Security:
Data level security is usually implemented using database tables. These tables store the users and the filter (more...)

Next Generation Outline Extractor 2.0.5.1073 released



In the last week or so, we placed an updated version of the Next Generation Outline Extractor on our website. This version provides support for some updated Essbase versions, including 11.1.2.4.002, 11.1.2.4.003, and 11.1.2.4.005. More importantly, it addresses a bug where alias names were improperly associated with parent members when using the MaxL extraction source.. This bug was reported to us by a (more...)

Show me the money – Business Intelligence

This Business Intelligence article discusses one very important question “Have we lost the true meaning and purpose of Business Intelligence?”

In summary, it says that the bottom line for any Business Intelligence is to increase profit and performance and if done wrong it is absolute waste of time and money.

So if your management is hooked on the Big-Data wagon and fantasizing about the hidden gold behind the untapped data sources such as social (more...)

How many startups did Google purchase and what did it do with them?

Ever wondered, how may startups or companies did Google acquire so far and how much did it pay for them?

But the main question is, what happened to the acquired companies? Was it all waste of money?

With the recent re-structuring, Google became a subsidiary of Alphabet Inc., which now owns most of the parts.

Using infocaptor kpi dashboard software, we analyze the list of companies, products and services that Google has acquired (more...)