on 05-06-2011 9:00 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.