Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

What is the easiest way to present RRC attributes in a single row using Cognos Report Studio?

Questions
Tags
Users
Badges
Andrew Trobec
(497●13●144●139) Jul 30 '13, 4:16 a.m.
Hello,

I am working with RRC 4.0.0.1 and Insight 1.1.1 and I am using Cognos Report Studio 10 to create a custom report.  I have a requirement with a number of attributes associated to it.  In this example I have 2 strings and 6 enumerations.  Using a query I can extract the information that I need (nformation has been filtered for requirement 42):

Requirement 42 Attributes

What I would like to do is have all of this information on a single line where each set of columns is an attribute name and the corresponding value.  In BIRT reporting I used javascript to accomplish this with computed columns.  How is this possible with Insight and Cognos Report Studio?

A nudge in the right direction would really help me out!

Best regards,

Andrew

0 votes

2 answers
8,141 views
0 votes

Accepted answer

Permanent link
David Mehaffy
JAZZ DEVELOPER (901●2●33●38) Jul 30 '13, 10:59 a.m.
Hi Andrew

I have run into the same thing throughout Insight data model.  The only way I know of is to join the things together - we created a view in Framework manager so we basically ended up with another data structure to get what we wanted - this is not ideal as it is fragile across upgrades, etc.  I wish the model supported multivalued fields out of the box.
Andrew Trobec selected this answer as the correct answer

1 vote

Comments
Andrew Trobec
Jul 30 '13, 11:57 a.m.
@dmehaffy Hello David, Thank you for your reply.  This seems like a better option than using a string of joined queries.  Is Framework Manager included with Insight?  I only have Business Insight, Query Studio, Report Studio, and Even Studio to work with.  Can I save a view using one of those or do I need new software? Regards, Andrew

David Mehaffy
JAZZ DEVELOPER Jul 30 '13, 12:15 p.m.
Hi Andrew Framework manager is part of Insight - it is in the DevTools package that you will need to install and modify the existing CLM FM model to do it. 

Andrew Trobec
Jul 30 '13, 12:43 p.m.
Thanks David, I'll take a look into that. Best regards, Andrew

One other answer

Permanent link
VK L
(817●7●157●159) Jul 30 '13, 6:11 a.m.
 Hi Andrew,
                    Looks to me that the source table that you are using is not the appropriate one as it looks to give all the values and not the actual one for the requirement id itself. Try to use the alternate ones and you can also use multiple queries and joins to land at the appropriate result?

Thanks.

1 vote

Comments
Andrew Trobec
Jul 30 '13, 8:12 a.m.
@valli Thank you for the reply.  The information that I added above was from one query extracting all attributes that I want for a requirement.  I want all of that information, but in a single line.  The brute force method is to add a string of joined queries which is a bit tedious, so I was wondering if there was any other way of processing the data.  For example, can I use scripting and write information into data structures like BIRT reporting?  I suppose the other option is to develop an ETL job that creates a view containing all the data.  Before going down that path, I was wondering what other options were available to me. Regards, Andrew

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jul 30 '13, 4:16 a.m.

Question was seen: 8,141 times

Last updated: Jul 30 '13, 12:43 p.m.

Confirmation Cancel Confirm