url manipulation based on REST on Rational Publishing Engine
Hello all,
I'm totally new on RPE and many questions are coming in my head. I notice that RPE is not a BI reporting tool but we can use it the same way only having to take advantage of its properties.
I have to create a report to count applications accross all projects. I'm using REST connection as I'm getting data from ReqPro. My datasource is a xml-url (You might know this!!! :p).
Anyway, to get the applications (attribute) I have to go into http:///RequisitePro/ProjectA/Requirements/ path and there are many requirements types there. Like AD, HLD, MD, AC and so many others. From project A to Project B can exist different requirements types which makes my work more difficult.
To get the requirements types attributes I need to go into a requirement type, for example AD. So, my url changes to http:///RequisitePro/ProjectA/Requirements/AD. In this case I can see the application on each requirement on AD type. And so many other attributes, of course.
Until here I could do and the report is beautiful. Problem comes now:
I have to count the applications accross ALL requirements types in all projects. So, connecting though REST on a specific requirement type works just fine. How can I connect on all requirements types?
I tried so many things that I can't remember now but one of them was:
Getting the requirement type using the attribute name on this level (http:///RequisitePro/ProjectA/Requirements/) and store it on a variable. Connect to the datasource using the url + variable information. The result would be (http:///RequisitePro/ProjectA/Requirements/AD). Well , it worked. But how can I specify the field (attribute) I want to use? The field is the only thing not working. Because I cannot get the field Application from the first url as you can only find this attribute on the second url. I'm saying this because there shoud exist a connection somehow and the first one is it. I cannot use the second because it's going to be for a specific one I have to get ALL.
If this is impossible to do: Is there a way I can run a java program on RPE to load this data and use it to display on the report? My idea was to create a java program to summarize this data. So, when I run the RPE report, this program would be the first thing to run and then the report would get this data already summarized to display on the report. Does any one know how to do that?
I couldn't think on a third option as I'm not much familiar with RPE but they are always welcome.
If any one could give a feedback it would be much appreciated.
Thank you in advance! :D
I'm totally new on RPE and many questions are coming in my head. I notice that RPE is not a BI reporting tool but we can use it the same way only having to take advantage of its properties.
I have to create a report to count applications accross all projects. I'm using REST connection as I'm getting data from ReqPro. My datasource is a xml-url (You might know this!!! :p).
Anyway, to get the applications (attribute) I have to go into http:///RequisitePro/ProjectA/Requirements/ path and there are many requirements types there. Like AD, HLD, MD, AC and so many others. From project A to Project B can exist different requirements types which makes my work more difficult.
To get the requirements types attributes I need to go into a requirement type, for example AD. So, my url changes to http:///RequisitePro/ProjectA/Requirements/AD. In this case I can see the application on each requirement on AD type. And so many other attributes, of course.
Until here I could do and the report is beautiful. Problem comes now:
I have to count the applications accross ALL requirements types in all projects. So, connecting though REST on a specific requirement type works just fine. How can I connect on all requirements types?
I tried so many things that I can't remember now but one of them was:
Getting the requirement type using the attribute name on this level (http:///RequisitePro/ProjectA/Requirements/) and store it on a variable. Connect to the datasource using the url + variable information. The result would be (http:///RequisitePro/ProjectA/Requirements/AD). Well , it worked. But how can I specify the field (attribute) I want to use? The field is the only thing not working. Because I cannot get the field Application from the first url as you can only find this attribute on the second url. I'm saying this because there shoud exist a connection somehow and the first one is it. I cannot use the second because it's going to be for a specific one I have to get ALL.
If this is impossible to do: Is there a way I can run a java program on RPE to load this data and use it to display on the report? My idea was to create a java program to summarize this data. So, when I run the RPE report, this program would be the first thing to run and then the report would get this data already summarized to display on the report. Does any one know how to do that?
I couldn't think on a third option as I'm not much familiar with RPE but they are always welcome.
If any one could give a feedback it would be much appreciated.
Thank you in advance! :D
7 answers
Thanks chaoz! :D
1) Just three is enough to have an idea. The list has more than 20. The url is http:///RequisitePro/ProjectA/Requirements/
<?xml version="1.0" encoding="UTF-8" ?>
- <Project Version="1.0.0">
- <Requirements>
<RequirementsCollection href="http://gaalpa1bpmeia02.itservices.sbc.com:9080/DataServices/RequisitePro/31210-185414c/Requirements/AD" />
<RequirementsCollection href="http://gaalpa1bpmeia02.itservices.sbc.com:9080/DataServices/RequisitePro/31210-185414c/Requirements/ADE" /> <RequirementsCollection href="http://gaalpa1bpmeia02.itservices.sbc.com:9080/DataServices/RequisitePro/31210-185414c/Requirements/AI" />
</Requirements>
</Project>
2)There are many attributes for this url now. I'll just add a few including the application attribute. The url is http:///RequisitePro/ProjectA/Requirements/AD
<?xml version="1.0" encoding="UTF-8" ?>
- <Project Version="1.0.0">
- <Requirements>
- <ADRequirement
href="http://gaalpa1bpmeia02.itservices.sbc.com:9080/DataServices/RequisitePro/31210-185414c/Requirements/AD">
<HasParent>false</HasParent>
<HasChildren>false</HasChildren>
<DocPosn>1</DocPosn>
<BookMark>REQBD4LM1</BookMark>
<TagNumber>1</TagNumber>
<TagPrefix>AD</TagPrefix>
<Level>0</Level>
<GUID>{7B38779E-0BDA-4DA2-9984-4FD97FBF5BA7}</GUID>
<UniqueID>12180</UniqueID>
<HasTracesFrom>false</HasTracesFrom>
<HasTracesTo>true</HasTracesTo>
<Application>GCP</Application><CR_ />
<Dev.Impact>Yes - Code Impact</Dev.Impact>
<ProjectID>Contact Helpdesk to setup values</ProjectID>
<Doc.Version>1.00</Doc.Version>
<Notes />
<Priority>Medium</Priority>
</ADRequirement>
</Requirements>
</Project>
3) It can be found on number 2 as it uses the same url. The attribute is below.
<Application>GCP</Application>
Thanks again!
Rafael ;)
1) Just three is enough to have an idea. The list has more than 20. The url is http:///RequisitePro/ProjectA/Requirements/
<?xml version="1.0" encoding="UTF-8" ?>
- <Project Version="1.0.0">
- <Requirements>
<RequirementsCollection href="http://gaalpa1bpmeia02.itservices.sbc.com:9080/DataServices/RequisitePro/31210-185414c/Requirements/AD" />
<RequirementsCollection href="http://gaalpa1bpmeia02.itservices.sbc.com:9080/DataServices/RequisitePro/31210-185414c/Requirements/ADE" /> <RequirementsCollection href="http://gaalpa1bpmeia02.itservices.sbc.com:9080/DataServices/RequisitePro/31210-185414c/Requirements/AI" />
</Requirements>
</Project>
2)There are many attributes for this url now. I'll just add a few including the application attribute. The url is http:///RequisitePro/ProjectA/Requirements/AD
<?xml version="1.0" encoding="UTF-8" ?>
- <Project Version="1.0.0">
- <Requirements>
- <ADRequirement
href="http://gaalpa1bpmeia02.itservices.sbc.com:9080/DataServices/RequisitePro/31210-185414c/Requirements/AD">
<HasParent>false</HasParent>
<HasChildren>false</HasChildren>
<DocPosn>1</DocPosn>
<BookMark>REQBD4LM1</BookMark>
<TagNumber>1</TagNumber>
<TagPrefix>AD</TagPrefix>
<Level>0</Level>
<GUID>{7B38779E-0BDA-4DA2-9984-4FD97FBF5BA7}</GUID>
<UniqueID>12180</UniqueID>
<HasTracesFrom>false</HasTracesFrom>
<HasTracesTo>true</HasTracesTo>
<Application>GCP</Application><CR_ />
<Dev.Impact>Yes - Code Impact</Dev.Impact>
<ProjectID>Contact Helpdesk to setup values</ProjectID>
<Doc.Version>1.00</Doc.Version>
<Notes />
<Priority>Medium</Priority>
</ADRequirement>
</Requirements>
</Project>
3) It can be found on number 2 as it uses the same url. The attribute is below.
<Application>GCP</Application>
Thanks again!
Rafael ;)
Hello all,
Well, I see that the topic I created seems difficult or perhaps impossible to be done so I'd like to know another thing stead.
I need to summarize that data I mentioned on the topic, eventhough the tool is not made for that. Is there a way I can have a java program running on RPE? For example, I'd like to have the data manipulated by the java program. Then, I'd use that data already manipulated on the report. Basically, it would happen in the following order:
1- Click the run button;
2- Java program summarizes the data;
3- RPE gets that data from Java,
4- Display the result.
Is it even possible?
Thanks again in advance.
Rafael ;)
Well, I see that the topic I created seems difficult or perhaps impossible to be done so I'd like to know another thing stead.
I need to summarize that data I mentioned on the topic, eventhough the tool is not made for that. Is there a way I can have a java program running on RPE? For example, I'd like to have the data manipulated by the java program. Then, I'd use that data already manipulated on the report. Basically, it would happen in the following order:
1- Click the run button;
2- Java program summarizes the data;
3- RPE gets that data from Java,
4- Display the result.
Is it even possible?
Thanks again in advance.
Rafael ;)
Thanks chaoz! :D<CR_>
1) Just three is enough to have an idea. The list has more than 20. The url is http:///RequisitePro/ProjectA/Requirements/
<xml>
- <Project>
- <Requirements>
<RequirementsCollection>
<RequirementsCollection> <RequirementsCollection>
</Requirements>
</Project>
2)There are many attributes for this url now. I'll just add a few including the application attribute. The url is http:///RequisitePro/ProjectA/Requirements/AD
<xml>
- <Project>
- <Requirements>
- <ADRequirement>
<HasParent>false</HasParent>
<HasChildren>false</HasChildren>
<DocPosn>1</DocPosn>
<BookMark>REQBD4LM1</BookMark>
<TagNumber>1</TagNumber>
<TagPrefix>AD</TagPrefix>
<Level>0</Level>
<GUID>{7B38779E-0BDA-4DA2-9984-4FD97FBF5BA7}</GUID>
<UniqueID>12180</UniqueID>
<HasTracesFrom>false</HasTracesFrom>
<HasTracesTo>true</HasTracesTo>
<Application>GCP</Application>
<Dev>Yes - Code Impact</Dev>
<ProjectID>Contact Helpdesk to setup values</ProjectID>
<Doc>1.00</Doc>
<Notes>
<Priority>Medium</Priority>
</ADRequirement>
</Requirements>
</Project>
3) It can be found on number 2 as it uses the same url. The attribute is below.
<Application>GCP</Application>
Thanks again!
Rafael ;)
Hi:
Sorry for reply to you so late!
From your descriptions, I think:
1) We can not support list all requirements and theirs basic attributes in single URL. But I got a good news, we will add this feature in our future release, the detail plan has not been made.
2) Currently, Your steps are right. You can do like that. But for the second step, I can give you a comment to make it simple.
As your need, You only want to check out <Application> attribute. so you can write a url like this: http://gaalpa1bpmeia02.itservices.sbc.com:9080/DataServices/RequisitePro/31210-185414c/Requirements/AD?fields=Project/Requirements/ADRequirement/Application .This URL will only list <Applicaton> of every AD type requirement. If you want to list more attributes and it is in same level in XML hierarchy, the format should be (attribute1|attribute2), For example, we want to checkout <BookMark>, <TagNumber> and <Application> attributes, the URL can be: http://gaalpa1bpmeia02.itservices.sbc.com:9080/DataServices/RequisitePro/31210-185414c/Requirements/AD?fields=Project/Requirements/ADRequirement/(BookMark|TagNumber|Application)
Hope this can help you!
Thanks a lot!
Thank you so much chaozh. I didn't know that. It will help me for further tasks. Any way, I'm glad to know the requirement basic attributes are going to change. It will probably help a lot.
Do you mind if I ask another question? I looked everywhere and I perhaps didn't understand it quite right. Dmoul told me to look at developerWorks but I'm kind of lost.
I need to summarize that data I mentioned on the topic, eventhough the tool is not made for that. So, I created a java program to do that and it worked. Now I need to have this java program running on RPE. Basically, it would happen in the following order:
1- Click the run button on RPE;
2- Java program summarizes the data; Done already!!! But it has to be executed by RPE.
3- RPE gets that data from Java or do I have to create another xml file to get the data on RPE?, * This is the step I'd need to learn. I have java knowledge.
4- Display the result on RPE.
Thank you again!
Do you mind if I ask another question? I looked everywhere and I perhaps didn't understand it quite right. Dmoul told me to look at developerWorks but I'm kind of lost.
I need to summarize that data I mentioned on the topic, eventhough the tool is not made for that. So, I created a java program to do that and it worked. Now I need to have this java program running on RPE. Basically, it would happen in the following order:
1- Click the run button on RPE;
2- Java program summarizes the data; Done already!!! But it has to be executed by RPE.
3- RPE gets that data from Java or do I have to create another xml file to get the data on RPE?, * This is the step I'd need to learn. I have java knowledge.
4- Display the result on RPE.
Thank you again!
Thank you so much chaozh. I didn't know that. It will help me for further tasks. Any way, I'm glad to know the requirement basic attributes are going to change. It will probably help a lot.
Do you mind if I ask another question? I looked everywhere and I perhaps didn't understand it quite right. Dmoul told me to look at developerWorks but I'm kind of lost.
I need to summarize that data I mentioned on the topic, eventhough the tool is not made for that. So, I created a java program to do that and it worked. Now I need to have this java program running on RPE. Basically, it would happen in the following order:
1- Click the run button on RPE;
2- Java program summarizes the data; Done already!!! But it has to be executed by RPE.
3- RPE gets that data from Java or do I have to create another xml file to get the data on RPE?, * This is the step I'd need to learn. I have java knowledge.
4- Display the result on RPE.
Thank you again!
Hi Rafael,
Since you have the Java program completed already, you can use the preprocessing option available in RPE Launcher. Details here: http://publib.boulder.ibm.com/infocenter/rpehelp/v1r1m1/index.jsp?topic=/com.ibm.rational.pe.publishing.doc/topics/t_postprocessingofoutput.html.
Note that this requires RPE 1.1.2.
Regards / Horia