yes, correct. but we need few columns for which we cannot exclude at data model layer, hence trying to exclude them while exporting. Regards, Abinash

Hi Christian, We are using Oracle Business Intelligence 12.2.1.1.0. mounted on UNIX platform. Agree with point b, "In general CSV is an export of the *data*. Not from what the report displays and mangles and omits." -- Even OBIEE does that, but how can we remove the unwanted columns from displaying to user, which makes no…

Hi Nikhil, How do you call your Java package, through Unix command line? or can it be integrated with Invoking Java Method from Action menu of OBIEE. Regards, Abinash

Hi Christian, Thanks for jumping into it, was expecting something from you. If I understand correctly, Event Triggers will execute the package only when we execute the Report. So first of all, how it would help me to automate the execution (scheduling). Regards, Abinash

Hi Gabriel, Not sure what needs to be done at formatting, but I am currently going JAVA way to create a package invoking the webservices and executing the Java class from command line. Regards, Abinash

Any luck so far?

Hey Gabriel, Thanks for your reply. That's pretty much I have so far. Though I am taking the Web Service way, I stuck at executing the web service xml from command Line. Not sure how to go ahead. Regards, Abinash

Hey, I got you very late! Is this resolved ? Regards, Abinash

Phew!! Eevrything is good with https://support.oracle.com/rs?type=doc&id=1610118.1 except while creating and mapping credential key in EM. Document mentioned to have WLSJNDI as username, but I used weblogic as username and it worked. Thanks Chris and Christian for the help!! Regards, Abinash

Hi chris, I tried everything as per steps mentioned in the Doc 1610118.1 . No luck. I am getting below errors while invoking the EJB. Any suggestions? Regards, Abinash

can you share some reference meta links for implementing this, if you have.? Regards, Abinash

Thank You Christian, I was expecting the same.

Thank You @christian!! This article is really good. Unfortunately I don't have VA license with my 12C package. In this case how should I go ahead?? Regards, Abinash

Hi Can you check your NQSConfig.INI file whether its reflecting the settings updated with System MBean Browser. ?? Regards, Abinash

Yes, I agree. But First time the server got up without any errors. then I added all the Groups i.e BIAdministartors, BIAuthors, BIConsumers. Then assigned the weblogic user into BIAdministrator. It works fine for me.

Hi All, Thanks for your help. Now the issue is resolved. I have replaced the DefaultAuthenticatorInit.ldift file with my back-up then I was able to login to Em and console. But still I was struggling with Analytics and xmlpserver login. Then I checked, the default users(except weblogic) and default Groups were not…

Hi Christian, As I am not able to login to both EM and Console, so unable to check the WLS Users and Groups and EM AppRoles also. But Still I checked in system-jazn-data.xml and all the Roles are available there. Thanks Abinash

I am also getting this error from AdminServer-diagnostic.log file [ERROR] [J2EE JMX-46336] [] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: b989a9f9cd351546:-4f729c60:159fdcf2134:-8000-0000000000005784,0] [DSID: 0000LcJGPQQ4ul__xPh8iW1O^iKb00000b] MBean…

I am getting this error in bi_server1-diagnostic.log files [2017-02-06T16:53:21.896+05:30] [bi_server1] [ERROR] [OWS-04115] [oracle.webservices.service] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid:…

Thanks @Gianni Ceresa Actually one of my team mate did all those things without having the basic knowledge of weblogic LDAP concept. Just now I got to know that even BISystemUser has been deleted. Thanks, Abinash