do you know if your instance is possibly being updated to the September 2024 update? It's worth checking if this might be what's causing this.

Will there be any details on the rollout dates? Is the rollout just OCPU based? My other question is this feature dependent on the September 2024 update?

if I understand correctly, your code populates the parameter. If so you need to check the Exclude option of your filter and then also add your parameter to the filter section of your visualisations. In the example above, I can set the value of the Exclude Year parameter and once it's added to the filter section of the…

I don't believe that those options can be controlled as far as I'm aware. Is there any particular reason why you intend to hide these options?

You'll need to resolve the timezone issue in your data source and probably it's best to do all manipulation of the date formatting in your database so that all you do in OAC is pull back the formatted date column directly from the database.

It might be worth checking the actual values in the data source to ensure they’re correct. EXTRACTDAY returns the timestamp for midnight on the day of the actual date time value. This might be a bit primitive but it should do the job: CAST(date_column AS date)

Could you elaborate a bit more on your requirement? Can you provide an example of what you're trying to achieve to direct the assistance that you may get on here?

It doesn't look like there is a control on the orientation of the markers. Have you tried other visualisation types? A stacked bar chart is one worth trying. It might also be worth posting this as an idea in the Ideas Lab.

This is probably the wrong forum for a P6 issue? It doesn't appear to be a Primavera Analytics as such but more of a P6 issue. You might get more help in the Primavera P6 forums

Not ideal but have you attempted to delete the entire join and recreate it with just the 10 joins that you require?

I see 2 options:

The default of 0 means that there is no limit on the number of recipients that you can send a delivers message to. If you change it to 150 then you can’t exceed 150 recipients in any delivers messages.

Do you have any proxy/VPN running? Switch them off and try the DVML installation again.

Have you done an rpd consistency check beforehand? Also, can you try running your command with a blank rpd?

In addition to the comments from @Gianni Ceresa & @Christian Berg-Oracle , try taking the double quotes off the Analysis type and adding the fields parameter: ./runcat.sh -cmd report -online http://obidev1:9502/analytics/saw.dll -credentials creds.txt -forceOutputFile output.lsql -folder "/shared/BI Internal/samplereport"…

Have you tried using the ADD_MONTHS function? ADD_MONTHS( date, n ) Where n is the number of moths you want to add. In this case, set that to -12 in order to go back 12 months. You can then do a BETWEEN filter of the 2 dates.

Is Report 2 a UNION as well similar to Report 1 but the only difference being that Report 2 has the more granular columns providing the detail?

Have you checked the physical SQL generated by the BI Server? Is that generating the correct BETWEEN clause?

Which browser are you using? Have you tried other browsers? OBIEE 11.1.1.9* is a very old version and is likely to have issues working with modern browsers.

As @Gianni Ceresa pointed out, there are a number of steps you need to go through to set up row level security on objects in the repository and your description/s only has some of those steps. Take a look at this document and confirm that you have followed all of the steps.