Dimension Usage issue

Hi,
I have invoice Header and Invoice Line Details fact Tables.
After creating Cube Invoice Header is working fine.
But Invoice Details not working properly, for example all are showing same value.(repeating)
In the invoice Header have customerID, But Invoice Details Don't have CustomerID.
Invoice Header Customer ID connected with DimCustomer,but invoiceline not connected with DimCustomer  Table.

Note: FactInvoiceHeader and FactInvoiceLine connected with Invoice Number
I tried to use Dimension Usage to connect but it's not working, Any idea how to connect with this
LVL 2
lankapalaAsked:
Who is Participating?
 
Máté FarkasDatabase Developer and AdministratorCommented:
Hi,
Ideally it should be connected the following way:

SELECT IH.InvoiceNumber, IH.InvoiceDate, IH.CustomerID, DC.CustomerName, IL.*
FROM dbo.FactInvoiceHeader AS IH
LEFT JOIN dbo.FactInvoiceLine AS IL ON IH.InvoiceNumber = IL.InvoiceNumber
LEFT JOIN dbo.DimCustomer AS DC ON IH.CustomerID = DC.CustomerID

Open in new window

0
 
Máté FarkasDatabase Developer and AdministratorCommented:
Can you please show a screenshot about relations in your schema in SSAS or about database tables in SSMS?
0
 
Máté FarkasDatabase Developer and AdministratorCommented:
User does not respond on my solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.