what happens if cardinalities are not resolved?
Answers were Sorted based on User's Feedback
If Cardinalities are not specified between the tables i.e
the relationship between the tables ( 1-1,1-MANY,MANY-MANY)
We get more results at report level more than the actual
result,like a Cartesian product.
We can't detect the Loops & Traps
(Chasam & Fan) Which are mainly detected by the
CARDINALITIES option
so it should be Identified.
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / srinivas
hi
this is srinivas
cardinaliries are called relationship, u given the tables
relationship 1-1,1-many,many-1,many-many relationship
(which is suitable for that area) give the correct
once check the check integrity button
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nagarjuna
If we r not Resolved this then we will not resolve the
loops (contxts,alias).........Nagarjuna
Is This Answer Correct ? | 0 Yes | 3 No |
what is difference between global filter an query filter in web intelligence?
In banking domain how many Fact tables,Dimension table are present?
What is slicing and dicing in business objects?
How to hide the table s in webi?can any one tell me plzzzzzzzz
What is the need of live office connector
My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?
What is mean by tuning the report?
How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.
1 Answers Cognizant, WinAlliance,
When we can use multiple sql statement for each measure? and multiple sql statement for each context?
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
What are the data types present in bo? What happens if we implement view in the designer and report?
There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?