Question: Using the database in these pictures how would I set up the Dimensons usins SSAS in visual studio? Develop an SSAS project named TaxiServiceBISolution. You
Using the database in these pictures how would I set up the Dimensons usins SSAS in visual studio? 
Develop an SSAS project named TaxiServiceBISolution. You will design all dimensions that are required to help explain trip mileage and trip charge based on questions posed above. For each dimension, you will need to determine:
The dimensions name,
List of dimension attributes that should be included in the dimension,
Determine user hierarchies that may need to be defined to help answer some of the questions posed above.
For each dimension attribute, you will need determine the four major properties we discussed in class. These are Key Column, Name Column, Name, and visibility of Attribute Hierarchy.
Dim DaHK Date hey -?Drive Lhej Date /}.Tr t$?010 inttr Streek Coda ocatic 0i that ge fom cy aTtp ? stieet matehed, r Hias inse steet it Then steet Code neSeet oame OLTP goes Dimlo Chant Dimlrcation so damey no oty City? eity Tablh and "Stud table.? Citl staeet Cod. steet-name. Code
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
