Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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? image text in transcribed

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linked Data A Geographic Perspective

Authors: Glen Hart, Catherine Dolbear

1st Edition

1000218910, 9781000218916

More Books

Students also viewed these Databases questions

Question

What are Measures in OLAP Cubes?

Answered: 1 week ago

Question

How do OLAP Databases provide for Drilling Down into data?

Answered: 1 week ago

Question

How are OLAP Cubes different from Production Relational Databases?

Answered: 1 week ago