Hello Gianni, Yes you got it correct what I am taking about is the Path which we is visible in GUI and actually saved on Disk are different But they represent the same thing. My main concern is that if someone give me list of objects having the path listed as it is visible in GUI, how one can get the corresponding list of…

Hello Experts, Sorry for late response....yes it was an issue with SMTP server. Firewall was the issue. However, issue has been solved by firewall server team. Thank you for support. Cheers!!!

Hello All, Thank you for your reply and sorry for my late reply. Requirement is to mask the data as the GDPR regulation. We have user-id which are present over there who has scheduled the report in agent and we have to mask the user-id. I know that if we change the user_id to some masked id then it will give the error as…

Thank you Christian for clearing my doubt.

Thank you but do me a favor, if you write such code please post it publicly I will be the first person to implement that code via - save content with HTML Markup code on dashboard and BOOM!!!

I totally agree with you Gianni that this need to fix from backend source system end.

Thank you, I will try all the options mentioned above and let you know the findings.

Hello Joel, We have tried to sum by customer_id, but problem is it will give me two records when we pull customer_name in the report. Its working without customer_name, but client want any single customer_name (eg:- 1 cust_id, 1 cust_name and agg sum). Actually you are correct that fixing it sourcing side and we have raise…

So my complete prompt look like Here Month is showing default value as Nov 2018. Now if i select region as Europe then Month value is showing as "select value". Also month prompt has following configuration:- SELECT "Departure date"."Departure month year" FROM "Dispatch Logistics" WHERE year("Departure date"."Departure…

Also I would like to add, there are few more prompts like Division, sub division, Region etc, but let say if I select the value of Division = 'Automobile" and Region ="APAC" still the value of Year and Quarter default prompt doesn't change but Month prompt changes to select value.

Hi Robert, Yes, it has been set on Quarter and Year prompt mentioned above

Hi Robert, I am sorry but I am not able to understand the solution. However i would like to explain in more simple way, I guess i was unable to express the problem more clearly. I have 5 prompt based on Region, Sub-region, Year (based on Dispatch Date), Quarter (based on Dispatch date filed), and Month-year Short filed…

I have asked the same question twice, so we can close it. Sorry for all the trouble. Cheers.

Hello Robert, We have created the Oracle SR related to OBI set operation failed due to incompatible sort order. However thank you for your kind support. Thanks & Regards, Abhi

Thanks Robert, I was on leave for few days just came back back.

Hello Robert, The problem is solved, I have checked the customization page and learnt that it was due to the same. Thanks & Regards, Abhishek

I have raised an SR with oracle and learnt that its a OS platform issue on which OBI is running.

Hello Robert, I have created it from backup - no other option left . But it working now. Thanks for your help

Hi, I tiried to fix the issue but getting the below error now. JAVA_HOME issue is solved but getting below error C:\Oracle12.2.1.3.0\bi\bitools\bin>call C:\Oracle12.2.1.3.0\bi\bitools\bin\\..\..\bifoundation\web\catalogmanager\runcatinternal.cmd "Temporary Worskspace :…

Hello Christian, I tried to install the Java into system and got into the program file. java version "1.8.0_161" Also I tried to set the environment variable with JAVA_HOME = C:\Program Files\Java\jdk1.8.0_181\bin but its giving me same error. I guess it related to something called as even I tried to run the below command…