0 Replies Latest reply: Apr 25, 2013 12:12 PM by User761901-Oracle RSS

    Multi-key dimension handling in OTBI report design - How?

    User761901-Oracle
      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?