@Gautam Pisharam-Oracle ↑

Hello @shaffner and @Vaughn Sousa , thanks for your inputs. It seems there are two different topics, probably worth having two threads. Data Map layer for Zip codes : requirements/needs on detail level (how granular and detailed is the shape definition of the zip code), recency (zip codes definition change regularly),…

Thanks @Raphael Gonçalves Silva , The custom extension typically exports what the APIs exposes from the OA catalog. Unfortunately, I am pretty sure that API does not expose the history of workbook modifications - I suspect that information is probably not even stored in the webcat, probably only the last modif date is…

Hi @Brett Xue , as Ben suggested, please connect with @Miguel Martinez-Oracle , he will point you to a free shared instance where you can access OAC as a partner. As @Gianni Ceresa highlighted, this is a shared instance with many other partners so you may not be able to reconfigure the whole model. But many demos can be…

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