Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
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
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 18-Sep-2006 14:12
User is offline View Users Profile Print this message


Jose Lima

Posts: 5
Joined: 24-Nov-2005

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!
Report this to a Moderator Report this to a Moderator
 25-Sep-2006 03:55
User is offline View Users Profile Print this message


Ian Souchard

Posts: 22
Joined: 28-Feb-2006

Use the "Partial" option to include in the report output those objects for which the following relationship(s) does not exist
Report this to a Moderator Report this to a Moderator
 27-Sep-2006 14:55
User is offline View Users Profile Print this message


Mark Frazier

Posts: 41
Joined: 6-Dec-2005

Does anyone besides me think the partial feature is broken in the report generator?

Mark
Report this to a Moderator Report this to a Moderator
 5-Oct-2006 14:09
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

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.

So you would be able to see the items which were negative, by identifying them as the ones with no fields output, beyond the partial level.

There is no special keyword which will provide a negative relationship through the reporting system.

Mark> What do you believe is broken?

Thanks
Ian



-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 9-May-2007 19:15
User is offline View Users Profile Print this message


Matt Tricomi

Posts: 19
Joined: 20-Jan-2006

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).
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.