Hi,
I get a lot of incomplete tables in my job.
One of the most common being tables where i DO have to postal code but DON’t have the city.
I made a external source (excel table) for this purpose where i had every city with every postal code.
So when i make a report, i load this table as a new datasource.
I then make a dimension of the postal code which i couple to the existing postal code.
Then i make a detail of the city in the new datasource and this detail says something about the postal code.
I insert an empty column where i insert this detail and presto, solved.
I try to do this in Webi, but i don’t succeed (i switched to Webi a month ago).
Any ideas?
tantetruus (BOB member since 2008-11-11)