Dimensional Calculations in FM

[eliza_jane]

I have a star schema relational model to be used in Query Studio with certain calculations in the Date dimension - Days in a cycle, Days in month, Days in Year etc. I have calculations in my model that are based on fact data items from different fact tables. The query generates full outer join as expected. No issues there.

But when I wish to see avg of this value by creating a calculation in FM that divides Calculated Fact / Days in a Cycle, Cognos generates a min on Days in a Cycle despite setting aggregate functions. Including total() inside the dimension calculation doesn't help.

[MFGF]

Hi,

How are the determinants defined on each of your dimension query subjects?

MF.

[eliza_jane]

Since all fact tables are at the same granularity and join to the date dimension at the same granularity (date), I don't have any determinants defined.