Importing to obiee

user588690

i am relatively new to obiee, have a question.

i have four transcation tables in sql server, i need to import those in obiee.

What is the best way i can import/create the equivalent based on facts and dimensions.

thanks

Robert Angel

Hi,

I think you need some training, I would get yourself on a course or if this is not an option at least work your way through the Oracle by Example material.

The process is that you edit the repository (rpd) via the admin tool to add the tables in question to the physical layer. You alias said tables to give an indication of what you will use them for when modelling them in the logical layer. In the logical layer you then model the FACT logical table(s) and dimension logical tables(s), renaming columns to business friendly equivalents setting up their hierarchies and setting appropriate content levels between logical tables sources. These are then exposed to the end user via the end user layer ensuring not to expose keys, to follow best practise in folder naming, ordering and presentation.

In short it is no small task and you really need to know what you are doing.

Hope this helps,

Robert.