Best to prepare a security matrix document of roles that users who need access and users who don't need access. You would need to remove at least "Consumer roles" and then restrict access to the roles that should not see this report. Just remember, if the users who are supposed to access these reports also have same role…

If you are using MS Word to design template, you can double click on the Quantity Shipped and format the number.

Would you be able to share query or archived data model/report? Did you try the report generating using a wizard template?

Great, will ping you

Sorry bit busy with day job, will look into it later this week or weekend. would you find sharing your linkedin profile here, so I can pm you my contact details.

This is easy if you do in pivot table, two columns represent date from two different years. The last one is a calculated column. Just click on advanced tab and copy everything from XMLAnalysis window in a text file and share here.

Please share the entire report XML. I can give a try.

Aggregation will not work within filter, that's the simple rule. Try converting that as well to case statement. CASE WHEN count(distinct case when "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" = '2023' or "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" = '2024' THEN "Procurement -…

Did you check if the count is returning just one or 2s as well? Make sure your report run for both the years 2023 and 2024

Replied to your other post

Try this CASE WHEN count(distinct case when "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" = '2023' or "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" = '2024' THEN "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" END by "Procurement - Direct Material Spend"."Voucher…

@JobDeLuna Yes there is error in the syntax, please place END before BY. Something like this count(distinct case when "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" = '2023' or "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" = '2024' THEN "Procurement - Direct Material…

Something like this should work for you count (distinct CASE WHEN "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" =@{YEAR1} OR "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" =@{CURRENT_YEAR} = @{YEAR2) THEN "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" by…

@Nathan CCC I think the question is from catalog view, in the dashboard and page view it's possible as you highlighted. Its a wired requirement frankly, so just remove from catalog view but when report is run user should be able to download/print :)

In the Admin → manage privileges you can disable "Access to Export". Don't recall seeing similar option for Print though.

We had faced a similar issue in Taleo where the ID generated for DFFs in production were different to other env. Just remove the DFF from report and add it back in your migrated env from subject area.

Attaching the OTBI report XML that you can use.

Can't see any issue, are you getting any error?

I do not believe Oracle yet exposes subject area of report information in table. GL_FRC_REPORTS_B table gives you list of reports without subject area.