It's all about the answers!

Ask a question

DNG RPE Template to publish a view (filters + columns)?


Sean F (929) | asked Mar 18 '18, 12:40 p.m.
edited Mar 18 '18, 12:41 p.m.
I have seen various explanations and demos of exporting plain modules from DNG.
Is there a way to export a module view?
The view might contains a filter.
It might contain attribute columns etc.
I know filtering and columns can be done from first principles in the DNG template but just wondering if there is a way to leverage the already defined filters and columns from a DNG view without redefining them in RPE?
Thanks

Accepted answer


permanent link
Subramanya Prasad Pilar (4.6k15) | answered Mar 18 '18, 2:00 p.m.
edited Mar 18 '18, 2:14 p.m.

Yes. If you are using DNG 6.0.4 or later, you can execute external requests against module views and generate documents from RPE template that uses views data source schema.

You can add schema using https://server:port/rm/publish/views?metadata=schema and design the RPE template. You can also use printModuleBook.dta (shipped with DNG) to publish a view by configuring its "views" data source as follows (example URL from my DNG instance):
https://<myserver>:9443/rm/publish/views?moduleURI=_c5733113b7694e81b68d23bb6f43e8d0&viewURI=_8d5f8cPhEeejG9hgXvzkBg&projectURI=_iLyo8VcTEeeH6p0FXWH5Ig

Requests against DNG reporting service for "views" artifact format are supported under the following formats:
https://serverName:port/rm/publish/views?moduleURI=https://serverName:port/rm/resources/_YbK4wd6IEeaEaOW7hUvrNQ&viewURI=https://serverName:port/rm/views/_iRsR8d6IEeaEaOW7hUvrNQ&projectURI=serverName:port/rm/process/project-areas/_uxdv8N3FEeaRC8I0G_Qhlg

or

https://serverName:port/rm/publish/views?moduleURI=_YbK4wd6IEeaEaOW7hUvrNQ&viewURI=_iRsR8d6IEeaEaOW7hUvrNQ&projectURI=_uxdv8N3FEeaRC8I0G_Qhlg

Note: To be able to execute an external request against "views" artifact format, project area, module and view information is necessary and view and module must belong to the project area provided on the request. If one of these parameters (moduleURI, viewURI and projectURI) is missing or invalid, or module or view do not belong to the project area, then a bad request response will be provided.


Sean F selected this answer as the correct answer

Comments
Sean F commented Mar 18 '18, 2:19 p.m.
Thanks for the detailed response.
I will give those options a try.

2 other answers



permanent link
Sean F (1.3k241144) | answered Apr 11 '18, 11:47 a.m.
edited Apr 11 '18, 12:18 p.m.

OK so the DSX URI for the views datasource should be of the form

https://serverName:port/rm/publish/views?moduleURI=_YbK4wd6IEeaEaOW7hUvrNQ&viewURI=_iRsR8d6IEeaEaOW7hUvrNQ&projectURI=_uxdv8N3FEeaRC8I0G_Qhlg

with a view, module and project area URI all in agreement (i.e. the view must apply to the module and both must be in the project)

Here is the URI of my module

https://localhost:9443/rm/resources/_jvSfgSeqEeiIY4jSc2zQlg?oslc_config.context=https%3A%2F%2Flocalhost%3A9443%2Frm%2Fcm%2Fstream%2F_I3hlMCbhEeiejZ97BmNJiA

So I take the string _jvSfgSeqEeiIY4jSc2zQlg as the module ID (?)

Here is the URI of my view

https://localhost:9443/rm/web#action=com.ibm.rdm.web.pages.showArtifact&artifactURI=https%3A%2F%2Flocalhost%3A9443%2Frm%2Fresources%2F_jvSfgSeqEeiIY4jSc2zQlg&filterId=_hXYQMTzjEeialsG3CL8ZrQ&vvc.configuration=https%3A%2F%2Flocalhost%3A9443%2Frm%2Fcm%2Fstream%2F_I3hlMCbhEeiejZ97BmNJiA

So I take the string _hXYQMTzjEeialsG3CL8ZrQ (? from the filterId)

Then I just need the project URI

The project itself has the web browser URL:-

https://localhost:9443/rm/web#action=com.ibm.rdm.web.pages.showFoundationProjectDashboard&componentURI=https://localhost:9443/rm/rm-projects/_ILUmgCbhEeiejZ97BmNJiA/components/_I1u1cCbhEeiejZ97BmNJiA

Which I think gives a project URI of _ILUmgCbhEeiejZ97BmNJiA (?)

So I assemble my complete DSX URI as

https://localhost:9443/rm/publish/views?moduleURI=_jvSfgSeqEeiIY4jSc2zQlg&viewURI=_hXYQMTzjEeialsG3CL8ZrQ&projectURI=_ILUmgCbhEeiejZ97BmNJiA

But this gives

CRRPE1064I Error in engine
Auto: connection to https://localhost:9443/rm/publish/views?https://localhost:9443/rm/publish/views?moduleURI=_jvSfgSeqEeiIY4jSc2zQlg&viewURI=_hXYQMTzjEeialsG3CL8ZrQ&projectURI=_ILUmgCbhEeiejZ97BmNJiA failed. None of the known protocols succeeded.


Have I assembled my DSX URI incorrectly?


permanent link
PASQUET Nathan (111) | answered Jun 01 '18, 8:31 a.m.

hi there,

I succeed to insert a view using the ModuleView_Custom Template established by IBM by configuring the DSX file with the URI for view, module and project Area.
Sean, i did like you said for the module and view URI but i took the URI from the itemId part of the URL of my project after clicking on Manage this project Area : https://rm.almfr-bas.group.intra/rm/admin?displayBanner=true#action=com.ibm.team.process.editProjectArea&itemId=_DE6H4EcCEeivodO_0Cn9HQ.

Nevertheless, i have a problem with my dta file. Using the dta file given by the template, all works perfectly but if i try to configure the view as a data schema in a new .dta with the same URI used in the DSX, nothing appears in the data source view. That why i ask for some help, how should i configure my URI in my DTA to be able to use the informations and construc my canevas ?

Your answer


Register or to post your answer.