on 09-30-2013 11:45 AM
HI Guys
I have a Universe in UDT with 10 100% identical tables. only differecnce is that each table is for 1 year of data. so i have a table for 2003 data another for 2004 and so on.
now i have created a derived table and used Select * with union all to get my data from all the tables.
So now my probelm is performance each table is HUGE. and runtime is very high. Is there any way i can have the user select a year every time they run a report and based on that year prompt my query runs only on that Year's table instead of running on all tables ?
Regards
Have you got any chance to check this http://trustedbi.com/2012/12/19/dynamic-data-connection/
The general practice is to put together all your tables in to a single table and perform a Yearwise partition at database level.
Regards
Mani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
guys any help will be appreciated ....?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.