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
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.
Hi,
Are you using a relational or a dimensional package?
MF.