Excel Tables linked through multiple dimensions

[danialier]

Hello,

I have a QV taking the information from five different excel files. All of them are linked through one dimension but there are two that are linked with two dimensions (month and country).

Is that an issue ? Which are the pros and cons of having two tables linked with multiple dimensions rather than a single dimension ?

thks!

dani

[MK_QSL]

Please find enclosed simple example showing how to remove synthetic key using LinkTable.

You can see table viewer by CTRL + T

You can use the same approach for removing synthetic key...