Hi All,
This might be a silly question but still I am not aware of this.
My question is , After arranging the table structure in universe with necessary joins and cardinalties, I am doing an integrity check. Suppose if I get no loops or no errors, does that mean the universe is fine or error free?.. Can I go ahead developing the reports using this universe?..
Kindly clarify me.
Best Regards,
Angelina
Angelina (BOB member since 2010-07-11)
An integrity check simply gives you the ability to check if the universe has any errors.
It can be riddled with errors and still work, it just depends how bad it is.
Generally what I use the integrity checks for is to make sure that all my objects have parsed.
The fact that your universe has no loops, probalby means that you aren’t using contexts and there is nothing wrong with that, but once you start to get really complex universes, loops are normal and they will appear in your check, but you should be able to see that they are covered by a context.
I have an example where I have a loop in the universe, but it needs to be there otherwise the query returns the incorrect result.
If you have divergences, this means that you have queries that are not joined into the structure. An example of this is if you have alias tables and you decide not to link in the original table into the query. Again very valid and it doesn’t stop your universe from working.
An integrity check won’t pick up fan or chasm traps, you will only every be able to see these by looking at the structure itself.
So in summary, use it as tool just to check that the universe is doing what you want.
plessiusa 
(BOB member since 2004-03-22)
Thanks for the reply 
. It was very helpful for me. Can you let me know how to create context and make use of it if there is loops… It will be great if you can provide me with an example or a sample universe which has context.
Best Regards,
Angelina
Angelina (BOB member since 2010-07-11)
Please read the designer guide.
Jansi 
(BOB member since 2008-05-12)