But I am not using the date/time for this requirement. One logic I had in mind is using a custom column in BMM by using MAX(Submit_Order) and use it in the Answer. But how will I apply that in the column formula I am not sure.

Hi Martin I have raised an Oracle SR to identify the root cause of this issue and to know what impact it could give in the future. Regards Vyshak

This document didnt help. But however I ignored this warning and completed OBIEE configuration successfully. Regards Vyshak

Hi Christian The following is what I find in the logs. I have not worked on Solaris OS so not quite sure about this. [2017-08-24T10:51:18.060+03:00] [OUI] [NOTIFICATION] [] [OUI] [tid: 173] [ecid: 0000LsJELDa3j4H6yv6iMG1Pbc2600000M,0] ld: warning: file libucrypto.so.1: required by /usr/lib/sparcv9/libnsl.so, not found[[…

Hi Christian Thanks for your suggestion. Regards V

Hi Syed Thanks for your information. Regards V

Hi Gianni We will not change the label of the Total account. But here the Total account is hardcoded as Sum ( The related accounts ) For example Total POSTPAID REVENUE = Subscription Revenue + Outroaming Rev., + etc. etc. as seen in the pic below, Since the Total Account is just a static value then how can we give it in…

Hi Gianni I agree with your point about making a condition with respect to the first column. But this will be static and tomorrow when there are new accounts added the TOTAL value will tend to change. This will not change our condition. Is it ? Regards Vyshak P

Hi guys Really sorry for a late response. The issue is fixed. The problem is that Single> sign on has been implemented in the production obiee for the EBS users. Hence disabling the EBS Security context from Manage - > Variables - > Initialization blocks solved the issue. Thanks for your help and support. Regards Vyshak P

Hi I have attached the log information below. [2016-10-23T13:44:22.000+04:00] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: ] [tid: ] Error connecting to the Oracle BI Server: Could not connect to the Oracle BI Server because it is not running or is inaccessible. Please contact your system administrator.…

Hi Pedro Are you asking me to check the sawlog ? Regards Vyshak

Hi Cesar Thanks for your response. Unfortunately our clients approach is to write view out of tables from the trabsactional data and pull the view in BI to create reports. Now I do not have any option in implementing this in the ETL. Do you think I can write this in the view ? Or from the reporting end ? Regards Vyshak

Anyone ? Regards Vyshak

Thanks. I will go through the blogs. Regards Vyshak

We use OBIA 11.1.1.8.1 with ODI. Thanks Vyshak

Preferably the ETL: part. The customer wants a presentation on how you integrate OBIA with Siebel CRM using Universal adaptors unlike the pre built adaptors. So if I have a document that explains the steps to configure the universal adaptor for Siebel applications will be helpful. Thanks Vyshak

Hi Christian Thanks for your response to my post. What I want actually is that how to integrate with other data source without using the pre built adaptor. (making use of universal adaptor). Could you please help me with any document ? Regards Vyshak