Data model change

[manu1512]

Hi all,

I am facing the problem in requirement.

We have two different dimension used in two charts as dimension:-

Contractship to country,Equipmentshiptocountry both have same values :-

Now client if we select Contractship to _country , same selection should appear in ,Equipmentshipto_country chart..

Contractshipto_Country in SMA table
Equipmentshipto_Country in Equipmentshipto Customer

Both dimension are in different table.

let me know incase of further details

 Pfa the snapshot of data model

Kind Regards

Manu

[Marcos_rv]

Hi how are you? mmmm I would try to add this field to the key, in both places, so you could be sure to be talking about the same in both tables. You'll have to play with the keys, but it's the way. Regards!!!

[manu1512]

hi ,

i am good ,how are you doing ?

If possible can you pls elaborate with example?

Regards
Manu