found a work around on this. thanks for your help

It says there is a syntax error

I dont have access to log file but i can look at SQL execution. what should i be looking at exactly on the SQL execution?

I have changed the order of the prompts so that each prompt filter filters data based on the filter above it, i have recreated the indexes for the columns and still having same issue.

I found a workaround for this issue, i had to create a logic in the warehouse to pick up the latest score and that seems to have worked. Thanks for your help.

yes, thats my question,

Not looking for a simplar way, just looking for a solution.

this is oracle OTBI cloud product -I don't have visibility of the rpd or the database that is kept by oracle , I only have access to subject areas. Given that I don't have the database access , how can I tell the grain of the data or even the attribute that is causing an issue.

thanks. I worked. I have a follow up question but will post it on a new thread.

thanks. I will keep that in mind when asking questions in the future

I am using 12C and its physical table in the physical layer. On the screenshot I shared with you, the columns option should have a drop down list with columns and checkboxes to select the column you would want to act as a primary key. I can see those columns in other fact tables and I just cant figure out why my particular…

Unfortunately its not working as expected, as when I use Archive date as a date filter, for say 02/01/2017 -02/28/2017 if the last time they had a a 1 is say 03/20/2016, that date is not being captured. any suggestions?

This seems closer but how did you create the rsum column? whats the formula?

What I need is on the Last Column date I should only see the first row date (8/9/2016)- Meaning that if I ran the report between from February 2, 2017 job application row count for top row will be zero but the Last Date will be 8/9/2016 since that was the last time they had a 1 outside of the date range

Yes, its not that simple. let me upload snipet of it with an explanation of what I want to see.

my requirement is to calculate the offers we extended to employees , basically if someone applied for a job in January and we extended an offer to them in February, my requirement is that when I create metric to show offers extended in January, I should show all offers even those extended in February

my requirement is to calculate the offers we extended to employees , basically if someone applied for a job in January and we extended an offer to them in February, my requirement is that when I create metric to show offers extended in January, I should show all offers even those extended in February

I wanted to be able group both min and max results set by "Details"."PNumb"). Does it make it any difference if I start with max ?

What do you mean by reversing my MIN/MAX?- I have made some corrections- changed the job name definitions. Would you be kind enough to show me how I can write it without getting an error? (MIN(CASE WHEN "Details"."PNumb" = "Details"."PI" THEN "XX"."Date" ELSE (CASE WHEN "Details"."PNumb" = "Details"."PI" AND "JOB"." Name"…

Can you explain in a step by step how you used the advanced tab to create partition?