Have u ever thought why we start and stop SAS & SAW in defined orders???

Hi again.....

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

Implicit Fact Column in the Admin Tool

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 in such a manner where i take only 2 dimension columns from the 2 dim tables and no fact column eg: I wana c number of opptys in an year.

What will happen???

Connection Pool in Admin Tool....

Hi All,

m back again after some gap... 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 pool for each database. When you create the physical layer by importing a schema for a data source, the connection pool is created automatically. You can configure multiple connection pools for a database. Connection pools allow multiple concurrent data source requests (queries) to share a single database connection, reducing the overhead of connecting to a database.

For each connection pool, you must specify the maximum number of concurrent connections allowed. After this limit is reached, the Analytics Server routes all other connection requests to another connection pool or, if no other connection pools exist, the connection request waits until a connection becomes available.

Informatica Basics...

Hi Frens...

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 warehouses like data marts. 

• Power Center supports global repositories and networked repositories and it can be connected to several sources. Power Mart supports single repository and it can be connected to fewer sources when compared to Power Center. 

• Power Mart can extensibily grow to an enterprise implementation and it is easy for developer productivity through a code less environment.

Working with Joins on Admin Tool...

Hey All...
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 which the data from the underlying DB will be pulled. These are the joins between the PK FK columns in the facts and dimensions. These joins are used between defined columns between 2 tables. As shown in the pic below the jons are defined between 2 columns which can be seen from the expression.

Physical Foreign Key Joins Diag.

Differences Between Siebel Analytics & OBIEE

Hi...
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 rep objects. Its an XML doc.
In OBIEE this can be accessed directly from BI Answers selection pane where specific metadata information will be shown to guide report construction. Once this BI Answers based functionality is been enabled an icon will appear next to each Subject Area, Table name, and Column shown in the selection pane for that Subject Area. Clicking on the icon will open up a specific Metadata Dictionary page to show information for that element and links to related repository information

Clustering & Load Balancing Of BI Server

Hi....
I have read something and wud like to share that with u... Mite help u.... have a look...

Clustering capability  allows for the deployment of a multi-server environment to better manage large volumes of users and to provide high availability.


TYPES OF CLUSTERS

Describes the different types of computer clusters.

High-Availability (HA)
The main function of High-Availability clusters is to improve the availability of the computing system in case of a breakdown. In HA clusters not all nodes may be contributing to the operation at a given moment. Some of the nodes are redundant standby nodes that operate only in case of the failure of the main node. This connfiguration is referred to as ‘active-passive’ deployment.