Hello,
I have a scenario where i need to show percentage of Male of Female members in a category. I have to show this percentage distribution in a bar chart in report studio.
I am using cognos dynamic cubes to support my reports.
To show the labels Male and Female on the x-axis of bar chart, i need them in a dimension which contains just these two entries. Is there any other approach without creating the table for these two entries.
Thanks,
Create a dimension and define it with the data that you want to use. Then define the relationship between the dimension and the cube's measure dimension, if it hasn't been done for free using the PK/fk constraints.