nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Finding the corresponding mapped Siebel field to OBIEE's Presentation layer

3025352

Hi all,

I'm fairly new to OBIEE and I'm needing to find out what Siebel field/fields makes up a particular fact field in the Presentation layer. I can trace it back to the physical layer in the repository, but I need to know the exact field/fields names in Siebel. I've attached a screen shot of the column source from the repository and I don't know where to look any further. It says it's derived from 'sum(Fact_W_AGREE_F.GLOBAL1_TOTAL_AMT)' but I don't know what Siebel field is 'GLOBAL1_TOTAL_AMT'. I've also tried following the mapping in Informatica Powercenter Designer and I can't seem to find the correct field.

Also, if I may ask.. why is there 2 fact tables in the Column Source Type? What does that mean?

Thank you for your time and help.

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

1.) The info you're looking for is found by tracing back through the Informatica mappings. They contain all.

2.) Dual LTS mapping in this case (judging from the names) means Agreements facts on header level (total) and on line item level (detail).

3025352

Thank you Christian for that information. If I may follow up with some questions. In the Mapping Designer I was able to trace it back to the Source Definition. Since I was able to do that, what would be my next step to find out what the column in Siebel is because it's still referring to a Warehouse table or is that the column's name in Siebel?

Also, would you mind going into more detail about the 'header level' and the 'line item level'? It vaguely makes sense by what you put in parentheses.

Thank you again for your efforts and time.

Ebin

@3025352,

Apart from the option suggested by Christian, you can also use ETL Data Lineage document to identify the source column. Normally ETL team maintain such a document in every project. If you are using BI Apps and haven't created any custom fields, you can use the Data lineage guide provided by Oracle. Screenshot of the doc is attached below.

3025352

Thank you Ebin. So I was able to find the source table for the Fact_W_AGREE_F.Global_Total_Amt, It is W_AGREEITEM_F.NET_PRI_DOC_AMT, so is that the exact name of the Siebel column?

Ebin

It's not a Siebel Column. You need to to track back to the staging table and then look at the Siebel section in the data lineage. Siebel table name start with S_

3025352

Ebin, can you point me where to find the data lineage document that you have?

Ebin

Refer Oracle Support Doc Oracle Business Intelligence Applications ETL Data Lineage Guide Release 7.9.6.4 (Doc ID 1527475.1)

3025352

I don't have access to it I need a support identifier

Ebin

I Checked up the data lineage for you. In the OOTB mapping, the column you mentioned above is sourced from Siebel table S_AGREE_ITEM and column NET_PRI. There are some conditions applied on top of this on the target mapping. Check the Informatica mapping to identify those.

[Deleted User]

Without an SI you're not allowed to access this information. It's only for paying customers.

You will need to go to the Informatica mappings and trace it back as I stated already.

Upcoming Event

Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion SCM Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…

Top Leaders