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.

Back to basics.....

Hello again...

In some previous we have discussed about the Dimensional Modelling, Datawarehousing, Facts and Dimensions etc...
But where and how are all these things used and How are they related to Analytics????

Actually Analytics is a reporting tool which aims to provide users the reports as per their requirements without much efforts and in less time.  So, to fullfill all these requirements we use the above mentioned terms....

Analytics generally makes use of DWs for storing data. The DWs have Dimension modelling done in place which help users with a fast response time. Means when a user tries to run the reports and fetch data then all this is done is seconds...

OBIEE config Tags explained...

Hi All

I was just going through a document and it had the tags that we use in the OBIEE config files and other files. This can be of real good help for everybody and would like to share it with all the readers.
Below is the link:

Whts Dimensional Modelling...??

Hi again..

If we remember prev we have discussed about the 2 common industry techniques viz. Datawarehousing & Dimensional Modelling. So i have brought a brief overview of wht exactly is dimensional modelling(DM)...

So lets start....

Whats DM????

Dimensional modelling is a logical design technique used for DWs.

Lets understand it in a diff way. If a user want to c some report of dollar value with region for an eg. so what will he want to c???
He wud like to c a column dollar with region...
Based on the user requirement the data needs to be segregated in facts and dimensions and the data should have a proper relationship between the fact & the dimension so that the user can c the data is the desired format.

Playing with Facts & Dimensions in DW

As promised in the previous post.. lets learn some more on the DW Schemas and the Facts and the Dimension Tables. Before jumping directly to Facts and Dimensions lets first understand where and why exactly are these Facts and Dimensions used?? So lets start with the DW Schemas....

DW Schemas

A Schema is a collection of Database objects like tables, views, indexes etc. The DW schema is designed based on the model of the source schema and the requirements from the users. There are number of other things that decide the design of a DW and can be classified in 2 categories:
Physical Design
Logical Design
But we wont go into so much details about the DW and lets focus on the Schema Types.
So as discussed in the previous post there are 3 types of Schemas:

Datawarehousing revealed..

As we have studied in the previous post that Analytics makes use of common indutry techniques like Datawarehousing and Dimension Modelling, so lets have a brief overview of what is Data Warehouse and what are the Data Warehousing concepts....

What is a Data Warehouse???

A Data Warehouse is a Relational DB that is designed for query and analysis rather than using it for Transactional purposes(eg. OLTP DB). It contains historical data derived from the transactional data and can also include data fromn other sources. In addition to relational DB it also includes an Extraction, Transformation & Loading(ETL) solutions, Online Analytical Processing(OLAP) & Data Mining capabilities.

Lets start with the Basics

Hi All

Lets start with some basics for why we use Analytics. I knw this is a very basic thing and everybody must be knowing this but still there are a number of newbies who wana learn BI and search for some matter on the same. So lets start...

WHY ANALYTICS???

First of all Analytics is a Reporting tool which provides users with the data and tool to answer their queries that are important to run their business. Eg. The users like Managers etc. need reports to check how their business is going on  and what are the profits and lossess, and what opportunities are there in what all regions etc. These reports can be made available to the users on just a click using Analytics. The users dont have to write queries or take out xcels and do all such efforts.