Skip to Content
author's profile photo Former Member
Former Member

Universe Dimensions/Measures from Progress Array

Hello,

I have a Progress (Openedge 10.2) array that has 24 columns separated by semi colons (";") and I am trying to create single measures for each (as they related to period data)

1;2;3;4;5;6;7....24;

I am used to the split function in Crystal, but am struggling to find the equivalent in BO Designer?

What is the equivalent of the split function in BO?

Many thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 10, 2011 at 09:09 AM

    HI,

    I have created unverses based on Progress database 3 years back.

    We can do that. But I don't remember how I have done that. But its possible.

    Did you try Substr and pos functions?

    Regards

    Gowtham

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 09, 2011 at 11:47 AM

    Eesh, good luck with progress arrays.

    From a performance point of view, I'd recommend parsing the data out into a separate reporting table if that is at all possible. You may hit problems otherwise - I've seen arrays with different meanings cause problems when someone adds a new type. For example field 6 for one type is a date field while for the new type it is a number.

    If you're going to persist with working with the arrays in Designer, then you'll need to use Progress-specific SQL functions to do the manipulations and it will get messy quickly. Maybe something like this link will help? http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97682

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.