Hey, What's the purpose of the custom tables? We're using a bunch of custom tables, views and materialized views in our rollout. Tables We're using NSAW (NetSuite's version of FDI) and there's no native transactions + rolled-up balances tables, so we've built a custom pipeline to build out a Transactions Fact table and a…

Hey Benjamin, Looks great! Very interested in hearing more about the dbt integration; is this going to be different to the standard oracle adapter for dbt? For example, will this be an integration where there's a dbt cloud-like interface contained inside the FDI platform itself for writing pipelines? Game-changer either…

Change 'All Column Value' to just %. E.g. "subject area dimension"."column name" in (@{p_param}{%}) You also don't have to add them into the SQL itself (unless you're filtering subqueries); you can just do this via the criteria tab where you'd usually add filters/presentation variables: This will return all values by…

Voted - this is essential for organizations that utilize scheduled email deliveries via BIP. It's currently not practical, nor manageable, to decipher which emails bounced or failed to deliver via the current interface available to us.

Hi Maria, Certainly - first of all, are you authenticated? On the request page for SoapUI, in the bottom left-hand corner, there will be a little padlock icon followed by the word 'Auth'. Click on that, then enter your credentials using the 'Basic' authentication method (username + password). Secondly, there's an issue…

Hi Maria, Can you walk me through what webservice you're using? (full URL without your pod name will suffice). The method you're calling I'm assuming takes the following parameters; reportAbsolutePath, userID, password. However, you're calling the getReportSampleData() method, which will only return the sample data that is…

It's meta-data driven, a subject area could be created for BI Admins to access all the metadata without requiring web services. Use Case would be Auditing - Admins need to know at a glance who has access to what, as not knowing who has access to what could lead to security issues (e.g. BIP Reports not secured properly).

Hi Pavel, Thanks for this - can you please provide us with the schema + table names required to access the OTBI Usage Tracking? A lot of us have waited a long long time for Fusion OTBI usage tracking and the table could be used in many ways (e.g. auditing what reports exist in different folders + get used, performance,…

Hi Priscilla, This exam is due to retire in July and it's based on Oracle's older technology - I wouldn't recommend taking this unless your employer/client is asking for it. OBIEE has been replaced by Oracle's new Analytics offering (Oracle Analytics Cloud + Oracle Analytics Server (on-prem)). Look at exam topics…

This looks awesome, writing Logical SQL manually can be a cumbersome task. Perhaps this could be turned into an app using Oracle Cloud's Free Tier + Apex? You might even be able to go as deep as creating a visual format that allows you to drag and drop the logical column names by importing the OTBI lineage docs. I always…

I think the deprecation of Direct Database Requests means that this is a very viable idea; developers will spend most of their time running ad-hoc queries and a lot of the time they need to be checking more than 200 + rows of data that the sample data output from BIP gives you. Going through the data modelling process to…

Hey Stephanie, Try this: (CASE WHEN IFNULL("Folder"."Due Date", CURRENT_DATE +1) > CURRENT_DATE THEN 'Y' ELSE 'N' END) = 'Y' Just change the "Folder"."Due Date" to your Due Date column. Essentially we're replacing the NULL values with the current date + 1, so they will always be greater than the current date. Should…

Hi Stephanie, Have you tried the following: 1) Change your statement to: CASE WHEN MAX("Activity"."Due Date") > CURRENT_DATE THEN 1 ELSE 0 END 2) On the Advanced tab, use the Group By Box to group the query by the unique identifier for each opportunity (e.g. the column formula for the 'Name' column in your output, or the…

Is there any reason behind this? We use this tool a lot for development to check/test our queries before turning them into a BI Publisher report, quite annoying.

Hi Stephanie, Have you tried transforming the data type? I sometimes come across similar issues and I will CAST it as an alternative datatype (VARCHAR, INT or FLOAT). Sometimes I would even transform it into a varchar and then back into an integer, so sort of like a nested cast function. I would then use this in…

Hi Stephanie Yes this is possible! You would put the hard-coded value inside single quotation/apostrophe marks. For instance: CASE WHEN DATE1 <= DATE2 THEN 'On Time' ELSE 'Not on Time' END Kind Regards Aaron

Hi Adil, Someone correct me if in wrong, but as far as I'm aware Direct Database Queries override the data security model present in OTBI. This means if business users have access then they would be able to query pretty much anything they want, hence why it's not a recommended tool for production reports and only BI…

Hi Linda, Have you tried going onto the results tab, right-clicking on the 'Country' cell (could be Nationality for you), Keep Only > Top X > Based on Person Count > 10. This will generate the relevant SQL into your report and will enable you to then build pivot tables and charts with only the top 10 selected. I have…

Hi Thomas The preferred name should be called 'Employee Known As' or 'Known As' in OTBI. This can be found under the 'Worker' folder. Also, are the Employee Saluation fields custom (flex-fields)? We don't appear to have them, nor do I have them on the database mappings. If they're not on the subject area that Abul stated…

Hi Rachel Thank you so much, we have managed to get the information we needed!