Thanks for your feedback.
Want to tell us more? Send us an email to leave your feedback.
How to Partition Large Datasets and Create Search Indexes
If you are importing very large datasets into MicroStrategy Desktop, you can divide the dataset into multiple segments, called partitions. The data in the partitions is processed simultaneously, improving the performance of your dossier.
See the In-memory Analytics Guide to determine if your dataset is appropriate for partitioning and how to choose an appropriate partition attribute.
To partition the dataset and create search indexes
- Create a blank dossier or open an existing one.
-
Choose Add Data
> New Data to import data into a new dataset.or
In the Datasets panel, click More
next to the dataset name and choose Edit Dataset to add data to the dataset. The Preview Dialog opens. Click Add a new table.The Data Sources dialog opens.
- Select the data you want to import, according to your data source type.
- Once you have selected the data you want to import, click Prepare Data to open the Preview dialog.
- Click All Objects View
. The All Objects View Dialog loads, displaying the attributes and metrics for your dataset, and the tables they are based on. - You can divide your dataset based on an attribute, called a partition attribute. When you choose a partition attribute, all the tables that contain the attribute are partitioned. It is recommended that the partition attribute be present in as many fact tables as possible. The number of partitions should be less than or equal to the number of CPU cores on your machine. Type the number of partitions, in which to split your dataset, in the Number of Partitions field.
- Creating a search index for an attribute improves performance for filters that use a search box on that attribute. You can create search indexes on any attributes in your dataset. However, creating search indexes uses additional memory on your machine. Enable the switch for an attribute by selecting the corresponding checkbox in the first column.
- Click Close to return to the Preview dialog.
Related Topics
How to Preview Data and Specify Import Options
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
我们对此感到抱歉
为什么您觉得没什么用？ （选中所有适用项）