OBIEE 12.2.1.1.0 and 12.2.1.3.0 error during configuration (Repo on MS SQL)

We face issue when install and configure OBIEE12c 12.1.3.0 on Windows server and keep repository in MS SQL
Error occur when go to last step , during configuration.
Error in Windows will keep in > C:\Program Files\Oracle\Inventory\logs
And this's main message

failed with exit value 1[[
oracle.bi.exec.ExecutionStatusException: Execution of [cmd, /c, C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\oracle_common\common\bin\wlst.cmd, C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\bi\modules\oracle.bi.configassistant\essbase.py, C:\Oracle\Middleware\Oracle_Home\bi\bin\..\.., C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi12c, weblogic, Expanded, OCSBOCAPPSRV01, 9502, 9503, SQLSERVER, weblogic.jdbc.sqlserver.SQLServerDriver, "jdbc:weblogic:sqlserver://OCSBOCDBSRV01:1433;databaseName=BI_REPO_PROD", P, "jdbc:weblogic:sqlserver://OCSBOCDBSRV01:1433;databaseName=BI_REPO_PROD", ] failed with exit value 1
at oracle.bi.exec.StdinProcess.runProcess(StdinProcess.java:99)
at oracle.bi.exec.ExecScript.executeScript(ExecScript.java:191)
at oracle.bi.exec.ExecScript.executeSynchronousScript(ExecScript.java:95)
at oracle.bi.exec.ExecWLST.executeWLSTScript(ExecWLST.java:62)
at oracle.bi.install.config.steps.WLSTStep.executeSingleShot(WLSTStep.java:55)
at oracle.bi.install.config.basesteps.SingleShotActionStep.execute(SingleShotActionStep.java:31)
at oracle.bi.install.config.basesteps.StepList.execute(StepList.java:85)
at oracle.bi.install.config.actions.BIConfigAction.doExecute(BIConfigAction.java:127)
at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:405)
at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:88)
at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:108)
at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15)
at oracle.as.install.engine.modules.configuration.action.RequestQueue.performSequentialExecution(RequestQueue.java:284)
at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:260)
at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:185)
at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:82)
at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:87)
at java.lang.Thread.run(Thread.java:748)

Main message you looking for below wording

failed with exit value 1[[
oracle.bi.exec.ExecutionStatusException: Execution of

oracle_common\common\bin\wlst.cmd, 

failed with exit value 1

The Cause it's from Java version, JAVA_HOME, Java path surely! , please review your configure.

Great OBIEE design best practice

This link is provide great detail for OBIEE design best practice, cover all RPD and report, prompt

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=257561774611961&parent=SrDetailText&sourceId=3-15449032691&id=2106183.1&_afrWindowMode=0&_adf.ctrl-state=rkiac2fph_405

Link of PDF document at the bottom of page.

Oracle Business Intelligence Enterprise Edition 12c Release 1 (12.2.1.3) available now

Oracle Business Intelligence Enterprise Edition 12c Release 1 (12.2.1.3) available now by this link

http://docs.oracle.com/middleware/12213/index.html

Some tips for OBIEE12C and HFM11.2.0.4 and resources

Step to connect OBIEE 12C to Oracle (Hyperion) HFM 11.2.0.4 isn't easy. Step quite complex, detail step-by-step you can follow this official link https://support.oracle.com/rs?type=doc&id=2158975.1

** require oracle account password

Main step is below
1. Installing and Configuring Hyperion Financial Management ADM Thin Driver
2. Configuring Communication Between OBIEE 12c and HFM
3. Configuring the BI Administration Tool to be able to Import an HFM Application
4. Importing an HFM Application Into the RPD
5. Creating a Subject Area in the RPD
6. Accessing the New Data Source Using Analytics

Steps in oracle link is straight forward but we still face issue, so I write this blog to keep information about setup/configure OBIEE 12C to Oracle (Hyperion) HFM 11.2.0.4 for reference.

First issue , you might be face
- Duplicate / garbage data for Null value
- When you done for configure for connection and it worked, when you create new Analysis report and found some error/garbage data at some row that have null value , this's I mean

Entity Name 03, 04, 05 show same value

Solutions

You can use expression IFNULL to fix this issue, this issue because OBIEE12C have a issue of Null value so once we found this we can put IFNULL(Measures,0) to change Null value to zero and garbage data will gone.

** For resolved picture, it have something change is we put *(-1) for expense account so you can see opposite sign. But main point is abut Entity 03,04,05 show the correct value that is zero (Null from system)

Focus for orange circled that show 0 instead of garbage values