Can you please elaborate on your problem? Hard to give a meaningful answer without any details.
You have 1 physical table containing 2 dimensions? Why would you design it like that, in a DB you hardly pay based on the number of tables, so just give your 2 dimensions their own tables
But it all depends on how this thing is linked to your fact ...
And a huge +1 to Gianni:
Two dimensions in the same table?! What kind of dimensions are those? Unless you are simply talking about roleplaying dimensions this is something which doesn't make much sense to begin with as it will cause you quite some problems with basically zero advantages. Literally: there is zero advantage in having two dimensions in the same table.
I think I was not able to ask my question properly. But, I am able to resolve my issue.
Thanks a lot everyone for replying!
So were you talking about roleplaying dimensions as Christian suggested?
And if so you solved this by creating aliases hopefully.
Please update so that others may benefit as well.
Please post your solution for the benefit of other users.
This is a forum built on participation. Taking and giving.
Actually my requirement was something like:
Customer products ----> Customers ------> Sales
Where Customer products and customers are Dimension Tables and Sales is a Fact Table.
I was not able to join Customer Products and Customers. Then I created the above mentioned structure in physical layer. Then in BMM layer, rather then dragging (Customer Products and Customers) tables, I achieved it by using 2 LTS.
That doesn't seem right at all actually.
As soon as you drag a column from Customer Product in your analysis your figures will explode as (i assume) customers have more than one product.
What are you trying to achieve, by this i mean what is your functional requirement.
-Are you trying to create a analysis of sales on Customer Products?
-Do you want to show a list of Customers and the products that they have?
Beaten by Martin. That's just plain wrong.