0 Replies Latest reply on Apr 25, 2013 5:12 PM by Flamingo-Oracle

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

    Flamingo-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?