Welcome to the Oracle Analytics Community

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

3061367 Rank 1 - Community Starter

Comments

  • Hi Cesar, Sorry for delay in response, still chasing Oracle to help me on this and but NO answers from there side yet. And worst case is they are not ready to deep dive on this and mark this as a bug. Answers to your questions: 1) The dimensions are perfectly having unique key and it is declared as Primary Key column. 2) I…
    in GroupByNoSort in OBIEE leading to wrong data Comment by 3061367 Jan 27, 2016 4:18AM
  • Hi Cesar, Thanks for helping out. Relevant line of Logs you would be interested in: Execution Node for logical request hash f04b274b : <<50252>> Projection, Close Row Count = 603, Row Width = 2160 bytes Execution Node for logical request hash f04b274b : <<50351>> GroupByNoSort, Close Row Count = 26, Row Width = 2160 bytes…
    in GroupByNoSort in OBIEE leading to wrong data Comment by 3061367 Jan 13, 2016 2:19AM
  • HI, When i add a DISTINCT clause to logical sql by either of below mentioned methods, this issue doesnot appear: 1) "Select Distinct" option in Logical Table Source 2) "Issue Explicit Distinct" in Advance tab of Analysis. And also, when i add a Time Dimension hierarchy where DISTINCT is not allowed, the issue repeats…
    in GroupByNoSort in OBIEE leading to wrong data Comment by 3061367 Jan 12, 2016 7:56AM