Workforce Performance - Performance Check-In Real Time - issue with table prompts

Question

Hello,

I have following OTBI analysis :

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT0 s_0,"Workforce Performance - Performance Check-In Real Time"."Business Unit"."Business Unit Name" s_1,"Workforce Performance - Performance Check-In Real Time"."Check-In Details"."Check-In ID" s_2,"Workforce Performance - Performance Check-In Real Time"."Check-In Template"."Check-In Template Name" s_3,"Workforce Performance - Performance Check-In Real Time"."Review Period"."Review Period Name" s_4,"Workforce Performance - Performance Check-In Real Time"."Worker"."Employee Name" s_5,"Workforce Performance - Performance Check-In Real Time"."Worker"."Person Number" s_6,DESCRIPTOR_IDOF("Workforce Performance - Performance Check-In Real Time"."Business Unit"."Business Unit Name") s_9,DESCRIPTOR_IDOF("Workforce Performance - Performance Check-In Real Time"."Worker"."Assignment Status") s_10,DESCRIPTOR_IDOF("Workforce Performance - Performance Check-In Real Time"."Worker"."Person Type") s_11FROM "Workforce Performance - Performance Check-In Real Time"WHERE((DESCRIPTOR_IDOF("Workforce Performance - Performance Check-In Real Time"."Worker"."Person Type") IN ('xxx, 'yyy', 'zzz')) AND (case when "Workforce Performance - Performance Check-In Real Time"."Worker"."Probation End Date" > Current_date THEN 'Y' ELSE 'N' END = 'N') AND (DESCRIPTOR_IDOF("Workforce Performance - Performance Check-In Real Time"."Worker"."Assignment Status") IN (……)))

I display the results in a table with prompt on Busine unit. This gives the correct results when I filter on all possible values or any of them (my case A or B) :

CenterLargeAccessibilityDelete

When I add another table prompt (e.g. Review Period Name or Check-in Template Name or any other field) , the results in the table get restricted to only one value of the second prompt. - which is correct

CenterLargeAccessibilityDelete

But an issue appears in the prompts:

-the second's prompt drop down list contains only one value (Template 1 instead of Template 1, 2, 3)

-the first prompt, gets duplicated values - one value per each distinct value of the second prompt ( A,A,A,B,B, instead of A and B)

If I select the second listed A values in Business Unit , I do get the results for Template 2 (same for 3rd A and template 3)

Did anyone face this issue so far ? Was there any fix/workaround in OTBI ?

Thank you!

MariaStanciu · Answer

Thank you ,

Indeed this is how we fixed the issue too, by using dashboard prompts instead of the table prompts.

Rich Merkel · Answer

I have faced this issue before and have not found a workaround.

I only use a single table prompt, when adding second same behavior.

I also tend to stay away from table prompts, I've also found that while building analysis using table prompts, it leads to errors when user further filter using the regular prompt.

For example I built analysis using project cross subject area for all projects, and create table prompt based on project number.  Table prompt will show 1st value in sequence like project 100000.

If there is dashboard prompt/regular prompt and user now selects a range of projects from 200000 to 250000 for example, the table prompt will fail and give error.

Also limitations on # of values in table prompt so if you have a lot of values in table prompt, it will also throw error about too many values for table prompt.

Hope this helps, I stay away from table prompts and sections due to our high volume of data, I've also seen same behavior with OAC.

Best practice for our institution is to create a dashboard, with dashboard prompt (always using presentation variables) and analysis that responds to the prompt.  There are some really great videos on Youtube (search Arun OTBI, great content on dashboard building)

@Arun Raj Thank you!

-Rich