Logical size table in Microstrategy

By default in the case we use attributes and metrics that are being mapped in many tables Microstrategy uses the fact table for the reports that has the lowest logical size.

And what is the logical size determined by?

The logical size is defined by the cardinality of the attributes (Can see this Technical Note for being able to estimate it)

Sometimes in a project we’ll need to define as default fact table the one that have a larger cardinality. In this case Microstrategy allow us to determine manually the logical size of the table we want.

To change it, we’ll go through Developer to the table directory in the scheme objects and open the one we need to change the logical size. We’ll put the new logical size and mark the check before save the changes.

logicalsize2

Hope it helps.

Links that helped me:

Link 1
Link 2
Link 3

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *