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.
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
Thanks so much rockytopmark, it fixed it ;D :D ..