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. CodeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started