Welcome to the Oracle Analytics Community

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

3409791 Rank 2 - Community Beginner

Comments

  • Thank you Gianni - you are right! the 12 million records are because I joined at the subject area level - I do not have a key field in each table to join with I have 52,800 in the RPD metadata table and 33,000 in the catalog metadata table - is there any way I can generate a KEY field such that it is consistent in both…
    in OBIEE Lineage Dashboard - RPD Metadata Analysis and Catalog (Answers) Metadata - combine these two Comment by 3409791 Apr 5, 2017 3:43PM
  • when I open the answers - that is when I click on open and when I select a value it is ok - but within the answers when I click on "results" tab it is giving me an error when I use a presentation variable it will generally say no data returned something like that - but not a error message - right? thanks for your time,…
    in passing presentation variable - date field error Comment by 3409791 Mar 22, 2017 1:29PM
  • Hi Thomas, In the RPD I have a very complex query - do you think I can specify the MIN() OVER (PARTITION BY PO_ORDER_NO) in the query directly or do you think it is good to specify in the BMM layer This is from Physical layer - SQL in OPV This is from BMM Layer Thanks a lot for your time, Rj
    in group by within answers 11g Comment by 3409791 Mar 17, 2017 3:06PM
  • Hi Thomas, thank you so much for your time - it is giving me the correct result when I use either MIN or MAX - so what I have done is in the answers I added one more column PO_ORDER_NO with a function of LENGH(PO_ORDER_NO) to see if there is any extra space - then in the "Advanced" tab I specify the group by to use the…
    in group by within answers 11g Comment by 3409791 Mar 17, 2017 2:51PM