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
Skip to content
  • Register

    • Split Concatenation and SQL

    edited Oct 27, 2021 12:49PM in Planning 1 comment

    Summary:

    Split Concatenation and SQL

    Content (required):

    Am processing rows using concatenated values where each segment is separated by an underscore character (_) Ex: A23_B11011_C13432_DEF1232 and it works fine if I use <1>, <2>, <3>, <4> for each of the 4 dim.

    Source values can be A23_B11011_C13432_DEF1232, A23_B11012-C13432_NA_F1232 etc.. When it is A23_B11012-C13432_NA_F1232 where NA_F1232 is member name(default) of the 4th dimension(has a underscore in member name) and the <4> brings up only NA and not NA_F1232. Wherever I find members without underscore it needs to be loaded AS IS(DEF1232) and default to NA_F1232 otherwise

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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