Hi Anjali, That is the expected result if some of your values are not numbers! You can only convert a string to a number if the value in the string is in fact a number. If some of the rows have values in the string that are not numbers then you expect the system to throw this error.

Ooops - apologies but the image was quite small. I just read the message now later. I do not think it is roles now. It says "Exceeded the maximum query execution time". So the issue is the query performance. It is taking too long to get your data. Are different users running it with different parameters. Can the user for…

Hi Shikha, I assume this is the expected result with a database connection error message for a user that executes a query from a subject area for which they have not been granted the required role to use that subject area. For this subject area Payables Invoices - Trial Balance Real Time…

Yes. Take them out. Drag the column in a prompt to section Excluded.

Hi, I can help you understand how to find it. You unable to find the object in the catalog in OTBI - on the out of the box dashboard which dashboard? on which page? which section?. If you let us know then I can tell you what object it is. Post a screenshot highlight the bit on the page you cannot find. In global header you…

Anup, Which subject area is your query? What is the query? Please post the logical sql from the advanced tab as plain text not attachment. Make it the simplest query with least columns you can to provide an example of the problem. You said person. Not the assignments of the persons who are workers with work relationships…

Hi, Yes you can use this to aggregate (count, sum, average, min, max etc) any fact by any n dimensions. Nothing in this is specific to candidate number. Just replace candidate number with the one or more blue attribute dimension columns you want to group by. Yellow fact measure columns will always "roll up" across your…

Hi, My understanding is that it is up to each user to decide as a user preference if they want to consume an infolet on the infolet pages or if they want a work area to appear on the springboard on my home page. So no you cant force me to use one of your infolets if my role gives me permission to use it. It is up to me…

Hi, A person can have an worker assignment with worker type Employee Worker or Contingent Worker etc. All types of worker may have managers. A worker may have multiple work relationships with different legal employers each with multiple assignments over time or at the same point it time. So to get a manager hierarchy you…

Hi, Your question was how to make an analysis filter based on value selected in a prompt by user. The previous answer is the solution for that question. For all and every analysis that you will ever build for "is prompted" the formula of the column in the prompt must match the formula in the column in your filter in the…

Works ok. Did you cut paste the column formula? Was the prompt created using the same subject area? For example, I have more than 300 learners Bypass Completed so that row is excluded

Hi, Yes. Just cut paste using fx whatever is in your filter column to your prompt column. Prompt Filter

Hi, You can create a dashboard with one page just with 1 analysis on it. That is ok.

Hi, Your design should be for your users to be using dashboards to interact with analytics and reports in OTBI.

Hi Ruvina, Yes that is what the report links do out of the box. If you have an analysis with in your results a layout with multiple views, for example a table view and a chart view, then when you view that analysis layout on a page, the report links to export "Formatted" at the bottom of that analysis on that page will…

Jordan, I have provided the solution above. Let us know if it works for you.

Hi, A timecard uses the business process management workflows to do approvals. As with any workflow a task have multiple approvers. And as you know with any workflow an assignee may may delegate or assign to another person. In addition to this because you can edit an approved timecard then submit for approval again a…

Hi Trupti, Is this something you have in the United States of America (US)? Is this a Federal Employment Identification Number (EIN). Please confirm what is this field in the user interface. https://en.wikipedia.org/wiki/Employer_Identification_Number Assume this is perhaps an attribute about a legal entity? Select…

Hi, Yes you can do that! You can rename it when you use it. In a prompt select "Custom Label" = True then edit "Label" In an analysis select "Edit Formula" select "Custom Label" = True then edit the "Column and/or Folder Heading" BTW Because this is SaaS the host have not given you privileges to edit the metadata…

Hi, For "bulk" data export the recommended by Oracle approach is Business Intelligence Cloud Connector (BICC) (not analytics and reports in OTBI nor the SOAP/REST API) Oracle Fusion Cloud Applications Creating a Business Intelligence Cloud Extract F92942-01 24B…