Degenerate Dimension

A degenerate dimension is a dimension that is stored in a fact table or data that is dimensional in nature but stored in a fact table. There may be more than one degenerate dimension inside a fact table.

Ex: 

dimension attributes such as invoice number,order number,invoice id  present in fact table can all be classified as degenerate dimensions.

Current Date and Yesterday Date in Dashboard Prompt

1. Create a prompt on date column as per your requirement
2. Expand Options and in Choice List Values option drop-down, select SQL Results and paste below Query ( Based on your Subject Area)

       SELECT CURRENT_DATE  FROM "Project - PRM and Time Management"
       UNION
       SELECT  TIMESTAMPADD(SQL_TSI_DAY,-1,CURRENT_DATE)  FROM
       "Project - PRM and Time Management"     

Thanks,
Naveen

Current Year and Previous Year in Prompt

SELECT YEAR(CURRENT_DATE) FROM "Human Resources - Workforce Profile" 
UNION
SELECT YEAR(CURRENT_DATE)-1 FROM "Human Resources - Workforce Profile"

Thanks,

Display last year data while selecting year in dashboard Prompt

Requirement is to display Current Year and Last Year data when select year from dashboard Prompt..

Steps:
Create a dashboard Prompt and set a presentation variable

Now create a Dashboard Report and call above presentation variable

Create a dashboard with above report and prompt

Display Data of Last 4 Quarters

Requirement is to display data of last 4 Quarters,8 Quarters when user select Quarter from Dashboard Prompt,  Quarter format is 2014 Q 4 , 2013 Q 3 etc.

Steps:
First we will create a report(Control Report) which will give previous quarters data ,This Control report Columns will be called in Dashboard Report

Control Report:

Column Formula of "Year Quarter"
User will select from Prompt

Column Formula of  "4 Quarter Ago" 
CASE WHEN SUBSTRING("Time"."Year Quarter",8,1 ) ='1' THEN CAST((CAST("Time"."Year" AS INTEGER)-1) AS VARCHAR(4))||' Q 1'  WHEN SUBSTRING("Time"."Year Quarter",8,1 ) ='2' THEN CAST((CAST("Time"."Year" AS INTEGER)-1) AS VARCHAR(4))||' Q 2' WHEN SUBSTRING("Time"."Year Quarter",8,1 ) ='3' THEN CAST((CAST("Time"."Year" AS INTEGER)-1) AS VARCHAR(4))||' Q 3'  ELSE CAST((CAST("Time"."Year" AS INTEGER)-1) AS VARCHAR(4))||' Q 4' END

Column formula of "8 Quarter Ago"
CASE WHEN SUBSTRING("Time"."Year Quarter",8,1 ) ='1' THEN CAST((CAST("Time"."Year" AS INTEGER)-2) AS VARCHAR(4))||' Q 1'  WHEN SUBSTRING("Time"."Year Quarter",8,1 ) ='2' THEN CAST((CAST("Time"."Year" AS INTEGER)-2) AS VARCHAR(4))||' Q 2' WHEN SUBSTRING("Time"."Year Quarter",8,1 ) ='3' THEN CAST((CAST("Time"."Year" AS INTEGER)-2) AS VARCHAR(4))||' Q 3'  ELSE CAST((CAST("Time"."Year" AS INTEGER)-2) AS VARCHAR(4))||' Q 4' END

We now will call this report(Control Report)  in our Dashboard Report:
Filter in the Dashboard report is based on Control Report:

Dashboard Report:

Dashboard Prompt is below :

Below is the Dashboard when report and Prompt are taken place:

Sorting of Grand Total Value in Pivot View

In a pivot view, you don't have any options to choose the sort order on any measure columns (column grand total include).

I figured it out a way,thought it might help you as well so posting this.

Example:  Arrange Total Transaction Amount USD Total in Descending Order

Unfortunately, a pivot view is always sort by dimension so For that we need add another metric name it as sort with the measure 'Total Transaction Amount USD Total" in the below format

Add a new column in the report

and in the edit formula

CAST(RANK(SUM("Fact Table"."Total Transaction Amount USD" BY"Dimension Table"."Incurred by Person Name")) AS INTEGER)

and treat that column as an attribute column by clicking on the check box shown below:

Then in the report it will appear as below:  the Sort column is available in the report we can hide that by using Column Properties.

Finally the report sorted by Descending order on Grand Total as below:

Thanks

Difference B/W OBIEE 10g and 11g

• OBIEE 11g uses WebLogic Server as the application server as compared to Oracle AS or OC4J in OBIEE 10g. 
• The session variables get initialized when they are actually used in OBIEE 11g unlike OBIEE 10g where they were initialized as soon as a user logs in.
• In 11g Users and groups are created in Enterprise Manager (EM) whereas in 10g Users and groups are created in repository.
• New time series functions PERIOD ROLLING and AGGREGATE AT are introduced.
• Timeseries function can be created in Answers as well.
• Logical Table Source(LTS) Priority ordering is introduced.
•  OBIEE Join is done from fact to dimension whereas in 10g join is done from dimension to fact.
• A new column called the hierarchical column in introduced.
• OBIEE 11g now supports Ragged (Unbalanced) and Skipped Hierarchy.
• Parent Child hierarchy is introduced.
• We can now model lookup tables in the repository.
• SELECT_PHYSICAL command is supported in OBIEE 11g.
• In OBIEE 11g we can create KPIs to represent business metrics.

    In OBIEE 11g there are some changes in terminology as well:

• iBots are renamed as Agents.
• Requests are renamed as Analysis.
• Charts are renamed as Graphs.
• Presentation Columns are renamed as Attribute Columns.
• The new UI called Unified Framework now combines Answers, Dashboards, and Delivers.