![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: Negative reporting on Report Generator Topic Summary: Trying to create reports of negative questions in the Report Generator facility Created On: 18-Sep-2006 14:12 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
Hello,
I'm trying to create a report that queries my encyclopedia in a negative style. Example: list all the names of the Application type definitions which aren't contained in a list inside Process type definitions, in other words trying to find out which applications don't support any process.
I can work with the options "use Definitions" or "used by Definitions" in the Report Generator GUI but this lists the applications that are inside the list. Does the Report Generator support the concept of "NOT"? Is there any way to find out something that is "not linked to", "not related to", "not contained in" or "not used by" ?
Thank you!
|
|
![]() |
|
![]() |
|
Use the "Partial" option to include in the report output those objects for which the following relationship(s) does not exist
|
|
![]() |
|
![]() |
|
Does anyone besides me think the partial feature is broken in the report generator?
Mark |
|
![]() |
|
![]() |
|
Selecting 'Partial' at a given level of the report will report all items up to that level of the report, regardless of whether the subsequent levels match. This effectively means the report will have missing fields for items which do not match beyond the partial level indicator. ------------------------- Senior Software Developer Telelogic UK Ltd. |
|
![]() |
|
![]() |
|
Ironically that is a PARTIAL solution to getting a negative answer or OUTER JOIN
Example - I have a relationship of A uses B - in A I have objects 1, 2, and 3 - 1 and 3 have a reference to a defintion in B where 2 does not I need to report 2 only... using partial it will show all 3, the only difference when using PARTIAL is that I get to see 2 as well.... I need a way to show only 2 like a true outer join or negative question. Example: Show me where my investments do NOT have a associative referenced by relationship to a performance objective. Is there a way to using PARTIAL to filter 1 and 3 by simply saying where Name = " " .... so far I found that does not work.... Without the answer of changing my metamodel (as I have over 500,000 relationships in the DB), how can I report only for #2 ? Thanks for your help Ian.... (re: to Mark what is broken, this is the part I'm not clear on at least). |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.