Deisgning universe on mulitple identical excel files

[Former Member]

Hi guys

I have my source data on Excel files. the data was too much(4 years) so its split in to 4 excel files 1 file for each year all files are identical in terms of measures and dimesions. Now my question is how should in UDT or IDT i design my schema. i have 4 tables in UDT but i want to have one set of measures and dimensions. As i mentioned measures and dimensions are same in all files/tables.

Is this the right apporach to handle such a scanario. or am i doing something worng. beacuse only reason data is split in to 4 files/tables is because of the limit of rows in excel and the huge volume of data.

if this works i will be bringing in 10 years of data for my analysis.

Thanks

Regards

[Henry_Banks]

Hi,

i believe you already asked the same question here http://scn.sap.com/thread/3414990 last week ..

regards,

H