Please suggest

[antonybi]

Hi All,

I have 5 tables in the data model and it forms too many syn keys.

In order to resolve these, I have created composite keys

but missing some filters(brand, country, info_year..) and getting

some non appropriate results in some reports/KPIs)

That would be great If you can suggest any other ways to resolve.

below are for your reference.

table1 contains below fields

Country

zone

year

Volume(measure)

table2 contains

Country

brand

info_year

info_start_year

info_Volume(measure)

table3 contains

Country

brand

volume3(measure)

table4 contains

Country

brand

info_year

KPI_Volume(measure)

table5 contains

brand

info_year

revenue(measure)

Please help me out in this.

any help will be appreciated.

[YoussefBelloum]

Hi,

what is the joining key between those tables ?

can you attach some rows of each table in an excel file ?

[Anonymous]

Hello,

Kindly share the sample application

Thanks & regards,

Venkata Sreekanth

[antonybi]

Thanks for response.

but unable to share the data as am working with actual data...

that's why I have created  some dummy data which is as same as actual data.

kindly replay suggest me on this.  

[zebhashmi]

check Generic Key

Generic keys

[antonybi]

Hi Thanks for response

am using personal edition. Kindly share the script so that I can able to see your script .