Calculations for counting a measure across different dimensions

[JP1981]

Hi.

i need some guidance, getting back into cognos after many years. i have a report which i am working on. It requires me to create a few calculations based on one measure from the fact and using other dimensions all is one query
First is - count a measure( which is a number field) based on a specific product(for example - product line = A)
Second - count a measure( which is a number field) based on a specific Status type(for example - Status type =  X)

product is a diff dimension, Status is a different dimension. i am getting the measure(number field) from the fact,

i will be show this breakdown by Region, region dimension.


                  Product A     Status X
US                  10                15
America          35                  5
Asia                 14                 45


i thought this would be simple, and i can just do the counts by doing a simple case or if statement but i am not able to combine the two calculations based on different dimensions in one query. it works when i calculate one calculation for product in one query and one calculation for status in a different query. I need to show them side by side in one report?

please advise some approaches i can take?   and what options do i have.  in this something i may need to update my model and create something there?  would appreciate any help.

thanks,
JP

[bdbits]

If you get the correct values with separate queries, you could union the two queries within Report Studio.

I should think counts from a single fact table would work without resorting to in-report unions, but it is possible something in the way the data is modeled prevents it from working properly.

[MFGF]

Hi,

Are you using a relational or a dimensional package?

MF.