Discussion
Cognizant
IN
Last activity: 22 Mar 2015 11:25 EDT
Could not able to concatinate indexed properties in single Row using report rules
- We are using below report definition rule.
PxSkillName and pyWorkBasket are indexed properties. So used index join to call those two properties.
Refer below screen.
Once run the report result is coming below format.(Actual result)
USerID WorkBasket
10001 AbcWB
10001 DefWB
10001 GhiWB
10001 JklWB
But expected Result is:
UserID WorkBasket
10001 AbcWB| DefWB| GhiWB| JklWB
Please help to resloving this problem.
Pegasystems Inc.
US
This is expected behavior for a one to many join, just as it would be in standard SQL. I would suggest skipping the join and creating a text property “ConcatBaskets” and set it using a Data Transform as shown below:
Sincerely,
Cecil Howell, CSA | Senior Instructor | Pegasystems Inc.
Cognizant
IN
Hi Howec,
Thanks for your support.i have tried your approch and its working for me.This is Simplest approch for Concatenating ndexed property.
I am facing one more issue. Coudn't able to call unoptimized property in report defenition rule.
Please suggest me how to call. attaching screen shot.
We are using 6.2 SP1.
Thanks,
Sumanth
Pegasystems Inc.
US
Sumanth,
I am testing on 7.1 so this may not apply but that is the error I get if I forget to prefix the property name with a dot. If the property is not optimized I only get a warning, this may be new in 7, 6 may require the property to be optimized. All you need to do is in the application explorer right click on ConcatBaskets and choose the optimize for reporting option and walk through the wizard.
Cecil