Universe Dimensions/Measures from Progress Array

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

Thanks for the heads up.

Was beginning to wonder why none of my Progress clients were running with XIR2 or 3.....

Will see what I can put together and let you know of the results.