OTBI condition not working

Nathan CCC

Hi, No. Technically yes you CAN use the given formula in the reported hours column "if reported hours exist show them but if not reported hours show string WO". So yes it is possible to satisfy the criteria using the case when statement on your fact measure. In the screen shot I showed above you see an example of an analysis using this query with outer join with a pivot table with your case statement in the reported hours column formula. Each line in the select is a column in your analysis. You can edit column formula to add formulas to the columns. So you can see the solution working in the analysis in that screen shot.

By default the star schemas in the subject areas answer the question "what did happen" (inner join).  To answer the question "what did not happen" you need to change your query to use outer joins.

Obviously in your current query with inner join no row exist on the wed therefore a case statement in a column formula on a row that does not exist will have no results. If you want a column formula you need a row with a null value to apply it to. Imagine your data was in a spreadsheet. And you want to put a formula on a column. If there is no row in your spreadsheet then nothing will happen.

User_RD03L

Hello Nathan, this is well noted.

Just wanted to check with you on the previous screenshot above,

Can you please send me a couple of screenshots on what's on the criteria and advanced tab?

Thank you!