It's all about the answers!

Ask a question

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


Andrew Trobec (49712144139) | asked 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

Accepted answer


permanent link
David Mehaffy (90123238) | answered Jul 30 '13, 10:59 a.m.
JAZZ DEVELOPER
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

Comments
Andrew Trobec commented 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 commented Jul 30 '13, 12:15 p.m.
JAZZ DEVELOPER

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 commented 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 (8177154159) | answered 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.

Comments
Andrew Trobec commented 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 to post your answer.