The following is the procedure to create a basic report on local machine using OBIEE.
In the physical layer join the tables using Foreign Key>Drag them to the BMM layer. Join the tables using Complex join which helps to join logical tables with multiple sources and specifies cardinality relation between the tables. Fact tables appear in yellow while the dim tables appear in white. Then drag the same in to presentation layer or create a new catalogue in presentation layer. Then check consistency and global consistency before saving and close RPD.
In order to access Answers, both BI server and Presentation server should be up and running. To switch on servers following is the procedure
Control panel> system & security> administrative tools> services> RC on BI server and start. Make sure presentation server is started. OC4J should always be started before running anything (Programs>OBI>start OC4J).
NQSconfig.ini is one important file which determines many settings of this tool. Only one RPD can be run in Answers which needs to be set up in this file.
Go to Mycomputer>oracle BI> server> config> NQS config file open it> come down and in repository section comment(#) on default and change the new rpd file that we wish to see in answers.
Now programs>OBI>presentation services> password is empty while user id is Administrator> Answers> To the right is the catalogs created in RPD click on anyone.
Then at the left we can see the tables we have put in catalog in RPD. Select the columns we need and click display results to create a request and save it in shared folder.
U missed out to mention that one would need to create a Logical Complex join and by specifyingh which we tell obiee that this is fact and this is dimention.
ReplyDeleteLogical complex join specifies the cardinality ration between two tables involved into the join....
Yes, Complex join in BMM layer helps to join logical tables with multiple sources, I have mentioned this point in BMM layer post.
ReplyDeleteThanks for reminding Santanu, I will mention it here.