user652652 If this has helped, would like to close this thread by answering correct or help full?

Give it a try by restarting complete obiee services..

Hi, Why are you using this through customisation when the same can be achieved through dynamic repository variable? Make a default value for those columns as SERVER VARIABLE and name the respective variables in the box. I hope this helps. Thnx, Sagar Tippe

Hi, As a work around, could you try by creating BINS (or CASE STATEMENT) for CUSTOMER_NAME column? Obviously, this needs to be done manually and only if customer list is not huge. but that's the ONLY solution to fix this temporarily. Let me know your results.. Thnx, Sagar Tippe

Hi, * Try to create individual reports based on those 2 columns. If working fine, follow step 2. * Create another report which will have both these dimensional columns and your measures. From this report, you will get to know that whether granularity of all these columns returns data of not. * If this returns data, check…

Hi Priti, The cause of this issue was due to an incorrect value for the <DSN> parameter in the Instanceconfig.xml file (Presentation Service). Compared to the value in the Operating System's ODBC Administration setup for the Oracle BI Server Data Source. In the…

First: Why the numbers configured are in thousands billions? Use SQLLDR for data pumping, you will surely get a better performance than OBIEE. Second: Definitely issue is not at DB end. Try creating a complete new analysis by pulling one column at a time, you can check where the problem lies in. Third: Try taking physical…

In addition to what Martin said, you can configure a TRIGGER at database level which will send an email whenever there is an entry to the above mentioned tables.!! Hope this helps.. Sagar Tippe

Thanks mates.. On a way to Apex for the first time.. will keep you posted whether I get it or not..

Yes @Christian Berg, It seems he is very new to this technology. Yonan please go through this basic tutorials provided by Oracle. This is for both the versions (12C / 11g) OBIEE Tutorials

This is default behavior of OBIEE. You can upload only one repository to the server at a time. Once you upload your own repository, the old one will get replaced from server's in-memory.

Good to hear that you got connected to your rpd online. To upload your own repository to bi_server, please search for "upload rpd in obiee 12C", there are plenty of articles on the same. for reference, Oracle Business Intelligence 11g: OBIEE 12C - Upload Repository Commands - downloadrpd & uploadrpd PS: If you have got rid…

Hey Yonan, From the screenshot, I can see that you are putting a wrong machine name / server name in "Server" field while creating a new DSN. Your screenshot no. 4 clearly shows your hostname / server name / machine name is "vm02" or else you can always put your IP (which again your screenshot says) 192.168.56.102. Give it…

Hello Christian, thanks a lot as usual.. you came to rescue.. to clear doubts from the basics.. thanks for the answer and many thanks for that particular doc in the link.. that was fab info.....

This clears my thoughts. Thanks rmoff as usual..

Ramesh, Go to job manager and delete the failed jobs manually, no need of script.

Hi, The GUIDs are locked down to each user, yet there could be authentication issues causing strange behavior with GUID mismatches. The agents only make this issue more pronounced, and if you have GUIDs that are out of sync, then that could easily impact agents. In this instance the scheduler tables are inconsistent (e.g.…

Hi Gianni, Got rid of this issue. There was nothing wrong with the script, while defining parameters in "Invoke Server Script Window", Parameter name should be 0 and 1 according to the scrips and the sequence should be as first parameter should be "Document Parameter" and then a "Value Parameter" I know silly mistake, but…

Thanks for the quick reply Gianni. I check this configuration and can see that path is already set. If you see the JavaScript I'm using, // Parameter(0) = Agent Result File Path // Parameter(1) = Last Part of Output File Name (no path) // ///////////////////////////////////////////////////////////// var FSO = new…

Hi, Your error log clearly says, * you have entered wrong credentials / or access has been revoked for that particular user * Or else you have attempted to "Scan and Update Catalog Objects That Require Updates" which will change the object id's of some reports and other objects. As OBIEE works with Object id's and not with…