AdminTool unable to create dimension

choracy69

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)

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

Any suggestions?

cesar.advincula.o

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

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:

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

choracy69

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:

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:

Andrew Fomin.

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

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)

Fact(2)

OPERATION SEQ NUM:

Hierarchy:

Andrew Fomin.

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

choracy69

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.

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

Hi Andrew,

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

choracy69

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