Parmit, Oracle Cloud Applications use a very old 11g version of OBIEE in OTBI so you must go to the following rather than the latest 12c version of the platform https://docs.oracle.com/middleware/11119/biee/docs.htm

Ruth, I know that the system defaults are stored as a fragment of xml in the catalog. That is how we have found and corrected this type of mistake in the past on premise. That was read using a text editor as the software owner user on the application server therefore not sure how you read it on cloud. It is in system…

Hi, Have you tried removing privilege "Save System Wide Column Formats" as bi administrator on the "Manage Privileges" page .../analytics/saw.dll?PrivilegeAdmin 

A table prompt is not a filter. The system will run the logical sql in your query (you can see it on the advanced tab). That is how many rows are returned from the metadata repository database (RPD) and therefore how many are counted. Your table prompt is a display thing after all the data has been returned to show/hide…

Hi Lisa, Usage tracking will tell you what your users did use. With an "on-premise" install you can set up usage tracking so that the metadata repository database (rpd) will write to a database table every logical and physical query. However with OTBI in your cloud application I am not aware that usage tracking is turned…

As a workaround have a look at using the aggregate function with function FILTER USING on your measure columns. So for example if you select your fact for 24 months of 2 years of data then use filter on your fact column to sum only where month is in the first 12 months (previous year to date), and another to only get the…

Hi, The time series functions require presentation hierarchy. If you have no presentation hierarchy in the subject area then you cannot use the time series functions like todate and ago in your logical sql. The "Year" column you have selected is not a "dimension" but it is a "presentation column". I am using the strict…

In an "on-premise" environment you can update a file called custom.css on the application server hosting business intelligence then you reference the classes you have added in that box on the column properties "CSS Class". So you can create a class then use on on many reports. If you then change the class it gets updated…

The catalog is stored in the "backend" on the application server not in the database. Under the root folder there are 2 folders Users and Shared. The shared folder is the one you can see in the catalog. Under the users folder there is subfolder for each user with their username then at runtime that folder is shown as "My…

Apologies i missed that in your post.

Here are the Italy reports in Financials cloud ... * VAT Reports for Italy * Intra-EU Reports for Italy * Exemption Reports for Italy * Withholding Tax Reports for Italy see Oracle Financials Cloud Using Analytics and Reports for Financials 20A F24527-01 16 Oracle Fusion Financials for EMEA Reports…

Hi, for each cloud you can read the manual to track if a view object is used by the metadata repository database (RPD) for financials clound https://docs.oracle.com/en/cloud/saas/financials/20a/analyze-and-report.html review data lineage…

So you can save as format XLS to build a layout that does work. Just curious but what is it in an XLSX format that you need that you cannot do in XLS?

P.S. On cloud the function EVALUATE is disabled by default in OTBI. See note on support.oracle.com Fusion Applications OBIEE - Error using OBIEE Evaluate Function [nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. (Doc ID 1922648.1) The Evaluate…

BTW COALESCE and OVER PARTITION BY are physical sql functions in a standard oracle database. So you can not expect them to work in logical SQL in the oracle bi metadata repository database (RPD). The logical sql syntax is not the same as standard SQL in most other databases. However as you can see there is a special…

Here is a brute force method by joining to itself having excluded the nulls in the second query. This returns 100 Apple 100 Apple 100 Apple 200 Orange 200 Orange 200 Orange select all a.name as n, a.value as v1, b.value_2 as v2 from ( select all 100 as name, null as value from "Sales - CRM Customers" union all select all…

Regards "cannot copy", I do not think you need to copy, I think it is ok to create a new Custom "Custom BI Web Cat Reporting Duty" role, using whatever naming convention you have, then on step 4 on role hiearachy add whatever "BI_XXX_REPORTING_DUTY" roles you need. For example, BI_FIN_REPORTING_DUTY. That way you do not…

BTW I think is is the "Read" privilege on the top folder that makes it happen. "Traverse" is no good if you can not "Read" it? see Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1) E10544-08 December 2014…

Hi, I have set it up. When i logon as administrator I see all the folders. But when I logon as a consumer I only see a subset of folders for the folder duty roles I have assigned to that user. My only confusion was the empty folder for Extensions hence the previous post. But all the other folders seem to work ok. Give it a…

Hi, OBI has a web service to manage the catalog. https://host/analytics/saw.dll?wsdl In the bi desktop client tool is a catalog manager that uses the web services to report on dependencies between objects. Oracle have used this tool to extract a list of objects into a spreadsheet including the paths to the components. This…