Oracle Fusion CX Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion CX Analytics

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
21
Views
1
Comments
User_0A1PI
User_0A1PI Rank 1 - Community Starter
in Oracle Fusion CX Analytics

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.

Tagged:

Answers

  • Hitesh Patel-Oracle
    Hitesh Patel-Oracle Mod

    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.

    image.png