This content has been marked as final. Show 5 replies
Approach is okay to me.1 person found this helpful
Did you find any hidden hill with this approach?
Edited by: Srini VEERAVALLI on Jan 30, 2013 10:34 AM
I was able to do this one but i'm having problems while generating reports.
Some, times my report throwing errors - in regards to logical joins and detailed level...blah.. blah.. What might be the reason ?
Say i' generating report -- like this
Year, State, County, City ---- It throws error for some reason
And if i do this one
City, County, State, Year ---- Works
That might be the reason for LTS.. try to map those tables to Dim1.1 person found this helpful
If you still have same issue let me know the message
You havent mentioned how they mapped to the fact
If it is like
then you may go for diff logical tables for Dims
if not you have to Map them to Dim1
Edited by: Srini VEERAVALLI on Jan 30, 2013 10:47 AM
In physical layer it was mapped as
Fact - Dim1
Fact - Dim2
Fact - Dim3
In, busin. layer i have Dim1 mapped to Fact intially, then drag and dropped Dim2 and Dim3 into Dim1. So, it creates all the columns. And, if the column exists in all the dim's such as year, state present in all Dim's so those two columns are mapped to all Dim's L.T.S
Where as County is present in only 2 Dim's so it is mapped for only 2 Dim's as per L.T.S