Hello fellow BI Developers,

I'm new to BI and data cubes and I have what I hope aren't silly questions. I'm trying to develop a sales cube that includes a lot of ancillary information about customers, invoices, items, etc. I'm having a hard time getting certain table relationships to work even though they appear to be related way back in Dynamics AX 2009. For example, I'm trying to enforce relationships between CustGroup and CustTable and then; CustInvoiceJour, EmplTable, and DirPartyTable. I simply want to pull the customer group and customer group name and have the ability to drill down to the customer in the first scenario and in the second, pull an invoice and display the name of the sales administrator.

The first scenario will give me the correct groups, but the group names are all doubled and don't follow their associated group ids. (As a sidenote, this particular table comes into my cube with an incomplete Dimension Structure: the key attribute never has the Attribute Usage set to "Key" and I have to set it manually???)

The second scenario will allow me to display information from customer to invoice to sales administrator to employee id to party id, but then breaks going into the DirPartyTable.

I can provide screen shots of my BI tool (we use Targit BI Suite here) if it would help. I'm suspecting attribute relationships and/or hierarchies as the cause for these issues, but I haven't been successful in figuring out why it's happening. Particularly with the EmplTable.PartyId==DirPartyTable.PartyId join as it seems like it should be automagic since the tables are already related. Any ideas of what I might be missing?

I know this is rather brief and largely incomplete; I'd be happy to provide more information for you if it will help me figure this stuff out. Thanks in advance for your help!