OBIEE: Display values in prompt as per the given condition

Question

Hi,

My requirement is:

I have a Column say Debt in my table in DB. It contains 2 values: TECH DEBT and ARCH DEBT where Arch Debt is a subset of Tech Debt.

Suppose Tech Debt has 100 jira issues corresponding to it out of 15 issues are of Arch Debt. Then, in my DB Tech Debt displays 85 jira issues and Arch Debt displays 15 issues.

My requirement in OBIEE is to display 100 jira Issues corresponding to Tech Debt when Debt is prompted in the dashboard.

Currently, when Tech Debt is selected, sum of Arch Debt jira issues are removed which is wrong for me. I need to display the total count of jira issues when Tech Debt is selected from the prompt.

Can anyone please help me, how to achieve it in OBIEE?

Robert Angel · Answer

Not sure I understand your exact requirement but it sounds like you need to use some logic on the filter based on the value that is selected along the lines of; -

Db.Debt like '%'||case when '{ValueSelected}' = 'TECH DEBT' then 'DEBT'

when '{ValueSelected}' = 'ARCH DEBT' then 'DEBT' else {ValueSelected} end||'%'

Note you need to change Db.Debt to your column syntax and you need to populate a presentation variable called {ValueSelected} (you might want to call it something more useful!)

Amend the case statement as per your requirement, as I said I did not fully follow your requirement...