You are welcome Richard :) More than a rule, it is to get you the best support: here there are people who did use Publisher on HCM tables, but it is only a fraction of the users. On the other forums everybody should have a knowledge about those tables. Should be faster to find your answer.

Hi, Your question being about HCM data and not Publisher as a technical product, you should ask in the forum covering HCM and other Fusion applications: https://community.oracle.com/customerconnect It is a parallel, but independent, forum that covers all Fusion applications and other cloud products. It has many categories,…

You can find the CPU for OAS and OBIEE 12.2.1.4 at https://support.oracle.com/support/?page=sptemplate&sptemplate=km-article&documentId=KA973

In your picture, for one "P Number" you have many "Line Number" (7 in your picture). You seem to be saying that your expectation was to see only 2 "Line Number", values 10 and 20, and "Line Number" 10 should have a "Quantity" = 1 and "Id" = …R00814, while "Line Number" 20 should have "Quantity" = 1 and "Id" = …R02981. All…

Extending on what Henry said already, if you don't have a join rule error (check the query generated and you will be fixed), then it's all about granularity. If that quantity and id is linked to 2 different line numbers, what you see is correct, because you requested to see each line number individually. If that quantity…

Hi @Rasta Ghafouri-Oracle , As this is about the challenge, can you handle it? (moving it in a better location if needed or finding somebody to support @User_DDCRE )

@Tony_OAS_Apex_User , If you want to define a connection to an Oracle Database in DV, use the "Oracle Database" connection type, that's the easiest way to connect to an Oracle database (compared to ODBC). If your Publisher data model should be a query on an Oracle database, the best solution is to define the connection to…

Hi @User_C1R2A , It's better if you post a new question explaining your issue and providing all the details about your environment. This question was solved with the answer explained above, a cluster wasn't involved and it was a clean install, not an upgrade.

Ah, wait, I may have misread the question in the first place. So, you are looking at using a variable in the "note" field, not that the content itself of the agent should be referenced with a variable, right? That could have more chances in theory, but I'm not sure if the execution of the agent has a full session context…

Great to hear your UNION ALL is happening. The fragmentation rule is mostly because I'm "allergic" to any form of warning in the semantic model. Even if not a formal warning executing a consistency check, the BI Admin tool still warns me that I have checked the checkbox but didn't set a fragmentation rule. This is maybe…

Welcome to the Analytics and AI community. What Carter said :) Without more details, the only valid answer is: look at your logs, everything is there. You will find where time is spent and from there you will be able to take actions to work on it.

What is a "OAC Report" for you? Is it a DV workbook? Is is a "classic" object (dashboard page or analysis)? Or maybe a Publisher report? How did you embed it? (what guide or process did you follow?)

An ODBC connection is usually not an Oracle Database connection (you have dedicated connection types for that), therefore the tnsnames.ora isn't involved. What are you trying to connect to?

Historically in the catalog every path is a static absolute path. No relative paths, no variables, no nothing. I imagine your request is maybe related to your own catalog structure where you have the content used in the agent in a relative path to the agent (same or sub-folder). In such situation a relative path, or a…

I did just a quick test with OAS 2025 (I don't have an OAC I can freely change the semantic model) to be as close to the current logic. I also only tested with 2 tables from the same database to not have to create a new account (will do that if you report it still not doing a UNION ALL). In your 2 logical table sources…

Give us anything newer than Java 1.8 and you can even call it fUsIoN middleWARE 😉

Ok, you are using OAC, right? (if OAS, what version?) Is this table used as dimension or facts? Just to give it a try with something being as close as your case as possible. The "annoying" part is that it comes from different databases, therefore the BI Server will need to do all the job. I hope it isn't too much data, or…

The message you got is for WebLogic itself, but you aren't using WebLogic itself, you are using it as part of your OAS stack, and therefore the support of OAS will also cover the required WebLogic, you don't have to worry for now. Right now, waiting to see what OAS 2026 will be like (what FMW is it based on), is probably…

OAS 2025 (8.2) is supported for at least 1 more year, probably till March-April 2027 (the end of support depends on the release date of a newer version). Because OAS 2025 requires FMW 12.2.1.4, this will be supported for the whole time OAS is supported. OAS follows a yearly release cycle. It is usually released around…

Hi, This post was in a very strange category, and therefore I believe nobody saw it for the past 2 months. It has now been moved to the OAC-OAS category. If you are asking for a new feature in OAC, you should consider posting an idea in https://community.oracle.com/products/oracleanalytics/categories/aidp-idealab