What is EFF in BI
|
副标题[/!--empirenews.page--]
Flexfields Series: Extensible Flexfields (EFF) ExplainedOverviewIntroduced with Fusion Applications,Extensible Flexfields (EFF) extend the functionality ofDynamic Flexfields (DFF) by adding features that expand on their scale and scope. In essence this is done by decoupling the flexfield segment values and context from the transaction database tables,storing them in sets of child tables. This allows an unlimited number of both segments and contexts to be used to support a more varied and wide ranging collection of addition information. For example an extra information segment called "Seat Preference" can apply in both the contexts of Air Travel or Land Travel. As you will note from the screenshots below,in basic terms this is implemented using many of the same concepts as DFF's,but adding a few intermediate entities to support further extension. This includes a context supported by one or moreCategories,which themselves can be organized into a hierarchy structure if so desired and may be dynamically displayed based on aUsage value. The categories are shown to the end user in the left-hand sidebar for selection,and offer the related context-sensitive segments arranged into something known as?Logical Pages. As also shown below for multi-row EFF values the UI automatically uses a table to allow for data entry and display as opposed to single-value text fields. Example: Person Extra InformationThe following example shows an out-of-the-box implementation of the the Person Extra Information Template EFF (PER_PERSON_EIT_EFF),and illustrates how this can allow you to both configure the implementation to fit your needs or to add the implementation by creating your own segments and related categories,contexts,and pages. There are extensive steps on the planning,design and implementation of EFF's in both the standard documentation and also product-specific implementation guides. See the references section at the end,and as such this article just provides an illustative overview of the main features.This first screen (click to enlarge) shows the HCM users Manage Person page that displays the EFF at run-time. Note how the multi-value Disciplinary Details context is implemented as a table to support multiple segment rows.
So let's see where this is setup. First we go to the Manage Extensible Flexfields task in the Setup and Maintenance screens. Here we can search for the EFF we're after. As you can in this small set of results there are EFF's for Product Items,Jobs,Organizations,and People (click to enlarge). Check your product-specific implementation guide for more details on what is available for your functionality.?
Upon editing one of the EFF's listed the next screen (click to enlarge) shows the detail and you'll notice the addition (compared with DFF) of theCategory intersection against which child Contexts and Pagesare stored. In this simple case there is only one category although you'll notice that each of the additional contexts can have single or multiple row behavior. Let's look at theDisciplinary Details context.
This context shows five segments available which are used based on the runtimeUsage setup - again actually singular (i.e. global) in this example (click to enlarge).
If we drill into the Disciplinary Level segment we see the attribute properties that control the fields display and constraints (just like DFF's),including theValue Set assigned. The screenshow below shows the LOV values used in this case.
（编辑：拼字网 - 核心网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
