Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a data in excel ,sql server and other database.i have different tables in different dats source...now i want to make reports based on that..so how to do it,can any help me in detail@@@@
Hi
First design the data model for your document taking into account the field names and tables, and specify the fact table(s) and dimensions.
Then load from each source in turn:
HTH
Jonathan