Hi guys,
I created a database using section access for a number of hospital.s
The admin can see all the data and the hospital users can see only there data.
I've done this just using the hospital ID's
I have KPI's set up for particular data they are looking with specific calculations.
So when Section Access kicks in for user they only see there data in the KPI's.
The admin are asking can I show the National Average along side the KPI's. So Hospital Data along with National data so they can compare.
What I understand to do this is you create a separate table away from the section access. The way I am doing this is
Load
count(if (Interventions_ID = '1' and TimeBSPAx_ID = '1', NEWKEYID))-Count(if (Interventions_ID = '1' and TimeBSPAx_ID = '1', PatientsNotAssessed_ID)), as [National_>2hrs]
resident
Fact;
With the table then being [National_>2hrs]
I am creating the new table in the script and then doing the upload. But for some I'm get an error during the upload that it those not see particular field, for example it say it does not recognise the above 'interventions_ID'
Is it that I need to link the tables in some way? Totally stuck on this!
I may be over complicating this!
Please Help!examples would be great!
