hi friends virutosos , gurus and other ppl

I want to create a define field that contains data of four other fields. These four fields are hierarchy fields.
Top , Level1,Level2 and Bottom. These are 4 hierarchy fields and i want the data in these 4 fields to be contained in a virtual field.

Is this possible using Define Statement??

Thank you very much

As we have learned during summit: there isn't anything you can't do with webfocus!
Having said that, I do think some things are indeed if not hard to accomplish then maybe indeed not possible.
But I think in your scenario, the wish can be fulfilled.
You will have to be sure you acces that one hierarchy path though, otherwise focus will tell you that the data is on different data base paths.
If so, you can define a field that contains all needed fields in the hierarchy.
I take it you do not need to have an example?

That's not much information to go on, but the answer is probably yes. You can do a lot of things in DEFINE or COMPUTE statements.

As long as they are in the same hierarchy path, all available at the same time and you can convert them all to the same field type to do your concatentation in the define.

hi leah,

I am sorry that i dint explain my requirement. My requirement is not to concatenate the data in the 4 columns, but the data should come one after the other in the hierarchy format.

For eg -

strategy - top level
Sell1 - top level
Corporate - level 1
Source and place product - level 2
adjust inventory - sub - level

I want the data in this format. All the parent level data , then the level 1 data , level 2 data and finally sub-level data.

Arvind,

Could you be a bit more specific:
How is your hierarchy defined in the MASTER?
Do you want all the top levels together, then all the second levels and so on?
Are you looking for a summary report or a detailed report?

Could you repro using CAR?

hi danny ,

Sorry about that , i will describe you the structure of the master file.
Below is the master file description.

The fields TOP_BUS_CAPBL_N , LVL_1_BUS_CAPBL_N, LVL_2_BUS_CAPBL_N and sub_BUS_CAPBL_N ar hierarchy columns of business capability.

and the report shows the applications that are tied to a particular business capability irrespective of its depth in the hierarchy.

The hierarchy can go upto ten levels, it is unpredictable.
I apologise i cant give any example here to explain the situation .

Thank you very much danny

FILENAME=T_ORA_APPL_CAPBL_LFCY_V, SUFFIX=SQLORA , $
SEGMENT=T_ORA_APPL_CAPBL_LFCY_V, SEGTYPE=S0, $
FIELDNAME=TOP_BUS_CAPBL_I, ALIAS=TOP_BUS_CAPBL_I, USAGE=I8, ACTUAL=D8,
MISSING=ON, $
FIELDNAME=TOP_BUS_CAPBL_N, ALIAS=TOP_BUS_CAPBL_N, USAGE=A50, ACTUAL=A50,
MISSING=ON, $
FIELDNAME=LVL_1_BUS_CAPBL_I, ALIAS=LVL_1_BUS_CAPBL_I, USAGE=I8, ACTUAL=D8,
MISSING=ON, $
FIELDNAME=LVL_1_BUS_CAPBL_N, ALIAS=LVL_1_BUS_CAPBL_N, USAGE=A50, ACTUAL=A50,
MISSING=ON, $
FIELDNAME=LVL_2_BUS_CAPBL_I, ALIAS=LVL_2_BUS_CAPBL_I, USAGE=I8, ACTUAL=D8,
MISSING=ON, $
FIELDNAME=LVL_2_BUS_CAPBL_N, ALIAS=LVL_2_BUS_CAPBL_N, USAGE=A50, ACTUAL=A50,
MISSING=ON, $
FIELDNAME=SUB_BUS_CAPBL_I, ALIAS=SUB_BUS_CAPBL_I, USAGE=I8, ACTUAL=D8,
MISSING=ON, $
FIELDNAME=SUB_BUS_CAPBL_N, ALIAS=SUB_BUS_CAPBL_N, USAGE=A50, ACTUAL=A50,
MISSING=ON, $
FIELDNAME=APPL_LFCY, ALIAS=APPL_LFCY, USAGE=A50, ACTUAL=A50,
MISSING=ON, TITLE='Application Lifecycle',$
FIELDNAME=CNT_APPL_LFCY, ALIAS=CNT_APPL_LFCY, USAGE=I8, ACTUAL=D8,
MISSING=ON, $
FIELDNAME=DEV_OWN, ALIAS=DEV_OWN, USAGE=A50, ACTUAL=A50,
MISSING=ON, TITLE='Development Owner',$
FIELDNAME=APPL_ID, ALIAS=APPL_ID, USAGE=I8, ACTUAL=D8,
MISSING=ON, TITLE='Application ID',$
FIELDNAME=LNG_N, ALIAS=LNG_N, USAGE=A50, ACTUAL=A50,
MISSING=ON, TITLE='Application Long Name',$
FIELDNAME=APPL_DESC, ALIAS=APPL_DESC, USAGE=A512, ACTUAL=A512,
MISSING=ON, TITLE='Application Description',$
FIELDNAME=PRIM_BPO, ALIAS=PRIM_BPO, USAGE=A50, ACTUAL=A50,
MISSING=ON, TITLE='Primary BPO',$
FIELDNAME=OTHER_BPO, ALIAS=OTHER_BPO, USAGE=A1, ACTUAL=A1,
MISSING=ON, TITLE='Other BPO',$
FIELDNAME=APPL_TYPE, ALIAS=APPL_TYPE, USAGE=A50, ACTUAL=A50,
MISSING=ON, TITLE='Application Type',$
FIELDNAME=BUS_FNCT_ASSESS, ALIAS=BUS_FNCT_ASSESS, USAGE=A512, ACTUAL=A512,
MISSING=ON, TITLE='Business Functional Assessment',$
FIELDNAME=PLN_SUNSET_DT, ALIAS=PLN_SUNSET_DT, USAGE=MDYY, ACTUAL=DATE,
MISSING=ON, TITLE='Planned Sunset Date',$
FIELDNAME=PLN_RETIRE_DT, ALIAS=PLN_RETIRE_DT, USAGE=MDYY, ACTUAL=DATE,
MISSING=ON, TITLE='Planned Retired Date',$
FIELDNAME=ACTL_RETIRE_DT, ALIAS=ACTL_RETIRE_DT, USAGE=MDYY, ACTUAL=DATE,
MISSING=ON, TITLE='Actual Retired Date',$
FIELDNAME=CNT_OTHER_CAPBL, ALIAS=CNT_OTHER_CAPBL, USAGE=I8, ACTUAL=D8,
MISSING=ON, $
FIELDNAME=CNT_APPL_CAPBL, ALIAS=CNT_APPL_CAPBL, USAGE=I8, ACTUAL=D8,
MISSING=ON, $
FIELDNAME=OTHER_CAPBL, ALIAS=OTHER_CAPBL, USAGE=A72, ACTUAL=A72,
MISSING=ON, TITLE='Other Business Capabilities',$
FIELDNAME=HIER_PATH, ALIAS=HIER_PATH, USAGE=A4000, ACTUAL=A4000,
MISSING=ON, $

