Thanks @User_27SWQ , let us check internally and get back to you asap. I suspect the varchar(4000) fields may be a reason for the issue but need to check. I assume this size is required by your data, right ?

Thanks @User_27SWQ for the question, can you confirm you are able to run the model (score) using SQL statement directly in the database ? Thanks @Lalitha Venkataraman-Oracle ↑

Hi @User_4RQY1, adding to @Avinash Krishnaram-Oracle answer for alternatives until this is fully supported OOB (assuming you have different columns to represent each 'level') : if your data is an RPD hierarchy, then indenting of levels in PT is already there, exp : if your data is not RPD (and hence not hierarchical…

Hi @Sathyaprakash M , I don't think you can do this in the self service data modeling, I think you can achieve it either in an RPD (semantic layer to create an SA), or else, if the need is only for one report, you may be able to build an expression filter clause for this report that is based directly on a logical SQL. Not…

Hi @Ruvina Khan have you tried creating a calculated column that concatenates the 3 original column, for exp S1||S2||S3, or S1||'-'||S2||'-'||S3. Then simply add this calculated column to a table viz and it should show you the distinct values. Is that what you meant ?

Hi @User_D0Q2E thanks very much for posting this. There has been an enhancement recently and we would like to investigate with you asap if this may be the reason for your issue. Let me initiate an email thread copying you and get back. We will post in this community thread once we have more details on the issue.…

Hi @Olivia Robles let's connect via zoom, it will be more efficient. I will contact you by email to set up a time. Thanks.

Thanks @Olivia Robles , can you try the same but removing the 'PERIOD' column in your Answers query, keep only with the fiscal period sortkey ? Let me know if this fixes the forecast behavior.

Hello @Olivia Robles thanks, this is the formula of your forecast, yes, what I meant is your query context. Confirm what other columns are part of your Answers querycontext please. Let me know, thanks.

Hello @Olivia Robles , sorry for seeing this thread only now. The function is the same in Classic as it is in DV, it should return one trend line across years. See the example below. There may be aspects to this related to the grain of your query. Pls confirm a bit more details if you query has other attributes in its…

This question is being discussed in comments from the separate thread here : How to visualize a Route Line? - Page 2 — Oracle Analytics Closing it so we don't duplicate threads on the same topic. Thanks

Hello @User_7SKM0 , thanks, the best solution for representing endpoints as different shapes is to add a distinct layer on the same map, and use end point lat long for that second layer. The map will then represent these any way you need. the question of Auto Zoom will be resolved soon : we are about to include this…

Just a thought (may not be your question), you are already positive that functionally, you don't need count distincts in your calc, right ? Technically (COUNT(CD_CUSTOMER)) - (COUNT(CUSTOMERNUMBER)) will simply show a difference of how many rows have non null CD_Customer vs how many of these rows (assuming same star) have…

Hello @Dan_Ryan-Oracle , @mgoswami Thanks. You are actually asking two different questions : 1) max size for map layers in OA, and 2) providing capabilities to consume vanilla 'online' layer services. For 1), we have just provided two distinct improvements in the product : a) in Jan update (or possibly March if you don't…

Hi @Ferdy Hermawan if you are talking about the 'Explain' feature itself, yes, it's included in any OA instance by default (no plugin or extra install). It currently works with Datasets, but we are enhancing it to support Subject Areas next calendar year. The following short videos will give you a brief overview :…

Can you share more on the context of your need, what are you trying to compute functionally ? Perhaps some of the answer may be in sourcing from a DB directly. It would help to have a bit more details. Thanks

Hi @Ferdy Hermawan if you are interested in training ML models without going throug that tuning manually, you should leverage the Auto ML capability of OAC. Check this video as a brief example for this : if not, if you need the manual process, in addition to the blogs above, this old video should still show most of the…

@Victor H , @Benjamin Arnulf-Oracle sorry for the late reply from my side. The answer is yes, these are on the roamap. We can't share ETA on it but let's hope that this will surface in 2025 calendar year. @Gautam Pisharam-Oracle and I will keep you updated with any visibility on this thread. Thanks

Hello @Stefano_Mazzocca , if you click on the tab 'layers' right next to numbers, you will find the option for data labels position on map layers, see pic at the bottom below. You can also check this video describing the feature. Let me know if not what you meant. Thanks.

Hi @User_C8Q91 I am assuming you are using a canvas in Oracle Analytics (not a Classic Answers Analysis). To see full polygons of zip codes, you first need to upload a geojson file with the definition of all these polygons. Such as file can be found on the net, and you upload it in the system console/map layers only once…