February 2, 2022 at 10:16 am
Please assist i am trying to create a star scheme in SSAS. I believe PI_ServiceRequest is my fact table and the rest dimensions. After creating the Data Source View, are the tables suppose to automaticaly have relationships or must i create it and are all id's columns primary tables in the tables?
When i create a cube and choose PI_ServiceRequest as a fact table, i cant create the dimensions. What am i doing wrong?
Data set and SSAS project attached.
February 2, 2022 at 5:46 pm
I'm not sure what your schema should look like, but posting proprietary company data and structures on a public forum would be grounds for immediate termination.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
February 2, 2022 at 7:33 pm
Its dummy data.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply