This content has been marked as final. Show 2 replies
What are you expecting based out new logical dimension?
Try to create alias for fact in Physical layer and then join with fact.
Or else keep the existing implementation and use the separate presentation table to have dimension column. This would avoid a join too..
If helps pls mark
Edited by: Srini VEERAVALLI on Jan 4, 2013 3:09 PM
Since my main logical fact table consists of two LTS and the dimension being created from this table will also have 2 LTS, the content level will be set to all levels on which the fact is joined.
So I would like to create a logical dimension based out of my dimension and then assign the content level at the detail level.
Please let me know if I am not clear.