Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Self-Defined Candidate Facts - Yellow Box
Summary
How to create a self-defined candidate facts using UDF
Content
Hi Experts,
Could someone please walk me through how to create a self-defined UDFs with embedded formula and make it reportable in Oracle BI?
Say, I would like to create a UDF that looks at age of male applicants between 30-40. let's called it Box-A. When developing a new report looking at all filled requisitions, could I pull the BOX-A into a new report and it automatically calculates the numbers based on selected months?
Thank you for taking time to look at my request
Ivan
Answers
-
Ivan - not sure I fully understand your request, so hopefully what I am answering helps you
In the Criteria tab, when you have a selected column with the formulas you want built, you can save that column for use in other reports. You can then bring that field into your report, but would do it from your catalog and not from the subject area.
0 -
Prudence -
Thank you for your reply. I know it's a little confusing but your feedback is the information that I am looking for. Could you elaborate more on the "would do it from your catalog" but not from the "subject" area? I thought "subject" area only shows a collection of report instead of columns?
My understanding for now is I can create a column with saved formulas but I would also like to create a new column with new formulas based on the column that I created. When I tried to search the column by its "name", I can't find it. So I have to create the same column again in a new report. There must be an easy way to do this but I couldn't find it.
Thank you again for your help
Ivan
0 -
Prudence -
I spoke with one of Oracle developers, it turns out we are using an older version so I couldn't use the function that you mentioned earlier. I will try it again when we push it to the production environment.
Ivan
0