Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PBCS how to let users add metadata (with attributes)

M_RighiniMar 17 2021

Dear all,
I'm working on PBCS and I'm facing how to give users the ability to dynamically add metadata (to a sparse dimension). Right now I'm building the app on a BSO.

  1. Metadata should be added whenever they need without waiting for the administrator to do it.
  2. Metadata must be associated with several attributes in order to work properly when launching business rules and for retrieving purposes.
  3. the member code should be automatically generated and not touchable by the users.
    The solutions I've found so far are:
  4. "Enable Dynamic Member" creation: this allows users to create new members but attributes cannot be provided. Also, as they have to provide the "name" of the new member and it will become the code when I'll refresh the db. The code provided by the users could be really bad (too long or wit spaces).
  5. Use DataManagement : In this case they should create a txt file with all the information (including attirbutes) but the risk is that they provide incorrect information in the source file. Also, there can be 10 users working and requesting pbcs to refresh every time they load metadata.
  6. Build a totally custom solution creating some members placeholder in advance that can be activated using a business rule. The member is hidden in the form with suppress. They run a rule from a menu that assigns a filter (i.e "1" to a specific combination) making the member visible in the form. Attributes cannot be added in advance.
    Do you have any suggestions or other solutions?
    Many Thanks in advance
    Bye
    Maurizio
This post has been answered by Rahul S on Mar 19 2021
Jump to Answer
Comments