help

[#1]

if two field  present with in the table but if i select one field  it didn't show any association in other(means if i select a value from one field all the value in  other field turns gray

what to do in this case

[tresesco]

It leads you to comprehend that, the specific field value has no values in other field against it. This could happen if you join tables in the script.

[#3]

how to resolve it

[#4]

Fiscal Year_GHAJR and AmountInLC_Actual present in the same table and fiscal year present in FiscalCalender table

in the front end gross revenue is the calculated dimension and summation of all the above dimension but it won't display ,if i make a selection on Fiscal Year_GHAJR field although they present in the same table

see the attachment for datamodel

[ashfaq_haseeb]

Hi,

It could happen if the is no association or logical connection between the two fields.

Regards

ASHFAQ

[#6]

they both are present in same table

[ashfaq_haseeb]

Hi,

Attaching sample data would really help.

Regards

ASHFAQ

[#8]

You need modify the table structure while loading the data table. I suggest load these 2 fields into separate table along with key field. Please find the below :

Main Table: KEY, A, B, C, D, E

I want break the association b/n D, E.

MainTable:

LOAD KEY, A, B, C, D, E FROM TABLE;

NewTable:

LOAD DISTINCT KEY, D AS NEW_D , NULL() AS NEW_E Resident MainTable;

LOAD DISTINCT KEY, Null() AS NEW_D , E AS NEW_E Resident MainTable;

Drop Fields D, E ;

[#9]

see  the attachment

It will give zero on year selection

[ashfaq_haseeb]

I try to download  the attachment.

I think its corrupted I could not open it.

Could you attach it again.

Regards

ASHFAQ