Business Intelligence

Qlikview is now a Leader

noreply@blogger.com (Manohar Singh Rana) — Fri, 27 May 2011 23:56:28 PDT

Hi, As I was expecting, Qlikview joined the leaders quadrant in Gartner's magic quadrant for BI 2011. Qlikview is cited as a self contained BI Platform and the strengths being interactive, great visualization and end user friendliness and satisfaction. I am very happy about it. But I am more focused on seeing the challenges ahead. It will be interesting to see how Qlikview maintain that position

Enhance Business Intelligence Performance

noreply@blogger.com (Manohar Singh Rana) — Fri, 15 Apr 2011 21:42:01 PDT

Hi All, In any Business Intelligence Implementation, the key factor is the performance. Performance factor always plays a key role in User accepting or liking the application. We should do everything possible to enhance the performance and here are some tips some of which are very generic and can be used in any BI Implementation. From a solution perspective: 1. Use of Datawarehouse: Though a

Pivot table: OBIEE 11g Vs Qlikview

noreply@blogger.com (Manohar Singh Rana) — Thu, 23 Dec 2010 01:27:19 PST

Hi, With the launch of new version of Oracle BI OBIEE 11g, some new features and enhancements got added. I installed the new version and started looking at the new features. This is completely a new experience. The look and feel is very much improved now and is much better. Here in this post I will discuss only about the new feature introduced in Pivot charts. Now the pivot has the ability to

Column Selector feature in OBIEE and Qlikview

noreply@blogger.com (Manohar Singh Rana) — Mon, 13 Dec 2010 19:39:29 PST

Hi, In one of the projects, there was a requirement to have column selector. There should be some fixed columns in a report and some columns which the user should be able to change by simply selecting the column from a list and not going to the design mode or ad hoc mode. Here we will see how we did it in OBIEE using the column selector feature and how we can do it in Qlikview. Lets first create

BI Project Implementation Life Cycle

noreply@blogger.com (Manohar Singh Rana) — Tue, 30 Mar 2010 21:58:58 PDT

Hi, Recently I went through the website of Qliktech and read where it says "And unlike traditional BI, QlikView delivers immediate value with payback measured in days or weeks rather than months, years, or not at all.". It made me think for a while. what are they referring to ? Do they mean Qlikview as a BI solution can be implemented in weeks? Are they talking only about small department level

Hyperion Essbase Book

noreply@blogger.com (Manohar Singh Rana) — Thu, 30 Jul 2009 09:17:12 PDT

Hi,One good news for people who wants to learn Hyperion Essbase on their own.There are not many books available on Essbase and I know only one book which is available 'Look smarter than you are with Hyperion Essbase' by Edward Roske.Sarma and Joseph have written a 444 page book on Hyperion Essbase 9 with the title'Oracle Essbase 9 Implementation Guide'.The book covers Installation, Essbase cube

Qlikview Personal Edition

noreply@blogger.com (Manohar Singh Rana) — Fri, 24 Jul 2009 23:04:49 PDT

Hi,Qlikview is the emerging name in the Business Intelligence world and becoming very popular among the user community due to its easy to use interface, fast deployment and very strong visualisation.Qliktech released its version 9 recently with a new Edition called Qlikview 9Personal Edition having all the developer features.Earlier Qlikview use to provide only 15 days of evaluation period for

Brio Cell Double Click

noreply@blogger.com (Manohar Singh Rana) — Sat, 13 Jun 2009 12:29:56 PDT

Hi,Sometimes there is a requirement wherein users would like to see the detailed data by simply double clicking on a data cell value of a summary report. This feature is illustrated in the snapshots below. Let's say this is a summary report in a dashboard showing total sales value for some particular product category. Now for example if a user want to see the detailed breakup of value '250169.11'

Essbase Application Migration

noreply@blogger.com (Manohar Singh Rana) — Tue, 03 Feb 2009 23:48:58 PST

Hi,Here we will see how you can migrate an Essbase application from one server to another using Hyperion Shared Services Console Migration Utility version 11.1.1.1 when two systems are not connected to each other.We will fist create an application on the target Essbase server and then migrate the application to a file system and finally migrating to the target server.I have named it MSR_TEST for

Interactive Reporting with Essbase

noreply@blogger.com (Manohar Singh Rana) — Mon, 09 Feb 2009 23:07:05 PST

Hi,Today we will see how Hyperion Interactive Reporting treats Essbase.First open the IR studio and make a connection with Essbase server.Make a new database connection.Select Essbase in both the drop downs.Clicking on next and provide the Essbase server and username details.Here you will be asked to select the cube and dimensions. Select any dimension and finish.This is how the cube dimensions

Hyperion Financial Reporting- Row Headings Before

noreply@blogger.com (Manohar Singh Rana) — Tue, 27 Jan 2009 23:20:50 PST

Hi,Some of my customers saw this type of report in one of the Oracle's financial reporting datasheet and asked me whether that has been made in Financial reporting studio only and if I can show him how to do that.So just thought to share it with all of you as well.Today we will quickly see how we can create such reports in Hyperion Financial Reporting.Select your rows and columns as shown below.

Pentaho - Open Source BI

noreply@blogger.com (Manohar Singh Rana) — Sat, 24 Jan 2009 13:14:45 PST

Hi,From past few days I was really very anxious to try my hands on Pentaho.I heard a lot about the open source Business Intelligence Tools and two names that comes to my mind are Pentaho and Jaspersoft.So I simply logged on to the Pentaho Website and looked for some demos. Then I looked at the hosted environment. The website is bit confusing and a new visitor like me found it really difficult to

Gartner BI Magic Quadrant 2009

noreply@blogger.com (Manohar Singh Rana) — Thu, 22 Jan 2009 00:16:09 PST

