Hi All. I havent found a solution for this. I am trying to filter results of a parent child hierarchy on a dashboard.

Thanks. So I am trying to run the report that is using this hierarchy on a dashboard. I want to be able to prompt the user to filter the report by the employee name. In the above example the user would select any employee from the prompt and the report would then filter the results by showing that employee and their direct…

Ok. Thanks for the assistance.

We renamed the .lck file in the MUD directory and this resolved the issue.

Thanks Sudipta. This solution worked for me.

Thanks Chris. Exactly what I needed and it worked!!!

Hello Pedro. Apologies for not including the version.It is OBIEE 12.2.1.0.0Is there a specific example for modifying XML in 12c as the tags being used seem to be different. I see the <saw:displayGrandTotals> tag.

Thanks Christian. The environment I'm in is somewhat finicky. This worked.

Hi Sherry, My apologies. You were actually right. You fix works in a pivot table. I tried it using a table. Thanks

I tried that but the cell values still appear.

Below is the solution that I used. There may be a more elegant way to do this. case when LENGTH("Table"."Column") = 8 then cast(SUBSTRING("Table"."Column" FROM 1 FOR 2) as INT) * 3600 + cast(SUBSTRING("Table"."Column" FROM 4 FOR 2) as INT) * 60 + cast(SUBSTRING("Table"."Column" FROM 7 FOR 2) as INT) when…

I ended up getting the length of the string when HH are 2 digit or 3 digit numbers and doing the conversion that way.

Hello Christian. Thank you for responding. I had thought of the the solution you offered but the requirement is unique in that the HH part might not always be a 2 digit number but sometimes is 3 digits Some of the data looks as follows: HH:MM:SS 07:00:12 98:21:00 101:05:11 112:13:15 The requirement also needs me to sort on…

Thanks Sherry & Gianni. I'll try your recommendations and see if that works for me.

Hello Sherry, I am creating a report that will show all the people in a company that have upcoming birthdays in the next 30 days. The idea was to get extract the month and the day from the birthday and then append the year with the current year. I could then do a comparison where MYDATE between CURRENT_DATE and…

Thanks Gianni. Your suggestion worked out great for me.

Thanks Gianni for your helpful answer.

Thanks Gianni for your super helpful answers. I'll look to leverage Smartview into my solution.

Sound advice. That make sense as I'm seeing on here a lot of posts where folks have tried to "wing it" and end up getting it wrong. Thanks for the advice.

Thanks for the information.