ark86 — Oracle Analytics

Welcome to the Oracle Analytics Community

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

ark86 Rank 3 - Community Apprentice

Comments

  • Hi, Thank you for your reply. Now i made a perfect star by combining both facts now both facts are connected to both dimensions logically. But still F2 amounts disappear when D1 attribute is added. Thanks.
    in Level based Hierarchy Comment by ark86 Nov 18, 2016 2:45AM
  • Hello everyone, Sorry couldn't get a chance to reply to this post. Bad news is that i'm still suffering to implement 'Level Based Measures'. So here's what I've done. I've made four separate and simple tables to understand the concept and I'll list my steps in detail I made following 4 tables (2 dimensions and 2 facts)…
    in Level based Hierarchy Comment by ark86 Nov 17, 2016 1:30PM
  • I've all the required info and will update this post tomorrow. A big thanks again Regards, ARK
    in Level based Hierarchy Comment by ark86 Nov 7, 2016 2:20PM
  • Hi Thomas, Actually I've already implemented this by forcing logical stars. Now i was trying to learn best practices and thought there might be a better approach. I think i'm finally getting how this will work. In my semantic layer, I've tables with first level facts joined to second level facts and then joined to third…
    in Level based Hierarchy Comment by ark86 Nov 7, 2016 1:44PM
  • Thank you for your input. But Workshop is not related to Claim payments at all. I'm trying to follow below approach as it addresses the exact problem i'm facing https://blog.daanalytics.nl/2010/05/31/multiple-fact-reporting-on-non-conforming-dimensions/ I don't want to join multiple tables in logical tables as i'm making…
    in Level based Hierarchy Comment by ark86 Nov 7, 2016 12:51PM
  • Dear @Christian Berg, I asked a similar question before where you helped me. Can you please look into it and comment. I'll be grateful. Thank you. Regards, ARK
    in Level based Hierarchy Comment by ark86 Nov 7, 2016 11:00AM
  • I agree. Thank you very much for your help. Regards, ARK
    in Suppress measure against dimensions in analysis Comment by ark86 Nov 7, 2016 9:17AM
  • Hi, Yes i did. A number of times in fact. Let me explain what my level based hierarchy contains - Claim_Dim -> Detail Total -> no key - Claim_Dim -> Detail Level -> key = Claim_ID - Workshop_Dim -> Detail Level -> no key - Workshop_Dim -> Detail Level -> key = Workshop_ID Thanks. Regards, ARK
    in Level based Hierarchy Comment by ark86 Nov 7, 2016 8:44AM
  • I understand that it was a wishful thinking but it was a requirement. I've handled this at DB end. Thank you for your valuable input. Regards, ARK
    in Suppress measure against dimensions in analysis Comment by ark86 Nov 7, 2016 7:50AM
  • Problem got solved. One column in BMM left unmapped which caused this issue. Everything worked perfectly after mapping it.
    in Changing Source Table of an Alias in Physical Layer in OBIEE Comment by ark86 Oct 6, 2016 9:08AM
  • Hi Thomas and Gianni, Thank you very much for your reply and for the correction. I wanted it to work as we make manual query. Here's what i did I made three dimensions (AGENT_DIM, AGENT_VEHICLES_DIM, AGENT_TARGET_DIM) by keeping all non measure columns in them. Then i made one Fact table naming AGENT_TARGET_DETAILS and…
    in Aggregation in OBIEE Analysis Comment by ark86 Sep 29, 2016 6:18AM
  • Dear Chris, Thank you for your reply. Actually the column i'm using is of Date type. One thing that i mentioned before as well is that i'm trying to achieve this while working on report (BI Publisher) and not on analysis. In Analysis, same thing works and i'm able to make 'is between' prompt. Any idea? Regards, ARK
    in Between Date Parameter in OBIEE 11g Report Comment by ark86 Aug 30, 2016 2:37AM