Hi,
Had a question regarding DMR.
Which is the best place to set the determinants?
At the database view or the business view or both?
And is star schema grouping required once again if you have the joins defined at the database view layer?
Would appreciate some thoughts and ideas.
Thanks,
determinats must be set there where the relationships are created. otherwise they will be ignored.
kind regards.
Quote from: Cognos_8_BI on 13 Oct 2009 11:54:37 AM
Hi,
Had a question regarding DMR.
Which is the best place to set the determinants?
At the database view or the business view or both?
And is star schema grouping required once again if you have the joins defined at the database view layer?
Would appreciate some thoughts and ideas.
Thanks,
relationships between model query subjects in the business view override those inthe database layer. So, determinants should be set in the business layer.
The star schema grouping in FM is really just a wizard to enable you to build a set of shortcuts over the business view (presentation layer). It is a wizard that lets you only select model objects 1 level deep compared to the fact object. If your database layer is build like a perfect set of star-schema's then you could possibly skip the business layer and define the starschema grouping directly. This is not best practice though, as database objects are prone to change. The business layer is there to meet and correct those changes (and to remodel if no perfect starschema's exist)