@Saroj Kumar Behera i agree with @Gianni Ceresa best way get the physical query from log session and try to execute in your DB side using SQl Developer or any other tool engage your DBA to make sure all of your joins correct plus data validation in sample group of data in your DB Tables

@Jeny Francis-Oracle I have couple of questions to make sure i understand the issue fine 1- After you sent via e-mail you attach the dashboard as Excel format is that correct ? 2- after download the dashboard does the link works even if its masked or give errors ? 3- I am assuming your SMTP Server is Oracle OCI E-mail…

@Daniel Vornicu I would suggest to create a calculated item to substring the output of Question1 , Question2 and so on and use it in your chart that will be easy to use

@paamikumar From logs I can see that your nqsserver was crashing till May 6 also I can see some query cancelled After 48 Minutes of running and also you mentioned you switched to exadata DB and issue start to happen adding all these facts together I can conclude that your nqsserver may get into hang status from time to…

@paamikumar from logs I can see that your NQSserver used to crash till May 6th also I can see some queries taking up to 48 Minutes and you mentioned that issue starts to happen after you migrated your Database to exadata so from all these facts I can conclude that nqsserver go into hang status from time to time which lead…

@Rajakumar Burra "Pin to All Canvases" will work only in visualize View and Not in Presentation View you can file SR to ask to remove this option in presentation mode as I believe this could be a defect. The alternative is to use Data Actions between canvases will give you same behavior you looking for

@Kristian B. Joergensen run the following command cat /etc/redhat-release This will show which Linux Version you are in

@Mirithu please check above☝️

Attached the Calculated item used to get the results let me know if this works for your environment

Please check the following 1- Do you see Stuck Threads in Weblogic console under the bi_server1 threads ? 2- do you see a lot of inactive session in DB Side? 3- Do you have any monitoring Tools installed in same Server as OAS ? 4- When issue happen do you check nqsserver process if it in hang status , use stack command if…

@Muhammad Shoaib what is the value of "cookie-max-age-secs" in Weblogic.xml file ? did you make any changes in analytics.ear file ?please check ID 2401492.1 can you reproduce the issue and attach the .HAR File

@Christian Berg will provide the formula and all steps once @Mirithu confirm that screen shot meet his expectation because it will be confusing for other users who looking for same to check the formula blindly without confirming the solution from the requester

I make this works for you please have a look to the following If this is what you looking for let me know and I will send you the workbook and you can use it in your project

The problem that your "CUSTOMER ID" is a dimension and not a Measure so you can try to Use CAST Function with the "CUSTOMER ID" Column to Double and re-Test your equation. If the source identified CUSTOMER ID As Measure your calculation will work

@Muhammad Shoaib looks you implemented steps in Security Integration of OBIEE 12c/Oracle Analytics Server with Oracle E-Business Suite (EBS) (Doc ID 2825669.1) What connectionWaitTimeout & oracleNetConnectTimeout Values had been set in LibOvd Adapter XML ? Please be aware any changes in the Adapter will require to delete…

what is the other option your client want like send direct URL to the report what could be other options in your client prospective ?

This will not work in data visualization according to known bug : 34982574 But you can try the following workaround it may work 1- Install R and R package according to the following OBIEE 12c documentation in OAS7 .1 Installing R and R Packages 2- Make Sure The obiee.Regression.xml file is existing in following directory…

Are you getting Error Like Failed to download metadata for 'USERID'.'obiee.Regression'

@User_2QQI0 can we get more insights on your requirements here ? What is limitation in dv for 1000 lines? is that Dataset file-based ? if we get more details we can suggest best Options for you I hope you elaborate more about the requirements so we can help

@Matjaz Zupan Please have a look to This can be turned to match your use case tested with smiliar user case and worked