Hi @Albion Inmate , The BI Service Administrator role (or an equivalent one) is required.

Hi @User_ZEJQU , AFAIK it's not possible to protect a Publisher data model with a password. As a workaround, you could implement the logic behind your data model (e.g. the physical query) directly in the database as a (materialized) view. In this way, none will be able to view or edit the logic of your model using the…

Hi @Albion Inmate , You can delete/pause Publisher report jobs as follows: Login as an administrator to the Classic Home page Click on the Report Jobs link on the left-hand side of the page Enter the username of the user who left the organization in the Owner field, and click on Search Select the report job(s) in the table…

Hi @K_Hoffman_gdit , I'm not aware of any plan to support XLSX template files in BI/Analytics Publisher. I suggest to submit your idea to Oracle (it will be voted by users, reviewed by the product management, and eventually implemented as a feature):…

Hi @User_C4E8V , Which version of OBIEE are currently using? Did you restart the full stack after changing the domain name? As @SteveF-Oracle suggested, it would be great if you can share the procedure adopted to change the domain name. I noticed that the UID session variable has no value definition. Has it been defined as…

Hi @User_INRAO , AFAIK there isn't a variable related to the data model name. You can pass a constant string with the name of the data model.

Hi @User_3N5E8 , The Slider filter type does NOT allow to select multiple values or specify a range of values. You should use the Range filter type instead. Please note that this filter is available (and used by default) when the column that you are using to create the filter is treated as a measure. The Range filter type…

Hi @Phoebe Chen , Since your last question is quite different from the original one, I suggest to start a new topic for it. It would be easier for people with the same issue to join the conversation, and for you to get an answer!

Hi @Manu R-Oracle , You have to use the ATTRIBUTE function (as in the example I shared above) to transform the output of the RANK function into an attribute at your desired level of granularity. This one should work as expected: CASE WHEN ATTRIBUTE(RANK("Financials - AP Transactions"."Facts"."AP Cleared Invoice Amount…

Hi @Manu R-Oracle , There is something wrong in your Supplier Name calculated column. Could you please share the expression that you are currently using? As I can see from the screenshot, it has been treated as a Measure (yellow icon) , hence it will always be aggregated and you will loose the detail that you need.

Hi @Phoebe Chen , To preserve the original owner, you have to select the Create option from the ACL menu when you unarchive the report in the target environment. To set the ownership of an existing report in the target environment, you have select it, click on Permissions, add a user, tick the Owner radio button and click…

Hi @Phoebe Chen , The owner of the report should be the user who saved it to the catalog. Did Naomi create the report on a different enviroment and then move it to the target one (where the owner is different) using the archive/unarchive feature? If so, based on the settings applied during the process, the permissions may…

Hi @Manu R-Oracle , To achieve a similar report in Classic you can use the following calculation: CASE WHEN ATTRIBUTE(RANK(<Measure>) BY <Attribute>) <= 10 THEN <Attribute> ELSE 'zz-Others' END You have to replace <Measure> and <Attribute> with your Payment Amount and Supplier Name columns. The calculation will display the…

Hi @BASWANTH , In order to help you, it would be useful if you can share more details/screenshots about your parameter (e.g. how it has been defined, and how it has been referenced in your data set's query).

Hi @User_INRAO , You can add a before/after event trigger to your Publisher data models: https://docs.oracle.com/en/middleware/bi/analytics-server/design-publish/add-data-and-data-triggers.html You can reference the values of your parameters, the user executing the report and other user information stored in system…

Hi @User_BZ5TP , Which version of Publisher are you using? If you are using a recent on-premise version (OBIEE 12c or OAS), you can track changes to the value of the MONITORING_ENABLED property in the xmlp-server-config.xml config file located in the $ORACLE_DOMAIN/config/fmwconfig/biconfig/bipublisher/Admin/Configuration…

Hi @User_GB2K0 , Could you please specify which tool (and version) you are using to create/run the report?

Hi @abRoman83 , AFAIK it's not possible to make the Excel output file read only out-of-the-box. You can either make it read only (manually or using a script) before delivering it to your users, or you can use the PDF output which allows you to make the output read-only (you have to update settings in the report Properties…

Hi @User_03C7Q , AFAIK there isn't any capacity planning guide for Oracle Analytics Server. Please refer to the following documentation to understand the minimum requirements for deploying Oracle Analytics Server:…

Hi @Dan Vlamis , AFAIK it's not possible to produce the Repository Documentation directly from the Semantic Modeler. You have to export it as RPD file and use the Admin tool. From the Semantic Modeler you can use the "Show Lineage" feature on a given object (e.g. a presentation table) to display a diagram with the lineage…