I have two Calculated measures in my framework.
Each of them have a filter applied to them.
When I add the two calculated measures into a list Cognos defaults both filter conditions to a AND condition.
How can I overide this to make the filters act as OR conditions
Use one filter expression with an EXPLICIT 'OR' between the 2 expressions..
Thought of that.
What will occur is when I join the Dim to the Fact Table with the 'OR' statement I will get records that I do not and blank entries in the calculated measure
The data is normalized where as in the Fact there is a single amount that is joined to a Dimension table for one of several amount types.
Well, that really sounds puzzling. Did you consider using a union?
QuoteThe data is normalized where as in the Fact there is a single amount that is joined to a Dimension table for one of several amount types.
Care to clarify this bit. Makes my head spin just reading it ;D