Hi, Both are possible. You can implement row-level security to filter the data each user can see based on who they are (their role in your company, their department etc.), it's filters that will be added to every query by default. And you also have permissions at the subject area level, who can see them and who can use…

Isn't that the OAC client? Where did you find it? When I follow the link I see only the one published in March… The client tool for OAS and OAC should not be confused. The OAC one will probably work for most of the things, but it isn't designed that way… (you shouldn't use the OAC client for OAS) The OAS client tools does…

Hi Adam, The client tools are usually not updated, except if there is a real major issue found. It is also not something you patch like you do on your server, the client tools is a full install all the time and not some files replaced here and there with a patch. I believe I remember some time ago the Model Administration…

Hi, The OPatch I use comes from https://support.oracle.com/epmos/faces/PatchDetail?patchId=28186730 For my OAS 8.2 I have a note telling me to use 13.9.4.2.11+, and from that link I take whatever version it gives me (right now it is 13.9.4.2.20). As you can see it says explicitly it is for "FOR EM 13.5 AND FMW/WLS…

There was a comment by @Karthi_obiee , that has been deleted somehow, saying it wasn't working also with the default value. That's why I said "it has a chance to work": maybe it would, maybe not. But as implicitly said by my original answer, and explicitly said by Gayathri, the key point is if it does work once you…

Is this an issue? Not seeing the data while inside the RPD doesn't prevent you to model your sources and develop your RPD. Technically, a session variable exists when there is a session. When working on the RPD there isn't a session like you would have if you login in the front end. That would explain why you get the…

Hi, Welcome to the Oracle Analytics community and forum. What you are asking is a common requirement and is usually achieved by implementing row-level security on your source. How to achieve it depends on what your source is: dataset or semantic model?

For up-voting, it is here: https://community.oracle.com/products/oracleanalytics/discussion/26791/we-should-have-way-to-output-unique-rows-from-dataflow Overall, if you have large datasets that makes dataflows to fail, it is maybe a sign you are pushing a bit too much. In my opinion datasets and dataflows are for small to…

What Steve and Michal said: didn't have any issue with it with default authentication.

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 https://forums.oracle.com/ords/apexds/domain/dev-community/category/apex and post your problem there, it's a category dedicated to…

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 https://community.oracle.com/netsuite If you are using a Fusion app, then you should go to https://community.oracle.com/customerconnect

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?