bjouzier
Member
Hello,
Does anyone know if it is possible to have a calculated retunred column in an Orchestrator DataRequest component ?
I want to create a data request that produce the equivalent of SQL Query below :
Select sum(SDSOQS+SDSOBK) from F4211 where sddcto= 'SE' and sdnxtr between 530 and 575 group by SDITM,SDMCU,SDPDDJ
Of course with data aggregation I can obtain a result set with two separate columns sum(SOQS) and sum(SOBK) and sum columns in subsequent components. I should have preferred to do it in the Data Request source component, to avoid making it in several subsequent components.
Is it a functionnality available, I didn't found it (I am in tools 9.2.6.3) ? Perhaps is it available in newer release ?
Does anyone know if it is possible to have a calculated retunred column in an Orchestrator DataRequest component ?
I want to create a data request that produce the equivalent of SQL Query below :
Select sum(SDSOQS+SDSOBK) from F4211 where sddcto= 'SE' and sdnxtr between 530 and 575 group by SDITM,SDMCU,SDPDDJ
Of course with data aggregation I can obtain a result set with two separate columns sum(SOQS) and sum(SOBK) and sum columns in subsequent components. I should have preferred to do it in the Data Request source component, to avoid making it in several subsequent components.
Is it a functionnality available, I didn't found it (I am in tools 9.2.6.3) ? Perhaps is it available in newer release ?