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

Dimensions in Cube designer

Started by Dineshpullagura, 28 Jan 2016 02:20:51 PM

Previous topic - Next topic

Dineshpullagura

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,


bus_pass_man

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.