This content has been marked as final. Show 3 replies
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.