Glad it works. Everything that can be done "graphically" has a "code" equivalent, it just isn't as direct as a click on a chart (could be interesting if there was a "generate code" option for those things).

You could also consider BottomN, but that's an aggregation function and because it does remove the records not matching the "n", no idea how it will behave in a data flow, and you maybe don't want to lose the other records. Also keep in mind RANK assign the same ranking to the same value, you will still need to handle…

You have an "annoying" data type for this… (a date, with a number it is a bit "lighter"). The LSQL rank function works only in that way, in descending order, and doesn't have any flag or attribute to change the behaviour (at least nothing that has been documented in the past 15+ years). Therefore you need to cheat, and use…

Do you need RANK to start with 1 or you just need the order given by RANK? This depends on your planned usage of that column value…

And that's what ideas are for (or your own internal channels inside Oracle):

And follow instructions given there to to connect.

You come from OBIEE, nothing changed in OAS on how the RPD/Semantic Model is handled. In OBIEE you had a single RPD at any point in time, it's the same with OAS. You can create multiple semantic models with the web-based Semantic Modeler in your single OAS, that's not an issue, but you should not deploy any of them if you…

Hi, Your question seems to imply some common data structures or models. Publisher as a tool doesn't contain any data. What product are you talking about? If it's some data available by default in another product (Fusion apps etc.), you should consider asking in the forum covering those products, like for Fusion and co. If…

Hi @Julianne , Did you try using the forecast function as in expression? I just added a table visualization in a workbook, added product, date, revenue and quantity and then added 2 calculations with a forecast for revenue and quantity. As you can see the forecast is at the product level, each product has its own forecast.

I fully understand that it is quite a challenge to find the right place, mostly when the question covers various aspects, that could in theory be spread across various forums. I believe starting from the Cloud Customer Connect should be the one being the main place to cover your question, and maybe from there you will then…

I'm now quite sure you are in the wrong forum. Oracle AI Agent Studio is a Fusion product, covered in a separate forum: Doesn't look like you are using an Oracle Analytics product. In that other forum there are also categories dedicated to Digital assistants and chatbots linked with Fusion products. Lastly, for the generic…

Hi @User_T4H93 , Welcome to the Oracle Analytics community and forum. I suspect you are in the wrong forum, what product are you using (a full name, and a version would help)?

Your question being about NetSuite data, it isn't exactly in the best place as it isn't a technical question about an OAC feature. I believe at some point there was a NSAW category here, but I don't see it anymore. I would have said you should post this in the NetSuite community, but you already did:

Hi, Welcome to the Oracle Analytics community and forum. Your question doesn't sound like it is about an Oracle Analytics product. If you have a data question about Oracle Project Management, that should be covered by the parallel but independent forum Cloud Customer Connect: The tables you mentions seems to be related to…

Hi, Have you considered posting this as an idea? That's how you can suggest new features or other things to be implemented in the product. I'm not moving your post there because Oracle product managers have a workflow in place on how to handle ideas, and I don't want to mess with that.

Please do not double post, your previous post on this already has a reply, stay in that thread.

Hi, You should ask in the forum covering your Fusion ERP, because it's a data question and not a technical feature of Publisher. It is a parallel and independent forum, covering all the Fusion products, including their data sources (queries etc.) and analysis:

Hi @User_786CW , You posted your question as reply to 2 threads that are already a year old. It would be better if you post it as a new question, and you provide all the information for others to understand your situation without having to guess what has been done or not. Useful information are the products involved, their…

As said earlier by Ram, you can use your LDAP groups in OAS. But you still need to make a mapping job in OAS itself (Fusion Middleware EM, or via WLST scripts). Because the security in OAS is based on application roles, therefore you still need to map your LDAP groups to application roles at some point. What you can do is…

currently supports only basic or token-based methods If you say that in Data Gateway you can only use basic or token-based methods, you shouldn't ask how to authenticate using OAuth 2.0, but you should ask for that feature to be implemented because it isn't available. For that you can post an idea (or upvote an existing…