Hi, @Gianni Ceresa, @Christian Berg Support had notified me that there is a bug during this particular step (RPD upgrade) in the 10.1 -> 10.2 upgrade. They are researching further ... possibly looking for a patch. Thanks for the help thus far! I'll circle back with updates ... Charles

Ahh, ok. I do not have any of those. I only have the grand total for each of them, respectively. Maybe we can trade RPDs (jk).

Hi Gianni, Thanks. But, I can see that both dimensions only have 1 level (grand total level). I don't see any other levels, columns. Regards, Charles

Ok, thanks. But, (warning: dumb question ) how do we know which column(s) to put in the dimension? The error only states that it isn't associated with any tables. It doesn't mention any columns specifically. Regards, Charles

Thanks Christian. Is that a "drag & drop"? I'm trying to find the instructions for it ... Charles

Ok, I see. You are correct, I was looking in the physical layer. I can see these objects in the BMM

Thanks Gianni. Hmm ... I am not seeing them: Bi Apps strikes again! I'm forseeing another SR in my future ...

Also, found these:

Sorry. Good catch ...

Hi Gianni, No worries .. we made some progress! I'll circle-back here, when/if this gets resolved Regards, Chalres

Have you checked into data lineage? https://docs.oracle.com/middleware/11119/odi/develop-connectivity-km/biee_lineage.htm#ODIKM1496

Hi Gianni, Avanish, Thanks for the help thus far. I'm going to open an SR with the Bi Apps team to further troubleshoot. Regards, Charles

I see it now:

Hi Gianni, As Avinash said, you need to check if you have data for the previous year for the "Spend" column as the formula of "Spend Year Ago" uses the AGO function. Possibly I have missed this. But, where are you guys seeing the 'AGO' function? Regards, Charles

Hi Avinash, Thanks for the suggestion. I am able to see spend data for previous years, using the Spend & Year columns Regards, Charles

Hi Avinash, We should have the data there. Initial Extract Date for the ETL started in the end of 2016. Regards, Charles

Hi Gianni, I was able to disable the cache, and get the physical query WITH SAWITH0 AS (select sum(case when T2553670.W_STATUS_CODE = 'APPROVED' and T2553644.INTEGRATION_ID <> '0' then T2535762.INV_DIST_AMT else 0 end ) as c1, case when T2565464.ROW_WID = 0 then NULL else T2565464.DAY_DT end as c2, T2534878.NAME as c3,…

... probably should've included this too: sum(case when Dim_W_STATUS_D_AP_Invoice_Approval_Status.W_STATUS_CODE = 'APPROVED' and Dim_W_XACT_TYPE_D_AP_Spend_Classification.INTEGRATION_ID <> '0' then indexcol( case VALUEOF(NQ_SESSION.PREFERRED_CURRENCY) when 'Document Currency' then 0 when 'Local Currency' then 1 when…

Hi Gianni, Looks like we are getting a cache hit on this. Here is the logical query: SELECT 0 s_0, "Procurement and Spend - Invoice Lines"."Invoice Details"."Invoice Receipt Date" s_1, "Procurement and Spend - Invoice Lines"."Supplier"."Supplier Name" s_2, MONTH("Procurement and Spend - Invoice Lines"."Invoice…

Well ... more questions than answers Yes ... that's ok, we are only at the beginning . I will find these answers out for you (was checking to make sure there was data coming over from the ETL first; it looks like it, so we can focus on the warehouse side of things now). Thank you, I will get back on these ...