Arvind,

Let's see if I understand:
You want to show all values of TOP_BUS_CAPBL_N, then show all values of LVL_1_BUS_CAPBL_N, then show all values of LVL_2_BUS_CAPBL_N and finally show all values of SUB_BUS_CAPBL_N.

Second question: Is there also something you want to sum for each value of these fields.

hi danny ,

Thanks for the reply..i will tell u the complete situation.

We have provided the user two listboxes having values of LVL_1_bus_capbl_n and lvl_2_bus_capbl_n , based on the selection made by the user in the two listboxes.

The report should fetch the corresponding parent of LVL_1_bus_capvl_n and all the children of LVL_2_bus_capbl_n.

This view is used to display the application info in a business capability.

In the report , the business capability name comes in the sub-head. But, how to use this view when the data is coming from 4 columns in the view. I am not able to display the appropriate business capability from a particular column in the table in the sub-head.

We have to use cascading prompt for the two listboxes provided to the user.

Thanks danny

Arvind,
I suppose that there is a hierarchy in your table, meaning that for single values of LVL_1_bus_capbl_n and lvl_2_bus_capbl_n you get only one value of TOP_BUS_CAPBL_N and many of SUB_BUS_CAPBL_N.
If that is not the case, then I don't understand your hierarchy problem.
If it is, by screening on your 2 input values you should get your output. Just sort by TOP_BUS_CAPBL_N NOPRINT and stick the value in the SUBHEAD.

hi danny ,

I understand your solution thats what i have done.. I have inserted values in the sub-head one below the other and grouping wrt TOP_BUS_CAPBL_N.

But the requirement is there must be one business capability name in the sub-head . For eg -

If - Level 1 name is Source and place product , Its corresponding chidren are Negotiate and business partner in Level2

Then the output should be like

Subhead - business partner
Application Info

Sub-head - Negotiate
Application Info

Sub-head - Source and Place Product
Application Info

Note - Source and place product is from LVL_1_Bus_capbl_n and other two are from LVL_2 column.

I am not able to achieve this ..Please advice

Arvind,
Note that you are putting the Children above the Parent. Is that what you want? If so then we are talking about a SUBFOOT and not a SUBHEAD, right?
Also, from which fields do you take the "application info"?

hi danny ,

I am just talkin abt sub-heads here. In the subfoot , i will insert the counts of different applications in a business capability. These counts come from fields CNT_APPL_CAPBL , cnt_other_capbl.

In the previous post , i have arranged the business capability in aphabetical order.

I take application info from fields APPL_I , lng_n,appl_desc and other columns except the hierarchy columns.



Thank you for your replies danny .

Arvind,

So, you want to sum or print APPL_I, lng_n appl_desc for "business partner" first, then for "Negotiate" and then for "Source and Place Product".
Is that right?