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

Cognos Calculate Measures filter conditions

Started by FatCat, 10 Sep 2008 03:50:56 PM

Previous topic - Next topic

FatCat

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

blom0344

Use one filter expression with an EXPLICIT 'OR' between the 2 expressions..

FatCat

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.

blom0344

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