Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
what is the joining key between those tables ?
can you attach some rows of each table in an excel file ?
Hello,
Kindly share the sample application
Thanks & regards,
Venkata Sreekanth
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.
check Generic Key
Hi Thanks for response
am using personal edition. Kindly share the script so that I can able to see your script .