BI Answers »

[10 Mar 2010 | No Comment | 94 views]

Hi friends,
Sorry for not posting for a long time. I was stuck and was little busy with things. But have just taken out some time to write and share with the things i encountered.
Today, I came acros a wierd scenerio wherein the filters didnt worked properly when we navigate from one report to another on Dashboard.
I had [...]

Oracle Fusion »

[20 Jan 2010 | No Comment | 267 views]

Below is the pictorial view of the Oracle Fusion Middleware which also gives pictorial description of terminology as well as concepts of Oracle Fusion.

Gains from Oracle Fusion

While viewing the technical part of Oracle fusion one point which we can overlook is the gain which this tool will give us in the market. Whatever tools [...]

Oracle Fusion »

[20 Jan 2010 | No Comment | 266 views]

This post has been contributed by Ankesh who is a reader of this blog.  He wants to share his views about Oracle Fusion.
——————————————————————————————————————————-
Before we start with what oracle fusion really is and the magic it does let’s familiarize ourselves with the basic terminologies which we may have come across.

BI Admin Tool »

[14 Jan 2010 | 2 Comments | 269 views]

We have discussed the basics about the connection pool in one of the previous post. Connection Pool is a very important repository object and we should have a good knowledge of that. Moreover, many interview questions are based out of this. Now, lets understand something more about it…

BI Servers and Architectures »

[18 Dec 2009 | No Comment | 168 views]

Did this thing ever come into ur mind that why we stop SAS(Siebel Analytics Server) & SAW(Siebel Web Server) in a defined order???
Well it came into my mind… And here is the reason why..
Well first lets talk of whts the order of starting and stopping the SAS & SAW Servers…
Start
SAS -> SAW
Stop
SAW-> SAS

BI Admin Tool »

[15 Dec 2009 | No Comment | 156 views]

Many a times i have heard users facing issues with server picking up improper joins in Admin tool. Lets take an example to understand this and lets c the solution….

Take an example that we have 2 dimension tables viz. Day Dim & Opty Dim and 2 fact tables viz. Revenue Fact & Order Fact. Now, I wana make my report [...]

BI Admin Tool »

[13 Dec 2009 | No Comment | 161 views]

I m back again after some gap… Now, lets understand whts connection pool..
The connection pool is an object in the Physical layer that describes access to the data source. It contains information about the connection between the Siebel Analytics Server and that data source. 
The Physical layer in the Administration Tool contains at least one connection [...]

Informatica »

[30 Nov 2009 | No Comment | 147 views]

Lets go thru some Informatica(INFA) basics and lets see some other important things….
What are the differences between Power Center and  Power Mart???

Power Mart is a departmental version of Informatica for building, deploying, and managing data warehouses and data marts. 

Power center is used for corporate enterprise data warehouse and power mart is used for departmental data [...]

BI Admin Tool »

[27 Nov 2009 | No Comment | 150 views]

Joins is a very common thing and most of the people don’t give much attention how and when we use Physical Joins and when we use coplex joins… Lets c how and why of joins…..
Primary-Foreign Key Joins
The PK-FK joins are generally used in Physical Layer. These joins are required to form the physical query using [...]

Basics »

[24 Nov 2009 | 4 Comments | 255 views]

 
I have heard this question multiple times from many people. So let me share the answer with u guys….
Oracle BI Answers-Based Metadata Dictionary Feature
This feature enables administrators to analyze metadata repository statistics in Oracle BI Answers. The OBIEE server can generate metadata dictionary which describes the metrics contained in a rep and the attribs of [...]