Skip to main content
S
srector1-Visitor
1-Visitor
December 4, 2012
Question

Effectivity Report

  • December 4, 2012
  • 1 reply
  • 1382 views

I am trying to put together a report listing parts and their corresponding effectivities (including context part and context name).


I figured out how torelate the subject part to it's effectivity 'context part', but I can't seem to figure out how to relate the 'context part' to a product name.


There appear to be effectivity context objects available, but when I try to use them I get a message that they aren't 'concrete' (I believe this means they are abstract?).


If anyone has any suggestions, or an example they would be willing to share, I'd be most appreciative.


Thanks,


Steve

1 reply

S
srector1-VisitorAuthor
1-Visitor
December 5, 2012

So, after much gnashing of teeth, and many, many iterations, I think I have figured out “A” solution. It may not be the best approach, but I think it will meet our needs.


I have included a copy of the Report Manager query for anyone who might be interested. I plan to integrate this query into an existing Cognos report that we use to document released Change Notices.


This query is less a finished report and more of a proof of concept, so it is missing all of the niceties like Conditionals to search by Part Number or by Product. However, these could certainly be added if someone had a mind to.


If anyone has any questions or suggestions on how to improve the query, I would certainly appreciate your comments.


Steve

C
cmckenna1-Visitor
1-Visitor
February 11, 2016

Hi Steve, were you ever able to integrate this into your Cognos report on released Change Notices, and if so, do you have an example of this?

Terms & ConditionsAccessibility statement