Dynamic display of sets of columns in OTBI or BIP reporting tools depending on run location

Michael John Sabaco

Organization Name

Marriott

Description

Hi

We have a gap in our requirements where we need the reports to only display country specific columns. 

We want our reports (BIP or OTBI) to have the ability to dynamically display different sets of columns or flex fields 
depending on the country the user is from. 

Requirement for the ff OTBI and BIP reports:  (Custom and Seeded Reports)

Use Case and Business Need

Given that we have the ff: columns 

Column A = global column for department name 
Column B = global column for worker name 
Column C = USA only column for highest education 
Column D = Spain only column for work visa 
Column E = Spain only column for city name 

We will build only 1 report, but we are expecting to have different column outputs depending on the country the user or the report is from 

User’s country is Canada = 2 columns, only global column A & column B 
User’s country is USA = 3 columns, global column A, column B, and USA only column C 
User’s country is Spain = 4 columns, global column A, column B, and Spain only column D and column 

More details

Current OTBI and BIP reports always display the columns that was selected when the report was built. (The behavior is static)

Dynamic selection/display of set of columns is not feasible within the current OTBI or BIP reporting tools.

Original Idea Number: 3920af1bcd