AdminTool unable to create dimension — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

AdminTool unable to create dimension

Received Response
31
Views
10
Comments
choracy69
choracy69 Rank 6 - Analytics Lead
edited Aug 13, 2024 6:16PM in Oracle Analytics Cloud and Server

Hi,

I have problem with my structure in RPD when I want to create Logical Dimension.

My structure:

Physical Layer:

I have to Fact Table: Fact_Hours_REQ (1) i Fact_Hours_MES (2). Both table have columns: SEQ_NUM, but in (1) is double and in (2) is varchar.

Logical Layer:

I want to create dimension from this two tables with one column: SEQ_NUM.

My dimension called: Dim_OPERATION_SEQ_NUM

And it joins to this two fact tables: Fact_Hours_REQ (1) i Fact_Hours_MES (2)

pastedImage_1.png

pastedImage_0.png

And when I want to create logical dimension I have error:

pastedImage_3.png

Any suggestions?

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Hello,

    Could cast the column join in varchar or number and to match again in the business model, and also try to create the dimension.

    Let me know your results.

    Kind Regards,

    Cesar

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Hi,

    Thanks for response.

    I tried cast VARCHAT to DOUBLE or DOUBLE to VARCHAR but I still have the same error.

    My example cast to double:

    pastedImage_0.png

    I add that dimension with one source (whichever table) working fine.

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    When I tried create Logical Dimension manual (without using: Create Logical Dimension/Dimension with Level-Based Hierarchy in rpd) -it's ok - I create logical dimension, but I got an error when creating analysis.

    When I using one column from dimension, two column from different fact it's ok. But When I add this column OPERARTION_SEQ_NUM i have this errror:


    pastedImage_1.png

    I would add that all connections are good because they only use this dimension causing confusion.


    Is it possible that if I use two different columns (facts) with two facts: Fact_Hours_REQ (1) and Fact_Hours_MES (2), and then I will add to this column dimension (who created from these two fact table) there is a problem with a difference types even if the cast will do the business layer?


    example:


    pastedImage_0.png

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead

    That is usual when a logical table has more than one LTS.

    Simply create an empty dimension manually, define levels, and drag&drop SEQ_NUM field to the detail level.

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Hi Andrew,

    I've tried both manually create the same dimension and the entire hierarchy, you use the cast () and all the time or you can not create a Logical Dimension or the creature it manually it throws this error.


    I have something like that:


    Fact(1)

    pastedImage_0.png

    Fact(2)

    pastedImage_2.png

    OPERATION SEQ NUM:

    pastedImage_3.png

    Hierarchy:

    pastedImage_4.png

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead

    According to your screenshot, you've managed to create a hierarchy. What error and where do you get in this case?

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    When I want to used option in rpd Create Logical Dimension -> Dimension with Level-Based Hierarchy a get this error: AdminTool is unable to create the structure for dimension.

    But I was able to finally make a hierarchy manually - screenshots above.

    However, when I start the analysis (as described above), it appears to me the error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 46008] Internal error: File server/Utility/Server/DataType/SUKeyCompare.cpp, line 965. (HY000)


    Just look at the posts above.

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead

    OK. A Typical cause of this error is the difference in data types of columns.

    On your screenshot  (3) I can see that both facts are mapped "AS IS". You are supposed to make them of the same data type. Either cast double to varchar or vice versa. Like it was on this screenshot

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Hi Andrew,

    I tried to apply the cast () both DOUBLE -> VARCHAR and VARCHAR -> DOUBLE but it did not work,I still have error.

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Ok, It turned out that in fact this is the error associated with the data type. Types have been changed in DATABASE on DOUBLE (both columns is DOUBLE) and it works fine.

    When I use cast() function in RPD i stll get error, change i database help.


    Thanks for help