Thanks for your feedback.
Want to tell us more? Send us an email to leave your feedback.
Improving the Performance of Large Intelligent Cubes: Partitioning
If your Intelligent Cubes contain large quantities of data, you can improve their performance by dividing the datasets into multiple segments, called partitions. The partitions are processed simultaneously, distributed across the processor cores of your Intelligence Server.
To Partition an Intelligent Cube
- In Developer, log in to your project and navigate to the Intelligent Cube.
- Right-click the Intelligent Cube, and select Edit. The Intelligent Cube Editor opens.
- Choose Data > Configure Intelligent Cube. The Intelligent Cube Options dialog box opens.
- Select the Data Partition category. The Data Partition options are displayed.
- From the Partition Attribute drop-down, select the partition attribute for the Intelligent Cube. For the criteria to determine an appropriate distribution key, see Requirements for the Partition Attribute.
- In the Number of Partitions field, type the number of partitions to create. The number should be less than or equal to the number of processor cores on your Intelligence Server machine.
- If your data warehouse supports parallel SQL queries, enable the Fetch data slices in parallel from the warehouse check box.
- Click OK.
Did you find this helpful?
x
Great!
Thanks for taking the time to give us some feedback.
x
Sorry about that
Why wasn't this helpful? (check all that apply)
Waren Ihnen die Informationen hilfreich?
x
Großartig!
Vielen Dank, das Sie sich die Zeit genommen haben, uns Ihr Feedback mitzuteilen.
x
Das tut uns leid!
Warum waren diese Informationen nicht hilfreich? (Zutreffendes bitte auswählen)
Ces informations vous ont-elles été utiles ?
x
Superbe !
Merci de nous avoir accordé un peu de votre temps.
x
Nous en sommes désolés
Pourquoi ne vous ont-elles pas été utiles ? (cochez tous les choix applicables)
Questo contenuto ti è stato utile?
x
Perfetto!
Grazie per avere dedicato del tempo per fornirci un tuo commento.
x
Siamo spiacenti
Perché non è stato utile? (selezionare tutte le risposte adeguate)
¿Le ha resultado útil?
x
¡Genial!
Gracias por dedicar su tiempo a proporcionarnos sus comentarios.
x
Lo sentimos
¿Por qué no ha sido útil? (Marque todos los que correspondan)
Você achou isso útil?
x
Ótimo!
Obrigado por aproveitar o tempo para nos dar alguns comentários.
x
Desculpe por isso
Por que isso não foi útil? (marque todas as que se aplicam)
役に立ちましたか?
x
ありがとうございます。
お時間を割いてご意見をお寄せいただき誠にありがとうございます。
x
それは残念です
役に立たなかった理由は何ですか? (該当するものをすべてチェックしてください)
도움이 되었습니까?
x
수고하셨습니다.
피드백을 위해 시간 내 주셔서 감사합니다.
x
죄송합니다.
도움이 되지 않은 이유는 무엇입니까? (해당되는 모든 사항 선택)
您觉得这篇文章有用吗？
x
好极了！
感谢您抽出时间给我们提供一些反馈。
x
我们对此感到抱歉
为什么您觉得没什么用？ （选中所有适用项）