Hi, To backup manually takes only a few steps (~6 clicks). In global header select Catalog, select folder /Shared Folders/Custom/, select task Archive, select true or false on the 2 fields, select OK. System dialog Save As to download file Custom.catalog. Select Save. To automate this assume you can maybe build something…

Also when you add your analysis to your page you can select Properties then select view to pick a view. So you could put an empty static text view in your analysis then put on your page twice like this hard coding the empty view on the top one. Then customize the report links only on the bottom one to hide them.

Have you tried all the the styles? (on-prem you could add your own css but not in otbi on SaaS)

Using this method you can see that PERSONDETAILSPVOVIEWALL is just a basic select from one table query but only getting the current date effective date row. For some reason no query in the other log. ... FROM PER_ALL_PEOPLE_F V195095386 WHERE ( DATE'2024-02-13' BETWEEN V195095386.EFFECTIVE_START_DATE AND…

Hi, The best way to make a decision is to review the sql in each view object to decide if that is how you want your data to be extracted or not. For example, does it inner join a parent and child table so parents with no children are excluded etc. Obviously you can compare the data in each but looking at the sql is easier.…

Hi, Yes it is possible. If the data is in a subject area then you can build an analysis in OTBI or a report in OTBI using a data model with the subject area as the data source. If the data is not in a subject area then you can only build a report in OTBI using a data model with query on the the applications tables and…

Hi Vincent, Oracle Transaction Business Intelligence (OTBI) actually IS the exact same product as Oracle Business Intelligence (OBI) (suite Enterprise Edition EE). But because it is hosted by oracle in your in your Oracle Fusion Cloud Applications as a SaaS on the cloud then yes you as the tenant do NOT have access to the…

Hi Saipriya, This forum is not for product Oracle Analytics Cloud OAC (a Paas). It is for product Oracle Business Intelligence (OBI) (suite Enterprise Edition EE) inside Oracle Transactional Business Intelligence (OTBI) inside Oracle Fusion Cloud Applications (a SaaS). OAC is a different more recent product using a…

Hi, In general terms for any subject area all subject areas are designed using the same pattern of facts and dimensions arranged as a star schema to answer business question "I need measure X by dimension A, B". All queries must have a fact unless you just want a simple list of values of what is in a single dimension like…

Hi User_14HUA, OTBI is SQL. What you might be saying is that you want to know what are the physical application database tables and views column for a particular attribute in the system. As such it is good practice as suggested by the previous response to start with the presentation tables and columns in the subject areas…

Hi, If you build your template as an excel template, rather than other type of template such as RTF or online layout editor, then you can make it so that column in your excel output is data type number not text. See Oracle® Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher…

Hi, From you screenshot it looks like you are trying to do this using logical sql in an anaysis in otbi (not physical sql using a data set with one of the application database connections to the application tables and views HCM/FSCM/CRM in a data model for a report in OTBI). This makes a difference because it is a…

Hi, Did you try edit the filters you want to change at runtime from "is equal to / is in" to "is prompted" Its at the bottom of the list of values in Operator when you create/edit a filter.

Yes you have a data lineage sheet for the subject areas in each application. Go to https://docs.oracle.com/en/ then select your application then go to top task Analyze and Report then select Review Data Lineage. For example, for subject areas in Financials 23C https://us.v-cdn.net/6034893/uploads/editor/xm/vlh26pxl21qi.xlsx

Saahil, 1) But you CAN schedule using an ESS job as a schedule process an otbi "report" that uses your OTBI "analysis" as its data source in its data model to get exactly the same data as you have in your analysis that you may also interact with on a dashboard. Same data, you just have to redo the layout. Either by cut…

Hi, Are you sure it is privileges. Does the analysis you have selected have a filter? If I delete the filter from my analysis then the customize button is indeed greyed out. Anyway just in case to review privileges to your user and /or role(s) then as bi administrator go to this page /analytics/saw.dll?PrivilegeAdmin Out…

Hi Cristina, When you create your agent at design time in Delivery Content you can use Customize... to set a value for your filters in your analysis that you have deleted to deliver using this agent. Also if you publish your agent for subscription then the consumer can likewise do the same when they subscribe to the agent.…

Hi Rachel, The message you received is NOT an error message. The query you submitted to the subject area in your metadata repository database was successful. The result was zero rows. This is the expected result if you have not been setup to view data with data security. You can view the session log from your query in…

In 24A and later releases, when you export analyses results to a CSV or tab delimited file, Microsoft Excel treats the data in the exported CSV file as text. The formula characters are prefixed with the escape character (which is the apostrophe (‘)). If you don’t want to export data to CSV or tab delimited files as text,…

Hi, When I configured additional information fields that are business intelligence enabled on project the system generated, when I ran the bi extender scheduled process to update the metadata repository database subject areas to get the columns added to the dimensions, a view object just for the descriptive flex fields…