I have two datasets and both are medical records . Now one contains records with the following columns:
3 Type of Doctor
4 No of Packets of Product prescribed
The secon dataset contains records with the following columns:
2.Type of Doctor
3. No of Packets of Product Prescribed
So in the second dataset, I am missing diagnosis information. Therefore to have an idea of the spread of diagnosis information on the second dataset and to report on the second dataset, I am supposed to use information gathered (diagnosis probability information) generated from the first dataset to apply on the second dataset (i.e. a way of putting diagnosis information on the second dataset uisng T-SQL or any method).
The end will be to build an SSAS cube on the data. If there is a way to do this in a cube straight ahead, that will be a great idea as well.
How can I do this using T-SQL and SSAS.
A clear step of how to do this with examples is highly welcome
I have attached the files containg the sample datasets here with the question.
Thanks for your ideas.