Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
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