1 2 Previous Next 18 Replies Latest reply on Nov 3, 2017 3:18 PM by Robert Angel Go to original post
      • 15. Re: Ago function
        Luigi_Gif
        Luigi_Gif Nov 3, 2017 11:00 AM (in response to Luigi_Gif)

        Hi Robert,

         

        I moved as you asked me, below I show that WEEK in the database is well linked to, but it is not a unique key as it seems:

        Untitled.png

         

        To do it I think I should go on my Physical model, AL_PERIOD_SCH_SHIP_DATE, click on properties, and in the section Key I add a new one; that is week...right ? Now is as showed below:

        Untitled2.png

        I didn't understand your previuos A and B points.How can I find out if my key sufficient represents the uniqueness at a certai level ?

         

        Thanks

        Luigi

        • 16. Re: Ago function
          Robert Angel
          Robert Angel Nov 3, 2017 11:25 AM (in response to Luigi_Gif)

          My point is a crucial one.

           

          Keys are of paramount importance in OBIEE.

           

          In the AL_PERIOD_SCH_SHIP_DATE I would expect (in one row for todays date as an illustrative example); -

           

          YEAR_ID 2017

          QUARTER_ID 201704

          MONTH_ID 201711

          WEEK_ID (I see this is not present in your table, sound of alarm bells here!!! - your week probably looks like 47 not 201747 - i.e. it is not a key which would let me find ONLY the week in question, BECAUSE IT LACKS SUFFICIENT DETAIL TO DO SO - excuse the capitals!)

           

          So, I would suggest in your business model logical table you need to create a concatenation of Year_ID and Week to make a Week_Id which can then validly be used as the key in the time dimension and which will work in the AGO function.

           

          Note - as a function this will not be the most performant way to do it, the best way is to go back to your Data Warehouse developers who populate the table and ask them to create a unique week id in the physical table, and then model it through to use it in the appropriate place.

           

          For further explanation on the concepts see this => https://gerardnico.com/wiki/dat/obiee/obis/time_dimension

          • 17. Re: Ago function
            Luigi_Gif
            Luigi_Gif Nov 3, 2017 2:02 PM (in response to Luigi_Gif)

            Thank you Rober, I've studied the instruction in the link, now I start working on my DWH and I will bring you up as sonn as I have new

             

            Luigi

            • 18. Re: Ago function
              Robert Angel
              Robert Angel Nov 3, 2017 3:18 PM (in response to Luigi_Gif)

              Sure, hope you get there.

               

              Kindly also mark whatever helped or turned out to be correct for the benefit of those who follow.

               

               

              Robert.

              1 2 Previous Next