Comments

  • Prudence Kruchten

    Karen - is this a security function that needs to be turned on?  I do not see an Audit Reports under Tools so am sure it's either hidden or security driven.

    Thank you!

  • Prudence Kruchten

    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 running agents is to include a generic mailbox as a recipient, so the email that is being sent to the user also sends to the mailbox so it's like a historical record but not 100%.

  • Prudence Kruchten

    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.

  • Prudence Kruchten

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

  • Prudence Kruchten

    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 this.

  • Prudence Kruchten

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

  • Prudence Kruchten

    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 FIELD1 and FIELD2 are dates ... so I had to use code like this:

    CASE
    WHEN "FIELD1" > "FIELD2" THEN 'Field 1 name'
    WHEN "FIELD2" > "FIELD1" THEN 'Field 2 name'
    ELSE 'SAME'
    END

    I am not sure how to combine the text/date fields for it to work.

  • Prudence Kruchten

    OK, try this then:

    CASE
    WHEN "FIELD1" > "FIELD2" THEN "FIELD1"
    WHEN "FIELD2" > "FIELD1" THEN "FIELD2"
    END

     

  • Prudence Kruchten

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

  • Prudence Kruchten

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

    Thank you!

  • Prudence Kruchten

    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.

  • Prudence Kruchten

    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 this will calculate with the rounding, yet I know that when we report birthdays, we report what has passed and thus someone would be 48 not 49 if they are 48.8 years old :)

    I'd be curious if others have formulas that work too?

  • Prudence Kruchten

    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 duration someone is out of the office.

    Thank you!

  • Prudence Kruchten

    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?

  • Prudence Kruchten

    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 view.  

    However I would recommend you follow a best practice of where to hide fields.  I always hide from the Criteria tab/Column Properties/Column Format tab if I don't want the field in the report because inevitably it turns into a CSV output.  Also, if I know that I always do it there, then I don't have to remember to check both places :)