Test your SQL query out first on page Issue SQL /analytics/saw.dll?issuerawsql. For this as bi administrator on page manage privileges /analytics/saw.dll?PrivilegeAdmin grant to your user or a role your user is grated or inherit the privileges Issue SQL Directly and Manage Sessions. for example select all t.* from…

Hi Luis, Our host has turned off a few years ago in OTBI the OBI feature to issue SQL using select_physical. I assume due to hacking penetration test security concerns or something like that. But you can still query a PVO. In your data set of type SQL your data source must be Oracle BI EE. Then you issue sql - see the…

Hi, Assume the common dimension is the unique identifier of a person (or alternative business group id concatenated with upper person number) so join the subject areas using that common thing select all a.*, b.* from (select all 0 as s_0, "presentationtable"."presentationcolumn" as person_id, … from "Subject Area A") a //A…

Hi, Yes that feature does exist in OTBI. In global header select Create, select Filter. This allows you to reuse the filter in multiple analysis. Many of your sample analyses on the out of the box dashboards use it. For example dashboard "Line Manager" in human Capital Management For more information read the manual…

Hi Darwin, Your query is not failing in the OTBI database (RPD) on the application server in OTBI. The database (RPD) in OTBI does not have a PGA. This is a different type of oracle database with different architecture from standard. Your physical SQL query(s), either 1) generated by your analysis in OTBI or in data model…

Hi Lynda, IMHO I do not agree your only option is a report in otbi with physical sql from the application database FSCM. "limited to 1 subject area" not true. You can query as many subject areas as you like. On the analysis editor on criteria tab you have a button to add subject areas. In the column formulas the additional…

Hi, Oracle Business Intelligence OBI ( suite Enterprise Edition EE) platform in package OTBI is the "legacy" BI platform. The cloud first platform is Oracle Analytics Cloud (OAC). OBI has no donut charts out of the box. OAC does have them out of the box. On premise in OBI it was possible to drop in third party code to add…

Hi Lynda, The "to date" data is NOT stored in transaction database table in GL_BALANCES. GL_BALANCES https://docs.oracle.com/en/cloud/saas/financials/24a/oedmf/glbalances-22676.html#Details table has the begin balance and period activity debit and credit as a "transaction" balance for a balance type, encumbrance type,…

Hi, You initially posted this on the OTBI forum so assume this is a report in Oracle Transactional Business Intelligence OTBI in Oracle Fusion Cloud Applications not in Oracle Analytics Cloud OAC. So in either case this issue looks to be in the data source database server, not in the application server, caused by the SQL…

Hi, No CSV does not take the order from the SQL. It starts out at first in that order by default when you first create the data set from the sql but then you can change the order in the data model in diagram without updating the order in the SQL. And when you update the sql any new cols go to the bottom of diagram (far…

Hi, In CSV and XML the order of the columns is the order in your data model. You can drag and drop up and down on the diagram. There is also an option in data model properties to include exclude empty columns.

Hi The where clauses for data security are added at runtime after you submit your query. You will never see them in the logical SQL on the advanced tab of your analysis which is what you cut paste in the previous post. You have to view log in manage sessions to see the one or more generated physical SQL(s) (normally WITH……

Hi, Yes that is correct. You cannot resolve it. The subject areas for usage/performance only shows you queries from analysis and prompts to subject areas in metadata repository database RPD in OTBI. It does not show you the usage of reports with data models with data sets that do not query subject areas in OTBI. For usage…

Hi, This forum is for Oracle Transactional Business Intelligence OTBI in Oracle Fusion Cloud Applications. Semantic Data Modeller is NOT in OTBI. Semantic Data Modeller is in Oracle Analytics Cloud OAC. OTBI in Oracle Fusion Cloud Applications is not implemented using Oracle Analytics Cloud (OTBI uses the "legacy" OBIEE).…

Hi Jaime, Looks like you built an analysis in OTBI not a report in OTBI. To debug, get the logical SQL from the advanced tab of this analysis, in both envs issue the SQL /analytics/saw.dll?issuerawsql, get the physical SQL from the logs, use your favourite text compare tool to review differences. Run the physical sql in an…

Hi, To achieve your requirement "have prompt list of values filter by existing selections in another prompt" consider 2 options Do not use presentation variables. In your prompt use the native linked list functionality "Limit Values by". In your analysis filter continue to use "is prompted". This is the very much easier…

Hi, You are storing the value entered or selected from a calendar or a list of values by a user on a dashboard prompt into a presentation variable, for example, p_project_number. Then that is being passed as a parameter of the same in your data model to be referenced in the where clauses in your queries in the data sets in…

Hi Calin, You cannot use a data model in an analysis. But you can do it the other way around. You can put an analysis in a data model. Then put the report you build on that data model on a dashboard passing parameters from dashboard prompt to report data model using presentation variables with same name as data model…

Hi Prasanth, The answer is NO table. In OTBI your analysis is a file in the BI catalog on the middleware application server hosted in your SaaS. The metadata definition of your analysis is XML. You can see the XML on the Advanced tab when you edit your analysis. This XML is not written to a database table. FYI There are…

Hi Calin, View Log on page Manage Sessions /analytics/saw.dll?sessions of page Issue SQL /analytics/saw.dll?issuerawsql for your analysis logical SQL to see the actual physical SQL that was generated to understand which public view object physical table or view in the application database. This will tell you how "# of…