Welcome to the Oracle Analytics Community

Home› Jerry Casey› Comments
Default Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Jerry Casey Rank 6 - Analytics Lead

Comments

  • P.S., I'm only showing the "legend" I created in Narrative View, because I no longer have access to the successful rendering.
    in Business Intelligence Comment by Jerry Casey Apr 11, 2019 1:45PM
  • Hi Christian, In 11G, I had successfully applied these two conditions: In 12.2.1.3.0, it simply doesn't render. I have tried rebuilding it from scratch in 12C, without success. It will render with a single condition, but not with a calculated combination of the two columns. I also tried with a simple version of that first,…
    in Business Intelligence Comment by Jerry Casey Apr 11, 2019 1:38PM
  • I recently posted a similar question about a problem in OBIEE 12.2.1.3.0: In my case, the presence of conditional formatting within the chart seems to be the issue. Remove the conditional formats, and the chart renders. I confirmed that the patch that @Mostafa Morsey identified was installed, but haven't heard anything…
    in Business Intelligence Comment by Jerry Casey Apr 11, 2019 12:50PM
  • Are you familiar with theses settings on the Recipients tab? If your specific recipients are identified in the data and associated with their Group of Marketers, they will only receive their specific records.
    in Schedule a prompted agent Comment by Jerry Casey Feb 21, 2019 7:29AM
  • I haven't heard of a way to do that. (I'm in 11.1.1.9.5) Agents aren't interactive. You didn't provided any details about what the user would be prompting for, but you can deliver conditional content based on the recipient's identity, either from a field in the data or from a session variable. If you want them to pick a…
    in Schedule a prompted agent Comment by Jerry Casey Feb 20, 2019 2:47PM
  • I use a union query in that situation. The second query in the union is the same as the first, with the granularity stripped away (e.g. replace "Member" with the word 'Total'). The Avg Spending column can contain the calculation you described. Formatting can make the new Totals record look like a standard totals line.
    in Custom Grand Total in Oracle Analytics Comment by Jerry Casey Aug 6, 2018 7:07AM
  • I'd use a union query, with the second query filtered on NOT IN TOP 10, and place a value of 'Others' in the cost center column (thereby "collapsing" all of the non-top 10 Cost Centers into a single record). Depending on your data, the Transaction Amt column may have to be sum(Transaction Amt). It may be that you want to…
    in Oracle BI Analysis not in TOP function union IS IN TOP 10 Comment by Jerry Casey Aug 3, 2018 10:20AM
  • If you still just need to get it done, the Column Selector view will work. If you set up a selector for both your Period and Metric columns, it could operate something like this one, where I have several options for both the column and row categories: The Column Selectors will drive every view you create off of your…
    in How to display graph and table dynamically using dashboard prompt in OBIEE 12c Comment by Jerry Casey Jul 2, 2018 7:22AM