How to configure DFF field and publish it to BI(OTBI) in Fusion?
Hello All,
-> If you want context sensitive , Click on Mange contexts to create new context.
-> Click on create(+) icon under Context sensitive segments section to create new segment and enter the required details.
Name : Display Name for additional field.
Code: Unique code for this segment
API Name: name of the field the way you want to appear in the APIs(web services)
Data Type: Data Type of the field.
Table COlumn: table column where you want to store this field.
value set: List of values that you want to restrict the user. You can check Value set post to see how to create value set.
-> Check BI Enable Flag(bottom of page) if you want to make this filed available in OTBI.
-> Finally Deploy the flex field by clicking on Deploy Flex field button on Flex field search screen
-> Schedule 'Import Oracle Fusion Data Extensions for Transactional Business Intelligence' process to make this field available in OTBI
-> Enter the value and create an OTBI analysis to test your configuration
A lot of times, we have a requirement to enable the DFF in fusion and make it available in OTBI subject area. Let us see how to implement this functionality?
-> Login to cloud and navigate to 'Setup And Maintenance'
-> Search for 'Manage Descriptive FLexfiled' task
-> Click on 'Manage Descriptive Flexfields' task and search for the DFF that you want to configure.
-> Click on the edit and navigate to ' Edit Descriptive Flexfield' screen
-> If you want context sensitive , Click on Mange contexts to create new context.
-> Click on create(+) icon under Context sensitive segments section to create new segment and enter the required details.
Name : Display Name for additional field.
Code: Unique code for this segment
API Name: name of the field the way you want to appear in the APIs(web services)
Data Type: Data Type of the field.
Table COlumn: table column where you want to store this field.
value set: List of values that you want to restrict the user. You can check Value set post to see how to create value set.
-> Check BI Enable Flag(bottom of page) if you want to make this filed available in OTBI.
-> Finally Deploy the flex field by clicking on Deploy Flex field button on Flex field search screen
-> Schedule 'Import Oracle Fusion Data Extensions for Transactional Business Intelligence' process to make this field available in OTBI
-> Enter the value and create an OTBI analysis to test your configuration
Comments
Post a Comment