Welcome to the Oracle Analytics Community

Home› Nathan CCC› Comments
Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Nathan CCC Rank 7 - Analytics Coach

Comments

  • Here is a not very elegant way of getting a fixed length string (10) by concatenating non breaking space character 160 to the end of the string... select all 0 s_0 , substring(cast("Expenses - Expense Transactions Real Time"."Time"."Calendar Year" as character)||repeat(char(160),10) from 1 for 10) as s_1 from "Expenses -…
    in Trailing Spaces in OBIEE Comment by Nathan CCC Nov 5, 2019 11:08AM
  • Just twigged. You are using a list of values. On your parameter you select option to pass "Can select all" True with option "NULL value passed" not "All values Passed". If so then you need to change your where clause to handle what to do if the parameter is null (All). Condition x = null is always false so will return no…
    in Data Model Parameters Comment by Nathan CCC Nov 5, 2019 10:04AM
  • Yes it should work using variables in the where clause in the logical sql in your data model as the parameters in the data model as you have done. See image below. Did you get any rows when you hard code the value where "Worker"."Bargaining Unit" = 'All' in the SQL? An alternative option is to add a data set of type…
    in Data Model Parameters Comment by Nathan CCC Nov 5, 2019 9:53AM
  • Hi, Since this is a cloud forum, I would love to know how people are using desktop tools such as sqldeveloper, jdeveloper, toad etc? I am not aware that it is possible to use our favourite desktop tools to set up a database connection to issue sql on the saas cloud database. The closest thing i have found is to do pysical…
    in What application do you use to write your SQL Comment by Nathan CCC Oct 29, 2019 12:28PM
  •  I do not think there is such a thing as A4 layout. A layout is either portrait or landscape - if you print it then you tell your printer if you want A4 or A3 etc. Anyway the simplest way is to use the online layout editor to create your layoutthe 4 default templates are portrait or landscape either blank or with…
    in Require report output in A4 page layout. Comment by Nathan CCC Oct 14, 2019 1:41PM
  • Hi, You must follow the steps in the install guide (which includes setting up you database first as the previous reply said)... Oracle® Fusion Middleware Installation Guide for Oracle Business Intelligence 11g Release 1 (11.1.1) E10539-06 April 2015 https://docs.oracle.com/middleware/11119/bisuite/BIEIG/toc.htm#BEGIN as…
    in Oracle Business Intelligence 11g installation Comment by Nathan CCC Oct 14, 2019 1:29PM
  • FYI If i select my Display Name in top right then "My Account" then "Roles and Catalog Groups" i can confirm i have "BI Administrator Role" however I think the reason "Administration" menu is not displayed as one might expect is because in "Manage Privileges" /analytics/saw.dll?privilegeadmin that privilege "Home and…
    in Get privilege to issue logical SQL in OTBI Comment by Nathan CCC Sep 11, 2019 2:03PM
  • Hi, I found a solution. The BIAdministrator role did in fact exist so using security console i could grant it following my oracle support article "Oracle Fusion BI: How to Add the BI Administrator Role to a user in Release 12 and higher." (Doc ID 2238277.1). Repeating my test case In browser go to…
    in Get privilege to issue logical SQL in OTBI Comment by Nathan CCC Sep 11, 2019 12:21PM
  • Hi, You could try the Implement part of Oracle Unified Methodology (OUM). "Oracle’s Full Lifecycle Method for Deploying Oracle-Based Business Solutions" It is "a" method. The latest version was 2016. We have found this useful on past projects. It is not specific to SaaS. It includes how to html pages and template documents…
    in Oracle report development methodology Comment by Nathan CCC Sep 11, 2019 11:36AM