What a nonsense and waste of time and money all that modeling", that's what a user said.
We have a Kimball modeled data warehouse. But now and then the user asks us not to model information, just to earn time and money.
For instance they have to make a report on information, which is delivered in a dataset by a department. That dataset consists of all the information needed. Records can be read one by one to produce the report. So the user says: put it in a datamart in the data warehouse, and with our reporting tool we will read the table and produce the report. And ... if you want to keep track of the history, just put a month-key in the datamart. We are only interested in getting the information of the dataset in a report, that's all.
Of course the user should not interfere with the technical solution.
But what should be reasons to follow or NOT follow the technical solution the user suggests??
We have a Kimball modeled data warehouse. But now and then the user asks us not to model information, just to earn time and money.
For instance they have to make a report on information, which is delivered in a dataset by a department. That dataset consists of all the information needed. Records can be read one by one to produce the report. So the user says: put it in a datamart in the data warehouse, and with our reporting tool we will read the table and produce the report. And ... if you want to keep track of the history, just put a month-key in the datamart. We are only interested in getting the information of the dataset in a report, that's all.
Of course the user should not interfere with the technical solution.
But what should be reasons to follow or NOT follow the technical solution the user suggests??