Microsoft SQL Server Analysis Services (SSAS) Cube Data Source View

Fermé Publié le il y a 3 ans Paiement à la livraison
Fermé

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?)

Serveur SQL Microsoft

Nº du projet : #28096776

À propos du projet

3 propositions Projet à distance Actif il y a 3 ans

3 freelances font une offre moyenne de 22 $/heure pour ce travail

SqlDevelopment

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.

$30 USD / heure
(19 Commentaires)
4.0
md951981

Hi, Hope you are doing great! I am sure I could be of help on defining this relationship without adding database level constraint. Would like to discuss requirements in detail on before we start working on this specif Plus

$15 USD / heure
(0 Commentaires)
0.0