Cube measure number of institutions
Page 1 of 1
Cube measure number of institutions
Hi,
can you please guide me on to start this task:
I need this for an overview of Type of institutions : How many Hospitals, pharmacies and privat practices do we have (the relevant distinction will be field either account type, account workplace type or department specialty). This means the measurements must work on top level institutions and department level. If necessary you can create 2 different measurements (main institution and department).
-----
We have one dimensional table call dimaccount which act as a master source for AccountName, DepartmentName , a.AccountType etc..if i understad this correctly then in simple sql terms it will something like below:-
select a.AccountName, a.DepartmentName , a.AccountType ,
a.AccountWorkplaceType_English, a.DepartmentWorkplaceType_English , COUNT(*) NumberOfInstitutions
From presentation.vDimAccount a
where a.AccountType = 'F'
group by a.AccountName ,a.DepartmentName ,a.AccountType ,
a.AccountWorkplaceType_English, a.DepartmentWorkplaceType_English
Am i understanding this correctly? if yes, then i was thinking to add one measure gorup in the cube for count on the dimaccount table and set relevant dimension usuage.
thanks,
regards,
ssqllearner.
can you please guide me on to start this task:
I need this for an overview of Type of institutions : How many Hospitals, pharmacies and privat practices do we have (the relevant distinction will be field either account type, account workplace type or department specialty). This means the measurements must work on top level institutions and department level. If necessary you can create 2 different measurements (main institution and department).
-----
We have one dimensional table call dimaccount which act as a master source for AccountName, DepartmentName , a.AccountType etc..if i understad this correctly then in simple sql terms it will something like below:-
select a.AccountName, a.DepartmentName , a.AccountType ,
a.AccountWorkplaceType_English, a.DepartmentWorkplaceType_English , COUNT(*) NumberOfInstitutions
From presentation.vDimAccount a
where a.AccountType = 'F'
group by a.AccountName ,a.DepartmentName ,a.AccountType ,
a.AccountWorkplaceType_English, a.DepartmentWorkplaceType_English
Am i understanding this correctly? if yes, then i was thinking to add one measure gorup in the cube for count on the dimaccount table and set relevant dimension usuage.
thanks,
regards,
ssqllearner.
sssqllearner- Posts : 8
Join date : 2014-09-16
Similar topics
» Data cube measure
» SSAS Cube - zero downtime even during cube processing
» Fitting number of dimensions
» Model available time per day in timesheet data warehouse: fact or dimension or neither?
» Unit of Measure (UoM)
» SSAS Cube - zero downtime even during cube processing
» Fitting number of dimensions
» Model available time per day in timesheet data warehouse: fact or dimension or neither?
» Unit of Measure (UoM)
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum