New Query Subject (join on Store with no determinants set):
As there are four employees at the Bayside store this forces the model query subject to return four rows repeating the sales budget.
To correct this Framework Manager has to be instructed what level of granularity the budget applies to. This is done using determinants.
In our example we need to set the determinants on the Sales Area query subject.
Right click the query subject and select the determinants tab.
One determinant should be created for each level of granularity as shown below.
Create the determinant by clicking Add.
Rename the determinant and then drag the identifying column (Key) into the key window (bottom left). If the level has any attributes that exist at the same level of granularity these should be added to the Attribute window.
If the new determinant you have created is the lowest level grain (Employee in this case) the Uniquely Identified check box should be ticked.
The Group By tickbox should be ticked if the level is ever to be used for aggregating values.
Ensure that once you have created all of your determinants for the query subject that they are in the correct order (use the up and down buttons to sort them correctly).
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/615040/viewspace-567555/，如需转载，请注明出处，否则将追究法律责任。