If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Determinants..and star schema grouping question

Started by santoshkulkarni, 13 Oct 2009 11:54:37 AM

Previous topic - Next topic

santoshkulkarni

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,


lindero

determinats must be set there where the relationships are created. otherwise they will be ignored.

kind regards.

blom0344

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)