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...)
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...)
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...)
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
Recently, I was talking with a customer about some creative uses for MDX and they told me about some cool things they (more...)
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...)
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...)
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...)
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...)
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...)
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 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:
- Open a CMD window
- Navigate to the bin folder for Weblogic. Mine is located at C:\oracle\Middleware\user_projects\domains\ClassicDomain\bin
- Run startweblogic.cmd
- Provide a username - in my case weblogic
- Provide the password
- When started, leave the CMD window open
Next, I (more...)
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.
Hope This Helps
Sunil S Ranka
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 18.104.22.168 then you might get the following error.
Assertion failure: false at line 1320 of project/webhttp/httpstream.cpp[[
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
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...)
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...)
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 22.214.171.124.002, 126.96.36.199.003, and 188.8.131.52.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...)
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...)
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...)