Relation between OM and AR-EBS

SELECT OH.ORDER_NUMBER,
CT.TRX_NUMBER "INVOICE NUMBER",
OH.SALES_CHANNEL_CODE,
to_char(OH.ORDER_NUMBER),
CT.INTERFACE_HEADER_ATTRIBUTE1
---D.ORGANIZATION_CODE "WAREHOUSE ID"
FROM
APPS.OE_ORDER_HEADERS_ALL OH,
APPS.RA_CUSTOMER_TRX_ALL CT
---APPS.ORG_ORGANIZATION_DEFINITIONS OD
where CT.INTERFACE_HEADER_ATTRIBUTE1=to_char(OH.ORDER_NUMBER)
--AND OH.SHIP_FROM_ORG_ID=OD.ORGANIZATION_ID
AND CT.TRX_NUMBER='10009802'

SELECT ooha.order_number,
oola.line_number so_line_number,
oola.ordered_item,
ooha.sales_channel_code,
oola.ordered_quantity * oola.unit_selling_price so_extended_price,
rcta.trx_number invoice_number, rcta.trx_date, rctla.line_number inv_line_number,
rctla.unit_selling_price inv_unit_selling_price FROM  
apps.oe_order_headers_all ooha, apps.oe_order_lines_all oola, apps.ra_customer_trx_all rcta, apps.ra_customer_trx_lines_all rctla
WHERE  ooha.header_id = oola.header_id
AND rcta.customer_trx_id = rctla.customer_trx_id
AND rctla.interface_line_attribute6 = TO_CHAR (oola.line_id)
AND rctla.interface_line_attribute1 = TO_CHAR (ooha.order_number)
---AND order_number = :p_order_number


select order_number,to_char(ORDER_NUMBER) from apps.oe_order_headers_all

KPI's & Scorecards in OBIEE 11g

https://docs.google.com/file/d/0B49fWjsxFWy3SzZqazVXQTF2d00/edit

OBIEE 11g Security

https://docs.google.com/file/d/0B49fWjsxFWy3LTA4M1g5NEVPNHc/edit

This document contains information about OBIEE 11g & 10 g Security 

Analysis Training- OBIEE11g

https://docs.google.com/file/d/0B49fWjsxFWy3ODFIdnBTZWg4X2c/edit?usp=sharing

Please copy the mentioned link  and open it to know about the OBIEE 11g Answers.

New features introduced in OBIEE 11g

http://www.scribd.com/doc/158256265/BMM-Layer-New-Features-OBIEE11g

How to integrate Oracle Apps with OBIEE 11g

http://www.scribd.com/doc/158169671/OBIEE-Integration-With-Oracle-Apps
Thanks to my friend Sujit for helping me to document this.

The secret functions in OBIEE

The secret functions in OBIEE? 

TO_DATETIME is such a function.

To be fair, you can see this function in the Administration Tool, but there is no reason not to use it in analysis directly.

What does it do? It lets you control the date format of a given date & time string and converts it. No longer the tyranny of specific formats of the cast function. For example the following returned the timestamp I needed: 

to_datetime ('01 / 08/2013 21:00 ',' dd / mm / yyyy hh: mi ')

This function Converts string literals of DateTime format to a DateTime data type. Syntax TO_DATETIME ('string1', 'DateTime_formatting_string) Where: string1 is the string literal you want to convert DateTime_formatting_string is the DateTime format you want to use, Such as yyyy. mm.dd hh: mi: ss. For this argument, Represents year yyyy, mm Represents month, dd Represents day, hh Represents hour, mi Represents minutes, and ss Represents seconds.


 

Examples SELECT TO_DATETIME ('2009-03-03 01:01:00', 'yyyy-mm-dd hh: mi: ss') FROM Snowflakesales


 

SELECT TO_DATETIME ('2009 .03.03 01:01:00', 'Yyyy.mm.dd hh: mi: ss') FROM
Snowflakesales

Few more "secret" functions:

Aggregate Functions

FIRST - selects the first non-null returned value of the expression argument.

FIRST_PERIOD - selects the first returned value of the expression argument.

GROUPBYCOLUMN - Used only in Repository.

GROUPBYLEVEL - Used only in Repository.

LAST - selects the last non-null returned value of the expression.

LAST_PERIOD - selects the last returned value of the expression.

STDDEV_POP - returns the standard deviation for a set of values ​​Using the
computational formula for population variance and standard deviation.

Math Functions

EXTRACTBIT - retrieves a bit at a particular position in an integer. It returns an integer
of 0 or 1 Either Corresponding to the position of the bit.

 Conversion Functions

CHOOSE - returns the first item in the list that the user has permission to see.

INDEXCOL - exists in Admin. Tool. Can use external information to return the appropriate column for the logged-in user to see.

Database Functions

EVALUATE_ANALYTIC - exists in Admin. Tool. This function passes the specified database analytic function with optional referenced columns as parameters to the back-end data source for evaluation.

EVALUATE_PREDICATE - exists in Admin. Tool. Passes the specified database function with optional referenced columns as parameters to the back-end data source for evaluation. This function is intended for functions with a return type of Boolean.

Hierarchy Navigation Functions

IDOF -
ISANCESTOR
ISCHILD
ISDESCENDANT
ISLEAF
ISPARENT
ISROOT
PARENT