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…

@Philippe Lions-Oracle and @SteveF-Oracle , I don't know how to reproduce the generation/saving of the wrong JSON in the GUI, mostly because I don't know at what point it went wrong with all the other issues I had yesterday, and how I managed to do it. Being a customer's environment, I don't have the permissions to raise…

Hi, What product are you asking about? Because you posted in the Publisher category, but your question isn't about Publisher, it's about data. Data is probably part of another product, and maybe made available in Publisher through a number of prepackaged reports or something like that. Based on your answer the question can…

And the answer is ... a "corrupted" DV workbook JSON, but not corrupted enough for the tool to see it and report it as broken. I can't explain how, why, and how to reproduce, but the DV workbook JSON for 2 of the 30 columns I needed in that table, contained the same "columnID" twice, pointing to presentation columns (the…

What product are you talking about? Because you link to some kind of content, therefore it isn't "just" Publisher, you should be asking about a different product providing a number of pre-packaged content with Publisher.

Please avoid multiple posting for the same question: https://community.oracle.com/products/oracleanalytics/discussion/21163/max-aggregate-returning-multiple-rows#latest