You looked at Historical Reported Time cards subject area? Think this will give you what you need

hi i can't comment on that specific use case, but i would say normally when combine Subject Areas, its to bring in Measures, not Dimensions. The Invoice Recieved Date dimension probably doesnt conform with the other ones from AP, hence why not getting the data. I think answer might be to have to create/amend the logicial…

Mark that URL to the documentation should help as it has examples of when stuff is purged… We've got the purge job running, but we dont have the requirement to look at old tasks, so i've not looked into this in great detail. Maybe someone else can help on here..

thats the reason then…its purging the data?

Have you got the schedule process "Archive and Purge Journey Data" running? https://docs.oracle.com/en/cloud/saas/human-resources/24d/faijh/examples-of-assigned-journeys-archive-and-purge.html#Example-1

Each time you create a new OTBI report you are starting with a blank canvas - that is the funcitonality of the product. If you always have say 5 fields in most reports - obviously you can always save this report as and use this has a "template" ie the starting position for new reports. For filters - If you are always…

Formula looks fine. Is your Legal Employer status definatley "A" ? Add it into the query so can see what values it contains. For me it is returning "Active" so this formula works for me case when "Legal Employer"."Status" = 'Active' then "Legal Employer"."Name" end

ah ok..apologies I’ve misunderstood then. So running simple hierarchy report returns correct results..if so then what is the scenario / query that isn’t working ?

Have you ran the Refresh hierarchy schedule process? Refresh Manager Hierarchy - Doc ID 2898242.1

See the Syntax error - you have a closing bracket but not an opening one

just add a max round your case statment max(case when "Person Phones"."Phone Type" = 'Home Phone' then "Person Phones"."Phone Number" end)

Or just a simple CASE statement Case when Legal Employee Active Status = 'Active' then Legal Employer name End

You don't need to use "is prompted": Create a filter on the required column > Add more options > select presentation variable and enter the name of the variable. So if your filtering on say a Year column and your pres variable is called "Var_year", then your filter will then look like: Year is equal to / is in @{Var_year}

If you look at the SQL that has been generated when you've ran the report .. if this shows "and 1=2"…. then this means you don't have a role that grants access. If you have the required role, you will see "and 1=1"

You could use a subquery within otbi ie "results based upon another analysis ie the subquery returns a list of managers, then the main query gets the term date details for these people. select worker number, term date where worker number in (select manager number…..)

Another option is you can use usage tracking ie "OTBI Usage Real time" subject area which will return the Logical SQL which will then tell you the filters used in the reports that have been run.

we need this functionality too - to remove need to update URLs for every POD refresh. enhancement request "SR 3-31263643601" doesn't seem to be publicly visible

Can't see this link : https://community.oracle.com/customerconnect/discussion/525699/repository-session-variable-with-hostname-for-drill-down Get :Permission Problem

Agreed - not a good user experience. We've just gone live with Payroll, so only a hand full of subject areas are relevant but have to search through a long list.- I've been going to Manage privileges and changing the permissions to "deny" . Bit of a painful task but this works. However, gets reset when next patch is applied