What happens to business objects report if the cardinality is not specified??

Questions by jaya_gundala

Showing Answers 1 - 13 of 13 Answers


  • Feb 18th, 2007

Loops cannot be detected, hence you cannot justify the structure while checking integrity.


  • Apr 2nd, 2012

Result would be Cartesian product.


  • Aug 13th, 2012

The BO report will contain incorrect data and duplicate data.

Vyaankatesh Valakate

  • Oct 19th, 2012

Cardinality used to Relate the Schema in tables. So if there is no cardinality, forms the errors like duplicate data comes into existence.

  Was this answer useful?  Yes


  • Nov 23rd, 2012

Without cardinality we have trouble to solve problem of chamtrap, fantrap.


  • Mar 28th, 2014

If Cardinality is not specified then we will face error "Cardinality is not specified" in Integrity check in Universe.

  Was this answer useful?  Yes


  • Oct 21st, 2014

if there is missing cardinality or traps assume that there is a n to n relation its leads to "cartision product" so we have to resolve to check check integrity.........

  Was this answer useful?  Yes

Akhil Rawat

  • Nov 12th, 2014

If Cardinality is not defined than Business Objects Reports will show wrong results.

  Was this answer useful?  Yes


  • Mar 6th, 2015

Cardinality:cardinality is used to maintain the relationship between the tables.Most of the times cardinality between dimension table and fact table is always 1:N. If we are not specified cardinality between the tables

some times it will give the cartician product result(means incorrect result),and here one most important thing is cardinality detection must when we have loops occured in universe structure pane while designing the univeser

  Was this answer useful?  Yes


  • Apr 10th, 2015

If the cardinality is not specified then you will not get the incorrect result. The purpose of setting the cardinality is only to detect context and alias while using auto detect feature. If the cardinality is not set and contexts and aliases are properly mentioned then you will get the correct result.

  Was this answer useful?  Yes

vivek sharma

  • Sep 16th, 2015

Everything will work just fine if we don't define the cardinality.
but if you define there will be added advantages like:
1) Auto detect function will work that detect the cardinality thud will help in detection of loops.
2) No error messages while integrity check which is done after setting the aggregate awareness.
3) Good universe designing practice as it will prevent confusion to a new user while he is editing the universe.

  Was this answer useful?  Yes


  • Oct 23rd, 2015

Cardinality is more important in the universe other wise its give more data when traps are exist in the universe if loops are there in the universe its gives less data but our requirement is to give accurate data what client is expected so we have to take care while giving cardinal in the universe.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions