Hi, For the first view object I think the additional information fields column(s) you are looking for attribure[n] do not exist - nothing to find! List columns in business intelligence cloud connector /biacm/ to get data lineage then view log from query all columns (you can do this because this object is used in the…

Hi Dilip, You do NOT need to assign the duty roles. The duty roles are inherit by the job role. Revoke the 3 duty roles you have granted then from the list for this subject area grant the required job role(s). The job roles are required because they contain the data security that give access to data. But as suggested by…

No data found because where X = A AND X = B is always FALSE Option A - click the and to change it to an OR (and click it again to change it back again) Option B - multiple select

Hi, Yes I think no data found is your expected result. It is not an error message. It is the successfull result to the query you asked it to do/ You have basically done a where true=false so you will always get no rows. You have added 2 filters saying where "category" = 'A' and "category" = 'B' so for any 1 row category…

Hi, Post you sql to the forum might help us help you! Go to the advanced tab to get the logical sql for your analysis. By default all analysis in OTBI are limited to 75k rows - so that is your first problem. Too many rows. To debug yourself try to imagine the data model in your head. Build it up step by step as a "star".…

Hi, This is a column prompt in a dashboard prompt. So you cannot add a number format with zero decimal places as suggested like you can on a column in an analysis. My solution would be to add a function to the "Prompt for column" field using fx to wrap the presentation table/column to cast from a number to a string data…

Hi, I dont think columns are "missing" but the extract PVO do tend to be simpler with less joins to other tables. You do not need a document if a public view object (PVO) if it is also used in metadata repository database (RPD) in oracle transactional business intelligence (OTBI) as well as BICC. For example, data lineage…

Hi, I think if you need to ask this question to the vendor not the user community. Maybe try to find a product manager of BICC or something who might give you some sort of timeline. I am not aware of a deadline for the older public view objects to be removed in BICC. Maybe someone else will post otherwise? As you can see…

Hi Ashley, This is now in the OTBI forum. Yes we had the same problem with this use case. My assumption is that this is a feature of design in this subject area in the metadata repository database (RPD). Basically this subject area has 2 "star shemas"; one for expese reports/items business process and another for credit…

Hi, Actually no it is only possible to view as CSV, in your custom report or one of the pre-defined reports, if the designer of the report selected output format data "CSV" on your selected layout for that run. You can view the output as CSV whether or not you run the report yourself like from a dashboard page or from the…

Hi, Yes. Subject areas for users. But I am not aware of any business process in the application for a user to "register"?. So I do not know what you mean by "registered user" versus "not registered user". Maybe you can post a link to the user guide to explain what you mean by this? If you want a list of users you can use…

Hi, I do not undestand your question. What do you mean by the verb "audit". https://www.google.com/search?q=define%3A+audit conduct an official financial inspection of (a company or its accounts). "companies must also have their accounts audited"" Maybe you can provide an example. With perhaps some SQL. So if we make it as…

Hi, I tell my users to go direct to /analytics/ as a favourite in their browser rather than waste 3 clicks going from the navigator menu using the work area Reports and Analytics (which is what the "Browse Catalog" button does). All our users have autoprovision either role Employee Worker or role Contingent Worker based on…

Hi Vlad, If you do not want people to be able to edit analytics then you need to either a) create custom job roles to revoke standard role BI-Author from all the roles they have ( a good idea!) or b) change the privileges assigned to the standard role BI-Author (a bad idea :( ) on the page Manage Privileges as BI…

Hi, Have a look at subject areas "Human Capital Management - Approval Notification Archive Real Time" Real time information on completed approvals of various tasks transactions that are part of Fusion HCM. The tasks transactions comprise of various categories like compensation, payroll, core hr, absence/accrual, talent…

Hi, out of the box authors can only edit files in the custom folder. So no solution is required? The other shared folders are already locked down to prevent edit by authors. To check the folder permissions select the custom folder in teh catalog then in actions select permissions.

Hi, Yes the work area "Reports and Analyics" in Tools is not "in" OTBI. It is part of the core oracle fusion cloud applications user interface. You dont get to OTBI until you for example click button "Browse Catalog" then get redirected to a different uniform resource locator to go to OTBI at /analytics/. But have similar…

BTW A user may or may not be linked to a worker. If the user is linked to a worker then "Job Title", "Company", "Manager Name" [and possibly "Email" (if this is one of the many home or work etc contact emails of the worker rather than the one user email of the user)] are from the employment information person assignment(s)…

Have you tried the subject area for roles and privileges? for example, to get a list of users and their roles #/analytics/saw.dll?issuerawsql select all 0 s_0 , "User"."User Name" as user_name , "User"."Person Number" as person_number , "User"."Person ID" as person_id , "User"."Employee Display Name" as person_display_name…

For example in this query your persons with multiple assignments will float to the top... do you have any with multiple primary active employee assignments at the same point in time? select all count(*) over (partition by null) as n , count(distinct assignment.assignment_id) over (partition by null, assignment.person_id)…