Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
10 replies Latest Post - ‏2013-01-24T12:04:50Z by LongSunLi
SystemAdmin
SystemAdmin
203 Posts
ACCEPTED ANSWER

Pinned topic I don't find optimization advisor

‏2013-01-22T15:00:22Z |
Hi,
I'm new in Infosphere Warehouse.
I have this problem: when I use design studio and select a cube model, I don't find the Optimization Advisor in the menu with the right click on cube model.
I deploy the model creating ddl and exporting the olap model in the console.

Why i don't find the optimization advisor?

Can anyone help me?

Thanks
Updated on 2013-01-24T12:04:50Z at 2013-01-24T12:04:50Z by LongSunLi
  • SystemAdmin
    SystemAdmin
    203 Posts
    ACCEPTED ANSWER

    Re: I don't find optimization advisor

    ‏2013-01-23T02:03:11Z  in response to SystemAdmin
    Hi,

    In Design Studio "Data Source Explore" view,find your cube model,right click it, there will be "Optimization Advisor" for you.

    Please have a try.

    Best Regards!
  • LongSunLi
    LongSunLi
    14 Posts
    ACCEPTED ANSWER

    Re: I don't find optimization advisor

    ‏2013-01-23T03:38:41Z  in response to SystemAdmin
    Hi,

    As Li Shuang mentioned, you could find optimization advisor in Data Source Explorer view, not Data Project Explorer.

    If you still could not find it, please provide your warehouse version(9.5,9.7 or 10) and snapshot when you right click on the cube model.
    • SystemAdmin
      SystemAdmin
      203 Posts
      ACCEPTED ANSWER

      Re: I don't find optimization advisor

      ‏2013-01-23T09:40:04Z  in response to LongSunLi
      My versione of Infosphere warehouse is 9.7.3.
      • LongSunLi
        LongSunLi
        14 Posts
        ACCEPTED ANSWER

        Re: I don't find optimization advisor

        ‏2013-01-23T09:49:23Z  in response to SystemAdmin
        Thanks for the product version, and you do not need any configuration to make this function visible.
        • SystemAdmin
          SystemAdmin
          203 Posts
          ACCEPTED ANSWER

          Re: I don't find optimization advisor

          ‏2013-01-23T10:11:02Z  in response to LongSunLi
          thank you!! :) :)

          Another question: to use optimizer the foreign keys are mandatory?

          I have some errors for unions without foreign keys.

          Thank you again!

          Maria
  • SystemAdmin
    SystemAdmin
    203 Posts
    ACCEPTED ANSWER

    Re: I don't find optimization advisor

    ‏2013-01-23T09:37:30Z  in response to SystemAdmin
    hi,
    the file shows what I see in the panel with right click on cube model. There isn't the Optimization Advisor.
    I have to do something in particulat in order to make visible the Optimization Advisor or it is shown by default?

    Please help me,

    Thanks
    Maria
    • LongSunLi
      LongSunLi
      14 Posts
      ACCEPTED ANSWER

      Re: I don't find optimization advisor

      ‏2013-01-23T09:46:36Z  in response to SystemAdmin
      Hi Maria,

      From your snapshot, you tried to find Optimization Advisor in Data Project Explorer view.

      You may try in Data Source Explorer view, which in lower left of the design studio.

      Snapshot in the attach files could be considered as reference.
    • LongSunLi
      LongSunLi
      14 Posts
      ACCEPTED ANSWER

      Re: I don't find optimization advisor

      ‏2013-01-23T09:47:26Z  in response to SystemAdmin
      Hi Maria,

      From your snapshot, you tried to find Optimization Advisor in Data Project Explorer view.

      You may try in Data Source Explorer view, which in lower left of the design studio.

      Snapshot in the attach files could be considered as reference.
  • SystemAdmin
    SystemAdmin
    203 Posts
    ACCEPTED ANSWER

    Re: I don't find optimization advisor

    ‏2013-01-23T10:28:49Z  in response to SystemAdmin
    yes, foreign key are mandatory.
    • LongSunLi
      LongSunLi
      14 Posts
      ACCEPTED ANSWER

      Re: I don't find optimization advisor

      ‏2013-01-24T12:04:50Z  in response to SystemAdmin
      Hi Maria,

      You may right click cube model and run Analyze Cube Model before Optimization Advisor, the result will show error & warning for you cube model.