I have a fact table having two keys source_ip_key and dest_ip_key both pointing to the same dimension say iptable.
I tried to create the cube in AWM, in the join condition, i was not able to do it.
Is this not possible to have multiple keys to the same dimension or is it a limitation in AWM.
A cube cannot be dimensioned by the same AW dimension, IP say, twice. The solution is to define two AW dimensions, SOURCE_IP and DEST_IP say, in the AW that both point to the same base dimension table. You can then dimension the cube by both SOURCE_IP and DEST_IP and map accordingly.
Thanks. What do you mean by Base dimension, by which we can map source and dest dimensions.
We have thought of this approach :
-Have just one relational table IPTable
-Create two views SourceIP and DestIP from this IPTable
-Map SourceIP relational table to SourceIP dimension. Same way for DestIP.
Is this approach, right ?
Obviously I don't know all your requirements, but the approach you outlined makes sense. When I said "base dimension table" I meant something like the "one relational table IPTable" you mentioned. If you define two views on top of this one table, then the mapping becomes very clean.