You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Essbase Studio vs EIS - joining columns with different data types

edited Aug 2, 2018 2:36AM in Essbase 1 comment

Summary

Essbase Studio vs EIS - joining columns with different data types

Content

Hi!

we have some EIS Projects that we will migrate to Essbase Studio.

Some models failed in migrating and are now to be built manually. We now Experience (probably why the migration failed) that we are not able to join columns With different datatypes. In EIS this was not an issue.

For example in the fact table we have a column defined as CHAR3 that should be joined with a column in a dim table. In the dim table the colum is defined as VARCHAR20.

Is this how Essbase Studio Works or is there a setting allowing theese kind of joins?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!