Hi, I am facing a unique problem regarding dimension relationship, i am working on referenced relationship but its not the straight one where 1 table reference a fact table with regular relation and another table reference that table to get the values.
I have a table 'A' which reference to fact table 'FACT'. Table A contains a FK named 'ID'. i want this ID field to be referenced by two other tables X and Y. when i make a single reference the CUBE works but when i 2nd time reference it with table Y. the cube fails.
what i feels that we can only reference a table with another single table at one time and can not reference a field of the table twice with 2 different table. the data looks like
ID , Name
333 , For table 1
444, ForTable 2
Unfortunately, the data ID is in row wise values and not on column., cube always fails to process
You can create a named query in the DSV or a view in the relational source which will either join the referenced table into a single dimesion table with all the members or will split the fact table into two seperate tables each containing members from one of the dimensions. Another option is to set the UnknowMember = Visible on the two dimensions and set the NullProcessing = UnknownMember in the Advanced dialog from the Define Relationships dialog.
No comments:
Post a Comment