In OTBI reporting (i.e. from transactional DB) design , how to handle multi-key dimensions? I don't have option to have a staging/DW area where I can generate surrogate key for dimensions & use it in facts. Currently we are thinking creating Views on top of transactional tables and use it as dimensions & facts. What is the best way to tackle?