Skip to main content

Selection Steps in OBIEE 11g



In obiee 11g we have the option named as “Selection Steps

Selection Steps is the new feature added in OBIEE 11g to be very useful for calculations.
Steps included the condition formats (Conditions) like

·         Exception

·         Top/Bottom

·         Match
Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
Exception

·         X>=value
·         X>=Y
·         X>=Y+10
·         X>=Y-5%
·         X within 10 of Y
·         X not within 5% of Y
·         X between 'min' and 'max' values


Top/Bottom

·         Top 10 based on X
·         Bottom 5% based on X
·         Making up to 3% based on X

Match
·         Name contains 'abc'
·         All X values where Y = values

1.    X>=Value

In this scenario we are having the sale values positive as well as Negative values too.

Using this condition here going to filter out only above “ZERO” values.

Take a look of all the values contained report.

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
In this report we have the positive values marked with Green Tick mark
Negative values in red Down Arrow mark.

Now going to filter only Positive “Green Tick mark values” using the condition “X>=values

Example

Actual Sum >= 0

Step to go for selection steps, In the Compound Layout end of the page we have + symbol with the name of “+selection steps”

Select the column according to that condition going to apply.

Click on New Step, it will display the “Apply Condition” option

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
Apply condition X>=values, Select the related column for which the values is going to measure.

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
Condition type Determines the type of condition going to use.

Actions which classify into 3 types Keep only, remove, And Add.

Keep only displays the condition values only to display.

Remove displays the other than the condition value (removes the condition values)

Add it displays both the values.

Selection Steps in OBIEE 11g

Here I used keep only type. To show the profit values (positive).

Measure is the column based to filter out.

Operator will decide the value of condition – is greater than , is greater than or equal to , is lesser than, is lesser than or equal to , is equal to, is not equal to.

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
So the revenues are only greater than zero as to display in the report.



Look @ the result.
Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
When the condition with action type as: remove

It will remove these green marked values (positive greater than zero Values) and shows remaining values.

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g



Look @ the report

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g

2.    X>=Y Comparing with other sales and make the difference.

Here I am comparing actual with budget and using the condition actual greater than budget only those values will get display.

Selection Steps in OBIEE 11g

Look the report, so the values will get compare Actual vs Budget and it displays only the higher value of actual.

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g

3.    X>=Y+10 In this condition it will find the greater than values depending upon cost and sales.
X=Cost, Y=sales.
Cost>=Sales+10.
See below example.
Here I am going to use Budget and actual, budget >=actual+10.
Before condition use checks the values.
Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
Condition used here budget values getting compare with actual.

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
Look the Result

It will show the greater values by comparing with budget and actual.

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
4.    X within 10 of  Y

Here it calculates the value within the given value and it will compare with other measure value.

Here I used the condition Actual is within 6000000 for the measure compare to Budget. So the result should be below 600000 value related revenue’s comparing with actual and budget.

Condition before Report:
Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
Condition Used:

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g

Look @ the result:

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
X between 'min' and 'max' values

It define the measure column should be in between the 2 measure values.
Minimum value and maximum value will be the condition to bring the revenue under the between condition.

Before using condition look @ the report.
Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
Condition Used:
Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
I used the condition for the measure value “actual” should between “16687253” and “76443741”, so according to the condition the value is greater than16687253” first value and less than “76443741” of second value.

Look the report:
Selection Steps in OBIEE 11g
Top/Bottom Values.

1.    Top 5 :
It will calculate the top 5 highest values (Actual) of the revenue.

We can use top5 or top more than one.

It is used to compare the highest sale or revenue of the property. Which gives the profit and gain analysis.


Before using condition looks the report:

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g


Condition used: Top 5 values
Selection Steps in OBIEE 11g
Look @ the report:

Top 5 based on Actual for the Revenue.
Selection Steps in OBIEE 11g
2.    Bottom values
It calculates and shows least bottom values.

It calculates like 5 Γ  4Γ  3Γ  2Γ 1 and is used to find out or define the least revenue.

Look the report before condition used:

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
Condition used:
Bottom 5 values, so it calculate and shows like 5-4-3-2-1
Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g

Look @ the report:
Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
It shows least 5 values.

Making up to 3% based on X
It is used to calculate top or bottom values and making up to some percentage on actual revenue.

Match Conditions:

Name Contains ‘abc’ – is the condition used to match the characters and retrieve the report according to the matches.

Look @ the report before using condition:
Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
Condition used:

Here I am using the condition match the characters contains ‘REV’ so it looks on the ACC_DESC Column and finds the value which are all containing “REV” character and shows that values.

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g

Look @ the report:

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g

Condition: Begins with
Before the condition look @ the report
Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g

If the condition “begins with the character” as same above.

Look the condition:

Condition is begin with the characters

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
So the characters has to begin with “REV

Look @ the report after condition:

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
So there are no Names starts with “REV”.

All X values where Y = values

Depending on the Y value it will retrieve the report.

It uses the X value as one column comparing with Y column with the value using the operator.

Look @ the report before using condition:

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
Condition Used:

Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g
Acc_Desc column has to keep the value according to Acc_SumID is equal to the value 2.

So the report should display only the 2 related value.

Look @ the report:
Selection Steps in OBIEE 11g
Selection Steps in OBIEE 11g

Comments

Popular posts from this blog

Contact Me

Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com

Top 130 SQL Interview Questions And Answers

1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10

Informatica sample project

Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope