Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi Arun, That looks identical to the SQL from the seeded report data model so I don't think it's from the package. What I'm trying to accomplish is there are three columns that report Overdue as 1-7 days, 8-14 days and 15+ days. I want to condense these into just one column of 7+ days. I'm sure there is another way to do…
-
Hi Arun, Yeah, I saw that and I'm not sure what to make of it. Thanks, Tim
-
Manoj, It's scheduled and delivered via email in html format.
-
Simplest way might be to add DISTINCT after the word select. So, Select distinct "PER_USERS"...
-
Hi Manoj, in the report header, not column header. Thanks!
-
Manoj, Do you know how I can capture this date (range) for display in the report output header? Thanks, Tim
-
Nicole, what worked for me was to add the string in the SQL Expression field and set Operator as "is greater than"
-
Thanks Manoj, using a filter on date with the SQL expression of TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE) nailed it.