@User_BG3UK This is a 8 year old thread. Please post your question as new thread instead of tagging to this one which is resolved. Thanks Gayathri

@Mirithu "If I use a Table visual, I am able to show all customers and their order amounts, and if I apply the filter "ORDER AMOUNT = 0", I can display only the customers with zero order amounts (as in the image provided). "=⇒ How are you defining this filter , can you show screenshot? If Order Amount is a measure you can…

@Krishnamoorthy Rasappan-Oracle We have Identity Domain setup and the App under Identity Provider is a hyperlink and takes you to the right Cloud Service location under the Identity Domain.

Hi For your first requirement you can try creating a calculation with formula like : AGGREGATE(COUNT(id_unique) BY customer_number) Thanks Gayathri

You need to create a Workbook for blending and not use classic analysis reports. File based datasources are only supported in datasets, they are not supported for rpd/semantic model. Check supported datasource doc here : Any blending between subject area and file based dataset has to be done using workbooks and not answers…

Not sure I completely get your question but would creating calculated column with formula FILTER(<measure> USING HOBBY='Darts') or FILTER(<measure> USING SEX='M'),etc. be an option to get this kind of data? Other comments welcomed. Thanks Gayathri

Please check Blend Datasets documentation : Datasets that use Oracle Essbase or Oracle EPM Cloud connections aren't available for blending. And blending of datasets is for workbooks. for classic you can add content from other subject area based of the same BMM. Thanks

@Philippe Lions-Oracle Wondering if you have any existing material/pre-built content for Power BI vs OAC value proposition that can be shared with Saroj?

@Etaylor3 I see the following Idea Lab request with this ask , so please upvote/add comments to existing idea lab : Encrypt emails and all attachments generated within the OAC (Emails generated from Agents) Also any related question to this, kindly post as separate thread as this is almost a 4 year old post. Thanks Gayathri

Hi Based on supported data types documentation, json is not a supported data type. It might be a limitation that we don't support json functions either. Seems like a candidate for idea lab request. Other comments. welcomed. Thanks Gayathri

As initial step, check if the oas oci vm hostname is resolvable from the windows server. I see you are launch /dv using IP address . If you use hostname instead (presume its oas.sub06191440320.datasciencevcn.oraclevcn.com) are you able to reach the /dv endpoint? Or you could also try nc -zv…

In addition to above, please also review the following KM doc to validate the host:port for different endpoints in OAS: How To Check Your Oracle Analyitcs Server (OAS) URL Endpoints (Doc ID 2895594.1)

@Sambasivarao Manam Follow exact steps that is documented. You should not be creating usage tracking tables manually. Just create connection pool and let the system do the rest. If you still face issue, post all the steps you did, without this we cannot assist you meaningfully.

Hi Do the usage tracking tables get created fine? Is issue only with data not getting inserted? If the tables are not getting craeted, validate the connection pool info provided in system settings. Make sure the database user used has proper privileges to create/insert data. Did you modify anything in the RPD connection…

One option could be to embed OAC report in their custom external application and view content. Check

Hi The connection pool screenshot does not show the full connect string, so unable to validate. But if your console > connection and data > connection both are working you can try the following: Set Externalize=True in rpd connection pool Provide connection name as console > connection name you created (assuming console >…

Max rows exported to formatted reports for a classic report/dashboard is set to 1000 for a 1 OCPU instance. Based on your description that you are hitting 1000 row limit, I presume you have a 1 OCPU instance. If yes and If you are running a production workload, its strongly recommended that you scale up your OCPU. The row…

Hi You can explore setting filters at the dataset level for the relevant tables .Check - Thanks Gayathri

Does this output look correct? Thanks Gayathri

In addition to previous points, check the biserver-diagnostic log to see if there are any timeout errors from one of the plugins, similar to "Internal error has occurred: IO Error: Socket read timed out". If upload task is taking longer than 2 mins there is a chance it will timeout and fail. It might be a separate issue to…