Hi, "Annoyingly" the data flows steps don't use common database operation names, therefore if there is a "unique" step it has a weird name that I missed. What you could do is to add a new column that you just set to a value of 1, then you use an "Aggregate" step where you move all your real columns to the "group by" part…

Ok, so now MCP is not a topic anymore but you are asking about the Publisher API (sounds like the thread is a moving target…). Do you want to know how to manually create Publisher objects? (data models, templates, sample data files etc.) Use the UI to create those objects as you need.

Hi, Welcome to the Oracle Analytics community and forum. You seem to have an APEX issue but you are now in the Oracle Analytics forum. APEX is not an Oracle Analytics product. You should visit and post your problem there, it's a category dedicated to APEX in the Developer Community forum.

What would you like to do with the SQLcl MCP server and OAS? OAS isn't an AI agent/LLM and can't use a MCP server. And SQLcl MCP server is also not an AI agent/LLM and can't call other tools like could be the OAS APIs. In your post you talk about OAS and then about OAM, it sounds like there is some confusion about what you…

I would join Michal side on this… @Chad Williams , if you can … don't tell your customer about the Excel export of tables and pivots visualizations in DV, because that one can quickly become more issues than benefits. As Michal hinted, the Excel export requires to run a different piece of code that expects your OAS to just…

For sure it isn't an Oracle Analytics screen, therefore this forum isn't the one covering that product. If you are using NetSuite, maybe you should check If you are using a Fusion app, then you should go to

If you only have a .atr file but not a directory or file for it, then that .atr file shouldn't exist. The .atr file makes something else existing, and defines it (it's all the metadata for the other object). Only a .atr file is the result of an issue somewhere, and shouldn't happen. From that point of view, the .atr file…

What kind of workbooks customised for NSAW are you looking for? The content shared above by Benjamin is generic workbooks, you can map them to your own data sources and use them, or just "inspire" yourself from those and build your own workbooks using similar settings. It sounds like you are looking for prebuilt content…

Hi, Welcome to the Oracle Analytics community and forum. First of all, a detail that is good it keep in mind: OAS 7.0.0 is not supported anymore, you should consider upgrading at some point… I imagine you did the usual "cleaning" of your browser, deleting all temporary files and cookies etc. If that's done, do you see any…

Hi @User_FINT4 , Welcome to the Oracle Analytics community and forum. Your question is about data, tables, related to a Fusion product, and not an Oracle Analytics product. You are maybe using Publisher for reporting, but the data aspect isn't "owned" by Publisher as it just connects to whatever source you use it with.…

Hi, Welcome to the Oracle Analytics community and forum. What is your workbook based on? A dataset or a subject area?

I saw a number of situation when bugs are called "work as designed" and turned into feature requests (even when it was obviously bugs). Sadly not much that can be done for that as far as I know, that's why the path of creating ideas can maybe help a bit. Thanks for creating this one as well :)

Like the other feature request, this one as well should be posted as an idea in . If you consider it is a bug instead of a feature request, then you should report it through a service request (SR) in .

Hi, This being a feature request, you should consider creating an idea for it: That's an easy way to have the product management team to review the request and evaluate it if if gets some supports by a number of users.

Hi @User_D2HIZ , Welcome to the Oracle Analytics community. This is a very old post that has been migrated across different platforms, it isn't going to go anywhere… Go to and use the "Ask a Question" button on the right to post a new question about your issue. Remember to provide all the required details like product name…

Your problem isn't about restricting the tables or tables content somebody can access in a Publisher data model, because that can easily be managed with common database security (as you talk about tables I assume a database to be involved). Your problem is more about Fusion not giving you the required granularity in the…

Hi, First of all a detail: OAS 7.0 is out of support… From your description there isn't much that can be said, because you are the only one having access to the logs of your environment and that can analyse what happen. You generically describe something without many details, talk about having error sometime but no details…

Hi, Did you follow the doc? The, maybe unexpected, way to create a theme is by starting modifying a default one and then save the result as a custom theme.

Hi, What release of OAC is your screenshot from? OAS 2025 is mostly based on OAC Jan 2025. If your screenshot comes from a later release, then you should wait OAS 2026 for the feature to be available. If the screenshot is from an older release of OAC, then it's possible this feature isn't available for OAS. Did you check…

If your dataflow execute correctly but shows "empty" when you try to edit it, and you tried clearing your browser cache and temp files (or a different browser) and you have the same behaviour, that can be a bug and you should then raise a support request (SR) to report it. In OAC you have limited visibility on what's going…