Project and Portfolio Management Practitioners Forum
cancel

Data dependency between fields in Financial Summary User Data

SOLVED
Go to solution
Highlighted
Utkarsh_Mishra
Acclaimed Contributor.

Data dependency between fields in Financial Summary User Data

Hello Everyone,

 

I have a requirement to have field dependency between two fields in Financial Summary user data.

 

Currently such behaviour is there between Type: and Category: fields, for example if user select "Labor" then in Category field only "Labor category" is popoulated.

 

Here I want that such depedency between two fields in FS user data....

 

ex. if user select "Labor" then... "Sub-Category" (a field in User data)... must show only "Labor" sub-categories.

 

Is this feasible... I have tried all the approach but no success.... please suggest if anyone has implemented such requirement.

 

 

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
3 REPLIES
Kerim KILIC
Honored Contributor.

Re: Data dependency between fields in Financial Summary User Data

hi,

 

you can achieve it with validation data in the second user data field according to first user data.

in the validation you must set [BGT.UD.<token you set for first user data>]

i just test it now, it is working

 

select 1,1 from dual where '[BGT.UD.FSUD1]'='test'

 

regards

 

Utkarsh_Mishra
Acclaimed Contributor.

Re: Data dependency between fields in Financial Summary User Data

I am using select [BGT.UD.P_CAT], [BGT.UD.P_CAT] from dual for testing...

 

but in validation it is giving error that "Unable to resolve the token or One of the token is not parsable"...

 

One interesting thing I noticed that... in TOKEN window.. the Financial Actual Line user data is not shwoing up.... but for Benefits it is coming...

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Utkarsh_Mishra
Acclaimed Contributor.
Solution

Re: Data dependency between fields in Financial Summary User Data

This issue has been identify as defect... and below is the response from HP support team.

This has been recognized as a defect by R&D and submitted with id QCCR1L43668 BGT Tokens gets not resolved in Forecast Line User Data Field Validation

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)