Hi Praveen, That is the expected behaviour. The "report" components on the page are ignored. My opinion, is that the previously known as "XML Publisher" renamed as "BI Publisher" product was merged with "Analytics and Dashboards and Delivers" product acquired from Siebel who bought it from NQuire and another product for…

Hi, You need to do nothing in an analysis. That is the point above. Data security is "build in" our of the box in RPD. The subject areas in the metadata repository database will implement row level security on your behalf. For example in subject area Expenses - Expense Transactions Real Time" the system will automatically…

Hi, my instructions are how to do it in a report in oracle transactional business intelligence (OTBI). Cheers, Nathan

Hi, Here is a method to reuse the row level security already implemented by oracle in the metadata repository such that users use the same report will only see the data rows to which they are setup because the database will add where clause to your query at run time to implement data security. So the design is to add a…

When you selected the content did you select a dashboard or a page on a dashboard? If you need multiple pages then first build a briefing book with the dashboard pages you need then use that instead of only one page?

Hi Mirzda, The answer from Bhaskar is how you schedule a dashboard. The "scheduler" for analysis or dashboard is using intelligence robot "Agents" in product "Delivers" which are the "green" icon if you select menu "New". You do not select a dashboard then use the context menu to schedule like you do a report. You instead…

Yes for most job roles it is possible to copy it to a custom role then remove stuff to make it a "View but not Do" role. So you remove all the privileges that allow a user to do things like insert, update, delete transactions but leave behind the privileges that allow user to use the manage screens to view data and use the…

Assume you want to put a function around the presentation table column you have selected from your subject area. Sounds like you need a sub string function on a text attribute column. Anyway to edit a column in your analysis select Criteria, expand pane "Selected Columns", hover over the cog icon on the column under…

Hi, When you say "OTBI reports" we are assuming you mean an object of type "Report" (yellow) (not "Analysis" (blue)) "We are not giving BI Consumer role and BI Admin role both to that User" Yes that is ok. But if you have granted a user "BI Author Role" then your user is a "BI Consumer". You do not need to grant "BI…

Hi. From our development environment we extract folders and files as .catalog files from the catalog then store these in a version control repository (like GIT but other brands are available!). Then we unarchive to the target test/production environments from source control. So you get multiple versions over time with some…

Hi Scott, So to confirm what is in or out of a subject area you can view the data lineage mapping the presentation columns you use to physical columns in the application database extract from teh metadata repository database (RPD). Cheers, Nathan From the doc…

The analytics in oracle cloud applications is no longer oracle business intelligence 11g. As at the latest quarter release 22A it is now upgraded 12c. The latest 12c documentation is here https://docs.oracle.com/middleware/bi12214/biee/index.html

Hi, So getting a query to work as you expect it too using multiple subject areas is hard. As a "rule of thumb" you need a column from a fact along with only columns from dimensions that are shared by those facts in both subject areas. If you do not have the correct columns then it will go "pear shaped". Take some time to…

Hi, So when you write an "Analysis" this is "logical SQL" in form "select presentationtable.presentationcolumn from subjectarea". When you the "Query Client" run your analysis from "Presentation Services" you submit your analysis logical sql to bi you are querying the metadata repository database also known as the RPD…

What does the raw data look like. select all 0 s_0, "Workforce Management - Absence Real Time"."Assignment Absences"."# Of Absences" , "Workforce Management - Person Real Time"."Person Work Permit"."Visa Permit Type", "Workforce Management - Absence Real Time"."Absence Type"."Absence Type Name" , "Workforce Management -…

This user is just a "BI Consumer". To be able to get the other types of objects the user must be granted a job role that inherits role "BI Author Role" and/or "BI Publisher Data Model Developer". Alternatively create a custom role with one or both of these roles in it then grant that to your user. To manage roles for a…

Hi, One solution is to use instead the pre-defined report provided out of the box to give you a list of users and roles for audit purposes. Or at least compare your query to theirs to debug what joins you are doing differently to make it soooooo slow. Maybe start again with copy of out of the box extend that to plug any…

A.Josh, "Is there a way to limit OTBI Dashboard Prompt values based on security" Yes. DO NOTHING! This question assumes that a dashboard prompt has no data security. But a dashboard prompt DOES have data security. It does not bypass security in any way. It is just a logical query the same as any other analysis. Your basic…

Hi, If you have the correct application database physical sql on the tables and views then you are half way there. OTBI is part of your SaaS. OTBI is software and platform, the software bit (the "T" in OTBI if you like) is the package of pre-build content including the subject areas metadata repository database (RPD) and…

Hi, Yes with oracle cloud applications our oracle business intelligence OBI is stuck at the older version 11.1.1.9. OBI is a suite of products. BIP is one of the products in OBI. Here is the docs for OBI. https://docs.oracle.com/middleware/11119/biee/docs.htm Here you can fid a Java API for BIP…