Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Finding the corresponding mapped Siebel field to OBIEE's Presentation layer
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.
Answers
-
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).
0 -
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.
0 -
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.
0 -
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?
0 -
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_
0 -
Ebin, can you point me where to find the data lineage document that you have?
0 -
Refer Oracle Support Doc
0 -
I don't have access to it I need a support identifier
0 -
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.
0 -
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.
0