on 10-16-2015 11:55 AM
Hello Experts,
i'm new in sap bobj,little confused in deciding cardinality for joins.
how do we decide that here we should use one to many ,here one to one....?????
Information Design Tool has two methods to detect cardinality:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
if you know how many rows of one table will match with rows in other tables then you can manually set the cardinality.
If not sure then click on the Detect cardinality and designer will check and display the right cardinality.
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check in the backend db, table structure/records,how the rows are coming,whether some column values are repeating or not repeating, and most importantly how the table is related to the other table and how the report requirements are/going to be.
The basic thumb rule is you should know the business logic of the functional domain you are working,and then know about what is this table about and what each fields meant to be,only a business analyst/functional domain expert could guide you on this.
Regards,
Naveen.
Hi,
That is the case when you can checking cardinality between two large tables where volume is high.in that case auto detect cardinality will take time to show the relationship.
check this link on more cardinality or check universe designer guide.
How to Define Cardinalities in Business Objects Universe
Amit
User | Count |
---|---|
94 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.