Showing Dimension Data in absence of fact values (Data Densification)!!

31. August 2011 by Sachin Sharma.

Need:- A lot of time there’s a need for showing the dimension records even if the value are not available in Fact table, we want to show those dimensions either null or with value as zero, indicating specifically those dimension values as being null values. Read the rest of this entry »

Posted in OBIEE | No Comments »

Microsoft SQL Server 2008 Installation Steps

14. July 2011 by Priya Sharma.

Database Tools Installation

All of the tools mentioned here are freely available from Microsoft. The files are collected here just for your convenience.

The installation of SQL Server Express uses the full installation wizard. Screenshots of this installation follow, again for your convenience. Read the rest of this entry »

Posted in Microsoft SQL Server | 1 Comment »

Software Design Document

24. June 2011 by Priya Sharma.

software-design-document.doc

Posted in Project SDLC Documents | No Comments »

Implementation Plan Template.

22. June 2011 by Priya Sharma.

Please click on the link to view or download the document.

Implementation Plan

Posted in Project SDLC Documents | No Comments »

Configuring 32 Bit OBIEE Client!!

11. May 2011 by Priya Sharma.

This article talk about Opening the RPD in online mode on 32 bit OBIEE client over 64 and 32 bit machine, I have mentioned in my previous blog that 64 bit OBIEE installation does not support admin tools to be executed, so as a workaround we can use 32 bit OBIEE client Read the rest of this entry »

Posted in OBIEE | No Comments »

How to Get Rid of System Wide Default In OBIEE

10. May 2011 by Sachin Sharma.

Setting System wide default is a very handy toolset of OBIEE but it has some of its major drawbacks, the biggest one is your changes made to custom.css will not take effect on your columns if the system wide default is setup and usually most of the time we are unable to remember that the cause for CSS not taking effect is this naughty XML file containing system wide default values. Read the rest of this entry »

Posted in OBIEE | No Comments »

OBIEE 11g Installation on Windows (64-bit)

29. April 2011 by Sachin Sharma.

Make a note of: OBIEE 11g (11.1.1.3) BI Administration Tool does not work under Windows 64-bit OS. It is expected that the next release of OBIEE 11g (11.1.1.4) will support 64-bit Operating Systems for the OBI Client applications. But Presentation Services work with the present release.

OBIEE 11g Client 32 Bit can be used for Admin tools, as Oracle claims that it works in 64 bit environment as well. Read the rest of this entry »

Posted in OBIEE | No Comments »

How to uninstall Oracle 11g On Windows

29. April 2011 by Priya Sharma.

Uninstall Oracle software 11.2g


In 11.2g there is deinstall command through which you can uninstall standalone Oracle Database installations, Oracle Clusterware and Automatic Storage Management (ASM) from your server, as well as Oracle Real Application Clusters (Oracle RAC) and Oracle Database client installations. You can find out deinstall tool under $ORACLE_HOME/deinstall folder.If you don’t have deinstall tool you can download it from url http://www.oracle.com/technology/software/products/database/index.html Read the rest of this entry »

Posted in ORACLE | 1 Comment »

SQL Server Management Studio Express

18. April 2011 by Priya Sharma.

SQL Server Management Studio Express

Part 1

Start up:

This write-up is about the SQL Server 2008 Management Studio. Read the rest of this entry »

Posted in Microsoft SQL Server | 1 Comment »

Cache Management in OBIEE!!

11. April 2011 by Sachin Sharma.

Different ways to Manage Cache in OBIEE!!

One of the most powerful features of OBIEE is the way it uses it’s cache. Good cache management can really boost your performance. From the system management point of view there are a couple of tips and tricks to influence the cache performance. Read the rest of this entry »

Posted in OBIEE | No Comments »

Next Entries »