Yesterday just got a chance to look at Gartner's Magic Quadrant for Business Intelligence 2009.I am really happy to see Qlikview almost touching the Leaders Quadrant Boundary and may be by next year Qlikview will join the leaders club.So that's a good news for people who have invested in this technology.This would be really interesting to watch how Qlikview will compete with the leaders. The

Security Filter Essbase Tutorial

noreply@blogger.com (Manohar Singh Rana) — Wed, 18 Feb 2009 02:47:24 PST

Hi,Today we will see how you can create a security filter in Hyperion Essbase and restrict a user to see only the permitted data.Let's say I want to restrict a user to have access to only January Month.We will first start with creating a user in Essbase native security with non-administrative rights. Then as our next step we will create a filter of January month and then assign this filter to the

Hyperion Workspace 11

noreply@blogger.com (Manohar Singh Rana) — Tue, 30 Dec 2008 10:06:20 PST

Hi,Today let's take a look at Hyperion Workspace 11.Workspace is a pure web client acting as a single window access to all Hyperion components. It also work as a file management system wherein you can manage all Hyperion documents along with generic files like Word, pdf, html etc.Those who are not aware of Workspace, please read my earlier post Hyperion Workspace.Lets look at Some of the features

Qlikview - Slider

noreply@blogger.com (Manohar Singh Rana) — Tue, 30 Dec 2008 10:25:18 PST

Hi,Just take a look at the slider options available in Qlikview.Here is a sample slider which is linked to a variable and by sliding it you can see the effects in the chart column "what-if Act Vs Bud".Now you can link a field to this slider or you can create a variable and assign this slider to this variable. You can decide a scale for this slider. Here I have mentioned a scale for 0-10. You also

Hyperion Interactive Reporting Enhancements- Live Charts

noreply@blogger.com (Manohar Singh Rana) — Mon, 29 Dec 2008 07:45:21 PST

Hi,I will quickly show you the new live charts introduced in version 11.You may also be interested in similar earlier posts.Hyperion Interactive Reporting Enhancements-ChartsHyperion Interactive Reporting EnhancementsHyperion Interactive Reporting TutorialHyperion Interactive Reporting DisadvantagesOn left hand side of the IR studio, look under Live charts section where you will notice chart

Hyperion Interactive Reporting Enhancements - Charts

noreply@blogger.com (Manohar Singh Rana) — Sat, 17 Jan 2009 10:09:41 PST

Hi,In earlier releases IR was simply lacking in Guage charts like speedometer, thermometers and Sliders which are very frequently used in measuring ratios and are an important content in a dashboard.You may also be interested in similar posts.Hyperion Interactive Reporting EnhancementsHyperion Interactive Reporting TutorialHyperion Interactive Reporting DisadvantagesWhen you open IR studio, you

Hyperion Interactive Reporting Enhancements

noreply@blogger.com (Manohar Singh Rana) — Mon, 29 Dec 2008 07:49:21 PST

Today I am going to demonstrate new enhancements in Interactive Reporting version 11.Now you can users to do drill down and many other options in IR documents that have been imported in Hyperion Workspace.You may also be interested in similar posts.Hyperion Interactive Reporting Enhancements-ChartsHyperion Interactive Reporting Enhancements- Live ChartsHyperion Interactive Reporting

Hyperion Brio Impact Manager

noreply@blogger.com (Manohar Singh Rana) — Wed, 17 Jun 2009 07:31:04 PDT

Hi,Today, let's understand and discuss about the Impact Manager feature available in Brio or Hyperion Interactive reporting.Impact Manager is a utility which can be very useful in situations where you want to find out the dependencies of a particular column of a database table being refrenced in Brio data models and queries.let's say for example there is a proposed change in table definations of

Essbase Interview Questions

noreply@blogger.com (Manohar Singh Rana) — Sun, 08 Feb 2009 09:15:04 PST

Hi,You may like to read my earlier post Hyperion Essbase Interview Questions.Today I will be posting few more questions on Hyperion Essbase more from an Administrative perspective.The questions and answers have been designed by me and are not copied from anywhere.Que:1 What are LRO's( Linked Reporting Objects)?Answer: They are specific objects like files, cell notes or URL's associated with

Hyperion Visual Explorer(HVE) Demo

noreply@blogger.com (Manohar Singh Rana) — Thu, 29 Jan 2009 00:46:22 PST

Hi,Today I have created a informal video demonstration of Hyperion Visual Explorer(HVE).The demonstration is for end-users or analysts.The demonstration will give you an idea of HVE, its capabilities and features.HVE is same as the Tableau software with some changes like in Tablaeu software you can connect to multiple sources(relational, multidimensional and flat files) and also you have more

Hyperion Essbase Demo

noreply@blogger.com (Manohar Singh Rana) — Fri, 17 Sep 2010 04:51:05 PDT

Hi, Today I got some time to create an audio-visual demonstration for Hyperion Essbase Excel Add-in. The demonstration is for end-users or analysts. The demonstration will give you an idea of Hyperion Essbase, its capabilities and features. This demonstration is for general purpose only and in no way should be used for any activity other than general information. * The links to the files

Implementing Business Intelligence

noreply@blogger.com (Manohar Singh Rana) — Wed, 10 Dec 2008 02:42:32 PST

<!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman";

Oracle Hyperion EPM 11.1.1 Installation and Configuration

noreply@blogger.com (Manohar Singh Rana) — Sun, 28 Dec 2008 21:35:43 PST

Hi,There is a step-by-step guide available to install and configure complete EPM 11.1.1.Oracle Hyperion EPM 11.1.1 Installation and configurationPlan your installation and download the necessary components only.If you are installing complete system, make sure you have 2GB or more machine.You need to have database installed as a prerequisite. Installing Oracle Xpress edition database instead of