The full out of the box solution is to export the BAR, extract it and use the catalog manager in offline mode (to not enforce security) and then do a full catalog search for the path of your saved filter. You will find all the places where it is referenced. If you work online with catalog manager you will be limited to…

Hi, Shouldn't you be asking this in a Fusion forum? Because it isn't really a Publisher question, it's a Fusion question... Fusion products are covered in a parallel forum: https://community.oracle.com/customerconnect/ There are many categories, have a look and identify the best place for your question.

Ok, in the future for SQL questions you should consider posting them in https://forums.oracle.com/ords/apexds/domain/dev-community/category/sql_and_pl_sql (it's a separate platform but still a fully Oracle products/services focused forum). What data type is your source? "date"? The data type is able to have the time…

Are you asking about a Publisher feature or is yours a pure SQL question? A column of type date, doesn't have a format. The visible format of the date is always a formatting "like a string". There is a default date format mask that is used by the tool you use to view the data.

@Niyati Mehta , You are asking in an abandoned 7 years old thread that was about something else. Your question seems to be about how to do something in Fusion, if that's the case, you are in the wrong forum. Fusion products are covered in https://community.oracle.com/customerconnect/ (look at the many categories available…

@User_HQ9TE , Isn't this one the same as https://community.oracle.com/products/oracleanalytics/discussion/21032/if-create-calculate-column-it-will-automatically-affected-another-measure-column-in-report#latest ? You marked the other thread as answered randomly and not ask about a piece of SQL. But that query isn't…

Ok, so back to your test case: you now have a user that, thanks to the DV Consumer role, can open the workbook and see the various visualizations inside. Now that same user is opening a dashboard and while you can open it, the content is blank. What is the "dashboard"? Is that a "classic" dashboard (from /analytics ) ?…

Security is a serious thing in Oracle Analytics: a security model can be extremely complex because it's meant to be an enterprise platform. If you don't see data, it's once again because of security. But nobody else than you has that environment available and know what the security model looks like. Adding your new user to…

Depends if you want to change it... MUD for the RPD will still be the same and work the same for a few years. But if OAS 2024 comes with the new Semantic Modeler, and that your RPD is fully compatible with the Semantic Modeler, you can plan to move to that and adopt a totally different way to handle parallel development of…

Didn't fully read all the details as it sounded like most was about guessing what version you have. It is defined you have Oracle Analytics Server, the version is still unknown... You have an issue when opening DV with a new user. It sounds like you have been messing around the "classic" permissions, there is nothing in…

Oracle Analytics doesn't generate numbers randomly, every single number has a reason. How does that number get to your screen? You analysis generate a LSQL query (the columns you selected, the formulas you enter), this is translated into a query the physical source can understand based on your semantic model (rpd). If you…

The WebLogic lightweight LDAP isn't designed to provide that feature, mostly because OAS is mostly connected to the corporate AD or LDAP and therefore doesn't "own" the users. You can develop it by using the MBean. This blog show how it was done in 11g:…

That function doesn't sound like a standard Publisher function. Is that related to some other product? If yes, providing the name of the product increase the chances of a reply. If it's related to Fusion, you should ask in the forum in charge of Fusion: https://community.oracle.com/customerconnect

@User_BETTV , What is your product and version? If not OAC, did it ever work before? Is that a new environment? Is that an upgraded environment? What security model is your Publisher using?

@Dawn Watson , OAC doesn't have anything like a "universal banner". As mentioned above you can build a dashboard/workbook where you display that info and that's where all your users are directed after a login. It will add an extra "click" to go back to homepage for users to start doing what they connected for.…

Do not hijack your own thread. This question was about uploading a folder, and it already moved into how to migrate Publisher reports from an old OBIEE to a new OAS. Users have nothing to do with uploading folders... Keep in mind this is a community forum: the content is meant to help everybody and not just yourself (that…

Hi Kristian, First I must say that I don't use the dataflow joins because "they don't speak sql"... (Keep rows, Input 1 "All rows" or "Matching rows", Input 2 "All rows" or "Matching rows" : call that thing what it is, inner join, left outer, right outer or full outer join). I generally do this job in the database... I…

@Jay Chandran , Your question has been moved to the OTBI category referenced by Rajesh, no need to post post it again (it isn't not a sister community, it's the same one, while Cloud Customer Connect is the sister community).

If Publisher is integrated with the Oracle Analytics Server, then use the archive and unarchive features of the Oracle BI Presentation Catalog to perform this function. Pay attention to the details in the doc like this one above, and then evaluate the best strategy for what you are trying to do. You are doing a big jump…

.xdrz files is the format you get from Publisher when you export a folder, you should upload it via Publisher. Are you trying to migrate just Publisher reports? Or are you trying to make a full migration of a full OBIEE 11.1.1.7 to OAS 2023? Because it isn't really as simple as getting a file on the left and uploading it…