Microsoft SQL Server Analysis Services (SSAS) Cube Data Source View
$15-25 USD / heure
Hi - I've the following scenario in SSAS Data Source view (data model). This is at a high level.
Dim Policy
-------------------
PolicyKey(PK)
Dim PolicyQuote
-------------------
QuoteNumber (PK)
FactPolicyQuote
------------------
PolicyKey (FK)
QuoteNumber
FactPolicyTransactions
-------------------------
PolicyKey (FK)
Policy Amount
Question : I want QuoteNumber associated for the policyKey(Policy) in FactPolicyTransactions. There is no Quotenumber key in this table right now. I dont want to create relationship of DIM PolicyQuote (Quotenumber) for this table.
Without doing that can i create a column in FactpolicyTransaction kinda calculated or something which would get the quotenumber from FactPolicyQuote fact table ? (as factpolicyquote has quotenumber associated with PolicyKey?)
Nº du projet : #28096776
À propos du projet
3 freelances font une offre moyenne de 22 $/heure pour ce travail
I can qualitatively assist you with design of Data Source view. I am Senior MS SQL/BI Developer with 10+ years length of time professionally worked and I have advanced skills in SSAS development.