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.
Hi,
How are the determinants defined on each of your dimension query subjects?
MF.
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.