Hello Expert,
I'm learning BIP, and I want to learn how to use Flexfield in an Oracle BIP parameter. Can anyone explain end to end with an example.
Hello - have you looked at the documentation? Have you search the forum?
What have you found and what are the gaps? Does this not answer your question? https://community.oracle.com/products/oracleanalytics/discussion/24032/how-restrict-custom-bi-report-data-based-on-flexfield-segment-value?utm_source=community-search&utm_medium=organic-search&utm_term=BIP+FLEXFIELD
Here is a very nice and simple document from Oracle Support with end to end example
Oracle Fusion Recruiting Cloud: BIP: How to Display a Descriptive Flexfield (DFF) in the Requisition Approval Notification (Doc ID 2671843.1)
Hope it helps!
Hi Flying,
Welcome to Oracle Analytics community.
You don't need any special steps to display flexfields in BIP. Once the DFF attribute is configured, relevant table column will be populated with data. You can then write a simple SQL statement to display data from that DFF field in your parameter.
Or if your question is something different, please provide some more details on your requirements.
Thanks,
Mandeep.
If you are talking about Flexfields available on Data model screen, please go through the below documentation:
6 Adding Flexfields
Thanks.
Hi @MandeepGupta ,
I want to learn about Flexfields in the Data Model. It seems the Oracle documents are not beginner-friendly. Could you please share your experience here
There are tons of YouTube videos, you can watch few of them and see if it helps in your learning journey.
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?