I just like to know , in case you are doing QV for certain industry , and the report for that industry standard . it is possible to design one common user interface and just load the raw data and make all the field and table structure as standard.
This way can save a lot of time in develop new project . As it will cut down time spend on link all table. and create the ColumnDim and Current exchange rate.
In case you have these experience , do share. Or every project need to start from zero ?
user interface i mean the QV sheet where user use that for analyse their report , the chart and table which help user answer their question.
So that don't need to make so much modification on QV screen , just add new SOURCE. meaning just need to read the new raw data and make the field name all same , so that when QV binary load the data , don't need to make much changes on QV sheet.
your last sentence on " This is what Today BI offer " , are you refer to user self service ? meaning only create all the master key and user create the chart and table they want ? so user don;t need to know how to write SET expression , just click and drop ?