Welcome to the Oracle Analytics Community

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

user4109719 Rank 4 - Community Specialist

Comments

  • That worked. Thanks.
    in OBIEE sort on measure in pivot table Comment by user4109719 February 2021
  • When I check Treat as Attribute it makes the rank column equal to 1 for all rows.
    in OBIEE sort on measure in pivot table Comment by user4109719 February 2021
  • After setting content level in the Fact it works now. The Fact table alias I created as a test was working so it was confusing me.
    in Problem joining tables Comment by user4109719 March 2020
  • The content level is set in the sources tab. The dimension hierarchy has just the top level and the detail. I set it to the detail level. Does the fact that I can join a different alias of the same physical fact table mean anything? If the content level is the issue I don't see why that would be possible. One thing that…
    in Problem joining tables Comment by user4109719 March 2020
  • I am trying to use the overloaded AGO function which only takes 2 inputs: there is a overloaded version of AGO: AGO(expr, offset) which uses the grain of the Answers query as the level. As I understand it, this is supposed to detect the grain from the field being used to generate the time period. It works when using a…
    in OBIEE AGO function for 1 month prior Comment by user4109719 June 2019
  • I didn't explain things well. The AGO function returns correct results when I use a single day: DateNet Sales - Products and ServicesPrior Net Sales - Products and…
    in OBIEE AGO function for 1 month prior Comment by user4109719 June 2019
  • This is the properties of the logical dimension. The child Organizations I am trying to drill to have a value of 2 for HIER_LEVEL with the parent value equal to 1. Thanks.
    in OBIEE not drilling down in parent-child dimension Comment by user4109719 September 2017
  • I created a "Back" button on the second page and using that instead of selecting the tab to go back to the prompt page doesn't cause the issue. I assume that's why navigating to the analysis worked, because the tabs disappear and you have to click "Return". I doubt this is the intended behavior.
    in OBIEE Presentation variable stops refreshing Comment by user4109719 June 2017
  • Reset doesn't fix it. Another thing I've discovered is that navigating to an analysis on the page, rather than the dashboard page, doesn't cause the problem. I tried removing all the analyses from the page so it's just a blank page and the problem still happens. Returning to the page with the prompt is done by selecting…
    in OBIEE Presentation variable stops refreshing Comment by user4109719 June 2017
  • Actually the presentation variable is updating correctly. I put it in a text box on the page and it is showing the correct value. OBIEE is just not executing the query based on the new value of the presentation variable, after navigating to the second dashboard page by clicking on a bar representing a particular month. If…
    in OBIEE Presentation variable stops refreshing Comment by user4109719 June 2017