Hi - what is the end result you are expecting? To display what parameter was chosen or to filter your report to the parameter? 

I cannot wait to explore this more - thank you so much!

Rob - did you ever get an answer about this? I feel like the solution has to do with choosing the 0 GMT (London) vs the 0 UTC, but am not 100% certain.

Unfortunately not. We moved forward with BIP Summary/Detail instead, which is not ideal as the charting options within OTBI are significantly better.

Hi - I am not sure if this is possible, I feel like we've asked for it previously and don't know that I've seen it available. I know that at one time, I was able to get a historical run report from Oracle, showing me how many times a report was run, but I think that was only Taleo OBI and not Fusion OBI ... Good idea for…

Joel - how do you get Catalog Manager? I am a BI Administrator, but we do BI in the Cloud so am not sure if this is something we can still use? I couldn't find anywhere about downloading it, and have read through quite a bit of the pages, but am clearly missing it.

Thank you - this is something I didn't think of and is really the easiest solution! Appreciate it.

I am not aware of a way to do this, but I know that through BI Publisher, you can schedule a report to run and then send the user a link to the report when it's complete. This will eliminate the attachment and require users to sign in to pull the data. If this can be done via OTBI/Agents, I too would love to know how to do…

Nice! Well then mark your solution as the solution so future users know how you fixed it :)

You do not always need the ELSE on there, in this statement it would just return a blank cell. If you want it to return something for it being the same, you would do something like this: CASE WHEN "FIELD1" > "FIELD2" THEN "FIELD1" WHEN "FIELD2" > "FIELD1" THEN "FIELD2" ELSE 'SAME' END When I tested this, it errored because…

OK, try this then: CASE WHEN "FIELD1" > "FIELD2" THEN "FIELD1" WHEN "FIELD2" > "FIELD1" THEN "FIELD2" END

Hi - assuming that the two dates are the same field, then you would do MAX("FIELD").

This is an amazing explanation and I fully understand now why can you? yes ... should you? no! Thank you!

Christian - thank you! So I am intrigued by your response. It is possible, but you recommend not to do it because it's a waste of time? I did find information about moving the print options, but nothing about the export options, and using Java script, which I am not interested in maintaining.

Srinivas - please try this formula: FLOOR((TIMESTAMPDIFF(SQL_TSI_DAY, "Person"."Person Date Of Birth", CURRENT_DATE))/365.25) I could not get anything else to work, but this one seems to do it. It's interesting that Oracle's recommendation is just TIMESTAMPDIFF(SQL_TSI_DAY, "Person"."Person Date Of Birth", CURRENT_DATE) as…

Hi Christian, I did a little digging and it appears we are using the field DURATION from the ANC_PER_ABS_ENTRIES table. It appears it is set as a number field. What you have is correct: YES - 1 and .015 NO - 1.000 and .015 NO - 1 and 0 (this would be the rounding of the .015) I need to add these together to find total…

Thank you Aravind! I'll wait to hear more from you. I did look at the link you provided, and think I understand if I have the parameter in the OTBI report called "businessunit" then I just need to do the same in the BI report, but how do I ensure it passes what was selected from the OTBI report and not hard coded?

Stefan - from my previous posting: Results tab/View Layout: Hidden here hides from Excel Criteria tab/Column Properties/Column Format tab: Hidden here hides from CSV AND from the Results tab View So yes, the screenshot you have included is the second option and hiding it there hides it from the CSV AND the Results tab…

Stefan - not sure I understand ... if you hide the measures on the Criteria tab, it will still run, it's just hidden from view. I have tested this and it is working for me (hidden field not showing on CSV output), so unsure if I am misunderstanding what you are trying to do?

Hi Stefan - it's my understanding that you can hide columns in two places. Results tab/View Layout: Hidden here hides from Excel Criteria tab/Column Properties/Column Format tab: Hidden here hides from CSV AND from the Results tab View I hope that helps!