Connecting CPQ with the CX Analytics in the FDI giving datatype issue while joining the OPTY Dim.

Question

I am bringing the CPQ data into the CX Analytics. In CPQ, we have two tables: Quote & Quote Line. We were unable to join these two tables in FDI semantic modeling. I created a view in the ADW by joining these two tables and performed semantic modeling on top of it.

Now I want to join this view with the Opportunity Dim in the semantic modelling using OPTY ID. When I am doing that, I am getting a data type issue.

OPTY ID in the View table is “NUMBER”, and the OPTY ID in the Opportunity Dim is "DOUBLE”, so it is giving me a Datatype issue.

When I typecast the column in the view table to “BINARY_DOUBLE” in ADW, and check that column in the FDI, it shows “VARCHAR” despite “BINARY_DOUBLE”.

Not sure why this is happening and how to resolve this issue.

Hitesh Patel-Oracle · Answer

Hi,

For this issue, could you please raise an SR?

There are more details that are needed on the release version, what SME (branch/sandbox) version are you using and some logs.

If you could raise an SR, the support team would be able to guide better.

Note:

I tried this scenario and below is the warning I see, but I can proceed ahead by saying Yes.

Hence, with your situation, our support team will have to look further.