Topic
  • 10 replies
  • Latest Post - ‏2013-01-24T12:04:50Z by LongSunLi
SystemAdmin
SystemAdmin
203 Posts

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

    Re: I don't find optimization advisor

    ‏2013-01-23T02:03:11Z  
    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

    Re: I don't find optimization advisor

    ‏2013-01-23T03:38:41Z  
    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

    Re: I don't find optimization advisor

    ‏2013-01-23T09:37:30Z  
    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
  • SystemAdmin
    SystemAdmin
    203 Posts

    Re: I don't find optimization advisor

    ‏2013-01-23T09:40:04Z  
    • LongSunLi
    • ‏2013-01-23T03:38:41Z
    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.
    My versione of Infosphere warehouse is 9.7.3.
  • LongSunLi
    LongSunLi
    14 Posts

    Re: I don't find optimization advisor

    ‏2013-01-23T09:46:36Z  
    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
    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

    Re: I don't find optimization advisor

    ‏2013-01-23T09:47:26Z  
    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
    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

    Re: I don't find optimization advisor

    ‏2013-01-23T09:49:23Z  
    My versione of Infosphere warehouse is 9.7.3.
    Thanks for the product version, and you do not need any configuration to make this function visible.
  • SystemAdmin
    SystemAdmin
    203 Posts

    Re: I don't find optimization advisor

    ‏2013-01-23T10:11:02Z  
    • LongSunLi
    • ‏2013-01-23T09:49:23Z
    Thanks for the product version, and you do not need any configuration to make this function visible.
    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

    Re: I don't find optimization advisor

    ‏2013-01-23T10:28:49Z  
    yes, foreign key are mandatory.