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

Measure dimensions and Filters

Started by Jaguarius, 22 Apr 2010 06:47:30 PM

Previous topic - Next topic

Jaguarius

Hi everyone !

I am new to Cognos so I was designing 2 Business Rules (BR) ,

I have this issue:

I have 2 BR  and I want to show them in a report

In framework manager I am designing 2 BR as measure dimensions.

1.-Total orders (BR) which is the total count of my orders

count (id_order)  


2.- Received Orders (BR) which is the count of the received orders. (status=received)
count(id_order )<- measure
status='received<-filter'


and as I am designing them in measure dimensions

(I add in the tab of Measure dimension a new measure and I added the formula which is the same count(id_order) and for the filter in the same Measure dimension I add a new filter wich is status_order='received'.)


When I test them results are correct.
So I publish, and add them in a new list report next to a regular dimension which is Supplier.
And that's when I get the error if I put them together they display same results for each Supplier (Total and Received show exactly same results)which is not.

But If added separately (supplier for the first column and Total orders for the second) everything is ok, but I want to show both at the same time in the same report.


So that is basically my issue Hope You can help ...Thanks and for the person who can help me my respect.

rockytopmark

Remove the filter ... this will filter both measures.

Change the the Received Orders expression to check the status and total from there.

something like:

If([status item] = 'Received') then (1) else (0)
...and set the aggregation property to Sum

Also, I would shy away from having aggregate functions in any Measure Dimension items, such as your count(id) for the other measure.  I would simply code in your semantic layer a numeric value (often simply 1) to let Cognos aggregate naturally.

In the case of count([id]) you should change to simply [id] and set its aggregation property to Count

Jaguarius

Thanks so much rockytopmark, it fixed it  ;D  :D ..