Hi, What product are you asking about? Publisher just execute queries, but it sounds like you are asking about a different product providing the data.

Hi, The hierarchy and the keys aren't involved in what you wanted (sorting month by number and not by name A-Z). Those were things I listed to justify why you didn't see all the "shortcuts" on your date field when it comes from a semantic model vs a dataset. To do what you look for, you should just set a "sort by" column…

Hi, just a random guess based on the process you described and the error in your log file. Can't you install the binaries in a new folder? You are renaming the folder with the old binaries, which is the same as just deleting everything before to even start the ugrade. All that just because you want to reuse the same folder…

It should be named users, not concurrent users.

In OAS you can count them also in the database where they are stored. The catalog and the other DV objects are referenced in the tables in the BIPLATFORM schema created by the RCU during install. Of course in OAC you can't do that because you don't have that access, but an export of the BAR would give you all the content…

Hi, I did hear a PM (or a dev, can't remember) say that "hidden" columns will come to DV at some point. No date was provided. There is maybe an idea to upvote about it, didn't search. My guess on why the 2 behave differently is because of all the extra metadata coming with the semantic model vs just a flat dataset. In your…

Hi, You should try asking in a forum covering OUD. But no idea if such a forum exists... This one is only about Oracle Analytics products, and your question doesn't involve any. Try looking in https://community.oracle.com/customerconnect/ , https://community.oracle.com/mosc/ or https://forums.oracle.com/ if you find a…

I don't have an environment around using that kind of authentication (and I also don't have an OBIEE around anymore, and because it's a desupported feature in OAS I can't trust it would still work like before). Row-wise initialization should still be a thing, I don't really see why it wouldn't work... But I also remember…

Hi, I would say that in general the roles 1-14 of the second step isn't really required: a user can have many roles, and therefore you don't really need to create one role that includes a unique combination of of the r1 - r7 roles to then assign a single role 1-14 to your users. Your complex requirement is somehow ...…

Please, do not double post: https://community.oracle.com/products/oracleanalytics/discussion/21204/how-to-restrict-access-to-audit-tables-in-fusion-hcm#latest

I believe you are taking the problem from the wrong direction... Publisher doesn't have a "per table" privileges feature. Because tables aren't Publisher objects. You can grant access to connections, you can allow users to use data models, but you can't grant or deny access to a database table. Because that is controlled…

The first thing to do is to know if you just want to copy a part of the catalog, a folder and all its content for example, or the whole catalog (including the personal folders). If it's the first case (that's what your original question hints at), if you have an account with the permissions to access all the objects in the…

Yes, because the "archive" generate a file, and when you do the "unarchive" you much provide the file you want to unarchive. You just have to connect to the 2 different environments for the job.

Is your question about standalone ODI or is it part of a package of products including ODI? Because this forum is fully focused on the Oracle Analytics solutions, and ODI itself isn't one of them. But if you are having an issue with one of the ODI mapping provided by OBIA, it could be moved in the OBIA category.

Catalog Manager has an archive and unarchive feature. Did you try it?

Did you get the right files and installed all the required patches? https://support.oracle.com/epmos/faces/DocContentDisplay?id=3004029.1 But as said by Christian, starts a new thread as it will be easier. And still you better go back to your FMW 12.2.1.4 installation and post a question on how to fix that error (because…

Check the link I posted ;-) Because of end of support on FMW 12.2.1.3, OBIEE 12.2.1.4 has been made compatible with FMW 12.2.1.4. It's something very recent (last month), and only to allow for FMW 12.2.1.3 to "die" peacefully while still having a solution for installations of OBIEE 12.2.1.4 (because FMW 12.2.1.4 is used by…

@User_PE6GL , You shouldn't be installing FMW 12.2.1.3 anymore these days, you should move to FMW 12.2.1.4 even for OBIEE 12.2.1.4. And, is there really a good reason to install something as old as OBIEE 12.2.1.4 these days?…

Ah, well, that error message clearly doesn't help you :P To make sure your query fully works on all the rows in SQL Developers as well, you can try to retrieve all the records of the result set. Or write that query into a new table: if there is an error you will get the details (but it's possible the query seems to work in…

Hi, If EXTRACT is the one giving you issues, why don't you replace all that piece by a TO_CHAR ? You only seem to want to format a date into month-year, to_char() can do that as you pass the format mask to the function (as long as your date is a datetime, can't remember if to_char() works on intervals...). Also, it's…