I have 3 hospital database with the same instance. Now I want to design Statistics of Patients by Gender for each of the hospitals in one graph bar using Power Bi. How should I do it in one cube? Can someone guide me step by step?
I have 3 hospital database with the same instance. Now I want to design Statistics of Patients by Gender for each of the hospitals in one graph bar using Power Bi. How should I do it in one cube? Can someone guide me step by step?
Somehow, how can categorize it the by A ,B and C hospital
The easiest way is to create a centralized view, which returns the data for all hospitals incl. a sign, from which hospital the data comes from, like
SELECT 'A' AS HospitalName, FirstName, LastName, Room
FROM HospitalDB_A.dbo.Patient
UNION ALL
SELECT 'B' AS HospitalName, FirstName, LastName, Room
FROM HospitalDB_B.dbo.Patient
UNION ALL
SELECT 'C' AS HospitalName, FirstName, LastName, Room
FROM HospitalDB_C.dbo.Patient
If you get a new hospital, you only need to modify the view.
I need to make 3 analysis services from every hospital first and then do the SQL above?
I need to make 3 analysis services from every hospital first and then do the SQL above?
No, the other way round. Create a view on one of the relational database with that SQL code and use the view as data souce in SSAS.
Which particular part did you find problem or issue ?
Are you having problem with multiple database as datasource ? If so, you could pull data from each of the SSAS database and store them in Power BI table, then add relation between so you could work on it.
My main problem is to do make cube from 3 data sources. For example, I have data sources from Hospital A,B and C. Each of the hospitals has Admission and Patient table which I need to make cube from it. Somehow, how can categorize it the by A ,B and C hospital ? do yo get what I mean?
I thinks this is not an analysis issue rather than a SQL database issue?
Did Olaf's suggestion in SQL help or resolve your issue ?
4 people are following this question.
File for a cloned Vertipaq data object conflicts with a master data object file
dimension security on a combination of dimensions
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
Getting error message as "Unable to find any Microsoft OLE DB providers on the machine."
How to schedule SQL profiler to auto start/stop to capture SSAS synchronization?