Question
Adqura
IN
Last activity: 22 Aug 2016 9:37 EDT
Can we use BIX(Business Intelligence Exchange) to get the data by joining from 2 DataTypes
Hi All,
We have a requirement where we want to Extract Data by joining 2 Datatypes tables. Below is the example that we are looking for.
We have a DataType Class A. We have 2 other classes B and C which are under A. This means B and C Data Type classes are inherited from A.
We want to write an BIX extract at class A level and want to get the values by Joining B and C classes with a condition.
Is this possible with BIX, if it is possible could you please guide me on how to achieve this.
Please let me know if you need any information.
Thanks and Regards,
Maruthi Naidu Kurupati.
***Updated by Moderator: Lochan. Removed user added Ask the Expert tag. Apologies for confusion, shouldn't have been an end-user option; updated Categories***
Adqura
IN
Hi Habeeb,
I dont see the tab called Pages&Classes while or after creation of BIX Extract class. Please find the screen shot for details.
Could you please let me know on how I can add them in BIX.
Thanks and Regards,
Maruthi Naidu Kurupati.
Pegasystems
IN
If you are using command line BIX, then -c option should get you data from child classes as well. Please refer to the BIX user guide on PDN.
Adqura
IN
Hi Ravi,
Thank you for your response. I require the values from Child classes based on filter condition, can I get this using BIX command line.
Als the BIX user guide says that
-C option Include children classes.
Use this parameter if an abstract class was specified in the Rule-Admin-Extract rule.
Here in my scenario my Parent class is not a Abstract class. Please advise me as soon as possible.
Thanks and Regards,
Maruthi Naidu Kurupati.
Pegasystems
IN
Hi Maruthi,
If all the child classes map to the same table, then you can use the -c option even when the current applies to class of the extract rule is not an abstract class. You can try with the Sample extract rule defined on PegaSample class and see that it can get records from the child classes like PegaSample-CustomerRequest and other classes using -c. To limit the child classes, you can add a filter condition of pxObjClass in the extract rule.
-Rajiv