How can we find out cardinality between two tables?
Answers were Sorted based on User's Feedback
IN FRAMEWORKMANAGER GO TO WE HAVE 3 TABS
1)EXPLORER TAB
2)DIAGRAM MAP TAB
3)DIMENSION TAB
WE CAN CHECK CARDINALITY BETWEEN TWO TABLES IN DIAGRAM TAB.
SHARATH
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / balanandam
basing on the following
1. primary key and foreign key relation ship between the tables
2. columns from both tables having same behavior in terms of length and data type
3. basing on common unique index columns
generally 1 & 3 cases are using more
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anusha
Hi,
In Framework Manager, what the developers give between two
tables as cardinality will be reflected. But before builing
the relationship, the developer has to determine it based
on the semantics of the data. It can be one to one (1..1)
or one to many(1..n) or many to many(n..n)
Is This Answer Correct ? | 0 Yes | 2 No |
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
Can u please describe the different types of traps with eg. Thanks
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
1.tyes of security in cognos?.how to use rank function? 2.what is content store? 3.what is content manager? 4.how 2 use rank function?
Main Differnce between Cognos7 and Cognos8
What are different events in Report studio?
Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin
how you provide security to reports? How you provide security to packages ?
can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?
Can you explain dynamic query mode?
can you apply grouping on crosstab?
Can you define a datastore in cognos?