Managing two business keys in one dimension lookup
One answer
I have created a Release lookup in Data Manager, which maps to the Release Name in the fact table and returns the releaseID. I wanted the lookup to map on 2 keys (1. the Release Name and 2.The Project Name ). Can anybody help me create a lookup on 2 business keys? Thanks
Data Manager has a limitation and it is not possible to use 2 columns. You will need to either filter on the base select statement for the lookup i.e where project=<something> and declare release name as the key, or you can create a derivation on the fly concatenating the two column values in one string and use that as your key column.