Better Triage: Getting hospital care delivered properly

If you have seen my recent posts on LinkedIn you probably know that I am looking to interact with healthcare professionals to brainstorm ideas on how Triage can be improved. In this post I will cover what Triage is and some common issues identified with the process and my attempt at a solution. I am…

SSAS- Deploying the cube

Now that we have finished creating a simple cube with a single dimension and a measure we need to deploy the cube to the SSAS engine. Let us start by opening the project and navigating to the solution explorer pane within the IDE. Right click the project and select properties On the below screen ,…

SSAS: Working with dimensions, creating a dimension

Now that we have some idea of what a dimension is let’s create one in our DemoCube project. First let’s have a look at all the tables we have as part of our data source view, right click on the data source view pane and selected show all tables. We have the tables listed below…

SSAS: – Implementing Perspectives

A perspective is a very useful feature within SSAS as it allows the designer to mask the underlying complexity of the cube based on the user. The perspective by definition means a point of view and this is what is provided when we implement a perspective within a cube. Say for example a cube consists…