In that case there isn't much control that you'd have over this as this is all rendered in HTML by OBIEE and it's dependent on so many variables including screen size, font size, screen resolution etc @Christian Berg recently held an ODTUG webinar in which one point he raised in his presentation was pushing back on User…

Didn't realise that you were on 11g. 11g Log files Very strange that you don't have any jobs in your Job Manager. Also, you said "Okay So I checked all these and I could not find the information what I am looking ." what exactly did you find?

absolutely none at all! I just got an email notification of the OP's issue and replied to that without looking at the entire thread. If anything, it reaffirms the answer that you originally provided.

Hi @chillychin You need to select something like this to get detail of the "child" in your report. In screenshot below, you'll get Folder, Name & path of Dashboard and also Name & Path of the Analysis on these dashboards.

OK, could you check the query log files (<obiee_home>/user_projects/domains/bi/servers/obis1/logs) to see what physical SQL is being generated? Did you check the filters of the P6A sample earned value reports?

this sounds like there might be an issue with the scheduler metadata. Check the Scheduler tables (S_NQ_JOB, S_NQ_INSTANCE, S_NQ_JOB_PARAM) in the RCU schema to ensure that everything is set up correctly in the backend.

Check the Certification Matrix to see if the product is supported and whether the versions of the software are also supported

You don't really need to use this New Analysis on the Advanced tab. It looks like you have special characters in your column names (which shouldn't be a problem by the way). If I may ask, why are you using the New Analysis button on the Advanced tab?

Have you checked the filtering of the P6A sample reports? In the past, there was a lot of hardcoding on the sample dashboard reports. I suggest that you check the filters and screenshots are really useful as well.

In addition to all other suggestions, can you tnsping the Oracle DB from the OBIEE server? Can you connect if you modify your data source in connection pool to (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=HOST_NAME)(PORT=PORT_NUMBER)))(CONNECT_DATA=(SID=SID))) This will test that you can connect from the OBIEE…

You'll need to refer to the Oracle documentation and use that to plan your strategy. No 2 environments are the same so no migration is exactly the same either. The documentation that Oracle provide is quite helpful and useful to assist you in planning your migration.

Hi @1092369 If this is answered, mark the correct answer to ensure that your thread closes and that others who may have this issue in the future can find this thread.

Adding to @Thomas Dodds, if you're after a like for like display of reports in your PDF and dashboard then you should consider using BI Publisher.

Have you checked the scheduler log files? <OBIEE_HOME>/user_projects/domains/bi/servers/obisch1/logs There are also the scheduler DB tables in the RCU schema - S_NQ_SCHED, S_NQ_JOBS,S_NQ_JOB_PARAM, S_NQ_INSTANCE Thirdly, you can look at the Job Manager client tool

what about using the briefing book with a PDF format? Would that work?

Agents only allow Dashboard Pages to be included as the delivery content: A primitive means of achieving this would be to create a briefing book and add all the content of your dashboard into it and that can be delivered via your agent as either HTML or PDF but it looses the dashboard formatting though. Edit Didn't read…

cast(year(current_date) as char(4))||' - ' ||CASE WHEN LENGTH(cast(week_of_year(current_date) as char)) =1 THEN '0'||cast(week_of_year(current_date) as char(1)) ELSE cast(week_of_year(current_date) as char(2)) END If correct, mark the answer as correct for other users of the forum.

cast(year(current_date) as char(4))||' - ' ||cast(week_of_year(current_date) as char(2)) replace current_date with your date column

Agree with @Martin van Donselaar alternatively, you could derive this directly from the start timestamp and end timestamp and use the TIMESTAMPDIFF function to derive the time difference and format that using a duration format mask like: [duration(sec)] hh:mm:ss

@Gianni Ceresa wrote a blog about this some time ago.