Straight table multiple dimensions

[#1]

Eligibility : A member who is Eligible for a Program

Enrolled: A member who is Enrolled in a Program.

For Eligibility i calculate the Gender Classification based on :

Dimension:

=If(MEM_GENDER='M','Male',IF(MEM_GENDER='F','Female','Unknown'))

Expression

= COUNT(DISTINCT PERSON_KEY)

For Enrolled i calculate the Gender Classification based on :

Dimension:

=If(ELIG_PERS_GENDR_CD='M','Male',IF(ELIG_PERS_GENDR_CD='F','Female','Unknown'))

Expression

= COUNT(DISTINCT ELIG_PERSON_KEY)

How can i bring these two dimensions under a single straight table as i have to calculate the Eligible/Enrolled percentage for

Gender group.There are two dimensions and two expressions which i have to get them under a single chart?

any ideas?

[jagan]

Hi,

Can you attach sample data and file?

Regards,

Jagan.

[#3]

Hi Poornima

PFA.... Hope it will give you some idea

Regards

nirmal

[#4]

Hi Nirmal,

The gender columns are also different in my case: MEM_GENDER,ELIG_PERS_GENDR_CD

How will i specify as two dimensions and which one to map for the expressions?

[kaushiknsolanki]

Hi,

     It will depend on the way the data model is designed.

     One thing need to know why do we have 2 different columns for Gender? Why cant we just combine it.

     If we combine this, you will get the solution.

Regards,

Kaushik Solanki

[#6]

can you please attach your application... hope it will easy to do

Both gender field names are different ok but in that field values are same correct???

[#7]

They are two different tables .So

they are not linked in any way

[#8]

ok attach your sample application

[kaushiknsolanki]

Hi,

     Then you need to link them together anyhow to make them available under one chart.

Regards,

Kaushik Solanki

[#10]

PFA sample application