• Kind of... Makes me think!

    I suggested to use a datamart instead of fullfilling the client's report request one by one and we are not planning to use Analysis Services (cubes) for the time being.

    In essence, I am just trying to create an easy base for reporting.

    Our view of the data is also partial as we are only an "intermediary" (the web front-end to mainframe back ends). Our client uses their own datawarehouse inhouse.

    I'll do a bit of reading

    Thanks.