Reusable Bins/Custom Fields — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Reusable Bins/Custom Fields

Submitted
12
Views
5
Comments
Dana Chaffin
Dana Chaffin Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

Description

[11.1.1.9] Reusable Bins/Custom Fields

Use Case and Business Need

I would like to have a Bin or custom field formulas in OBI that are reusable. This would allow me to maintain the Bin/Formula in one location and it would dynamically update all of the reports and filters that are associated with it.

An example would be our recruiting model. We are regional based on the recruiter location. Any changes to the region breakout, new recruiters, or recruiter alignment requires us to go in and update every report, filter, dashboard prompt and analysis with the updated information.

Original Idea Number: ddb04f8092

1
Up
1 votes

Submitted · Last Updated

Comments

  • User720640-Oracle
    User720640-Oracle Rank 5 - Community Champion

    You can create a shared filter and reuse this filter in reports.  When the filter formula changes, you only need to change the shared filter formula once and all reports using this shared filter will pick up the new logic.  How to create a shared filter: click New -> Filter; create the filter and save it in a shared folder;  add this shared filter to a report.

  • Dana Chaffin
    Dana Chaffin Rank 1 - Community Starter

    Thank you for the response. I like the filter idea and will give it a try.

     

    Will this allow the field to be in the output as well as just being filtered on?

     

    For example: Regions. We'd like to see Central Region, for example, in the output as well as being able to filtered on. Right now, we're updating all of our reports when we get a new recruiter or if a recruiter moves to another region.

     

    Thanks.

  • Raghavendra Raghunath-Oracle
    Raghavendra Raghunath-Oracle Mod

    Dana,
    A new feature to 'Save a custom column and re-use it across analyses is implemented in OBIEE 11.1.1.9
    This will help your use case
    Thanks
    Raghu

  • Priya Agarwal-27785
    Priya Agarwal-27785 Rank 2 - Community Beginner

    Hi Raghu,

     

    Could you please elaborate the "Custome column " feature.

     

    How can I create it in OBI report

  • Jordan DeLellis-15803
    Jordan DeLellis-15803 Rank 1 - Community Starter

    Hello - Did you ever learn how to do this? We are hoping to do the exact same thing. Thanks!