Hi All, for below query what could be the considerable date for partitioning basing on month.

here we can see translation date, document date, posting date dimensions.

which one should consider?

SELECT

[dbo].[FactMaterialMovement].[MaterialMovementRowInfoKey],

[dbo].[FactMaterialMovement].[TranslationDateKey],

[dbo].[FactMaterialMovement].[LocalCurrencyKey],

[dbo].[FactMaterialMovement].[MaterialKey],

[dbo].[FactMaterialMovement].[StoreKey],

[dbo].[FactMaterialMovement].[CampaignKey],

[dbo].[FactMaterialMovement].[DocumentCurrencyKey],

[dbo].[FactMaterialMovement].[SoldToCustomerKey],

[dbo].[FactMaterialMovement].[VendorKey],

[dbo].[FactMaterialMovement].[DocumentDateKey],

[dbo].[FactMaterialMovement].[PostingDateKey],

[dbo].[FactMaterialMovement].[ReceivingPlantKey],

[dbo].[FactMaterialMovement].[ShipToCustomerKey],

[dbo].[FactMaterialMovement].[Subtotal2],

[dbo].[FactMaterialMovement].[Subtotal3],

[dbo].[FactMaterialMovement].[AmountPOUnit],

[dbo].[FactMaterialMovement].[AmountLocalCurrency],

[dbo].[FactMaterialMovement].[BWAmountinBUnitM],

[dbo].[FactMaterialMovement].[BWCostValLocalCurrency],

[dbo].[FactMaterialMovement].[BWSalesValueLocalCurrency],

[dbo].[FactMaterialMovement].[SalesValLocalCurrency],

[dbo].[FactMaterialMovement].[DeliveryCostsLocalCurrency],

[dbo].[FactMaterialMovement].[GrossWeightSU],

[dbo].[FactMaterialMovement].[GrossWeightBU],

[dbo].[FactMaterialMovement].[GrossWeightG/R],

[dbo].[FactMaterialMovement].[VolumeinSU],

[dbo].[FactMaterialMovement].[MovingPriceLocalCurrency],

[dbo].[FactMaterialMovement].[ZFACT1],

[dbo].[FactMaterialMovement].[ZS_FACTO],

[dbo].[FactMaterialMovement].[QuantityBaseUOM],

[dbo].[FactMaterialMovement].[DelivQtyinSUn],

[dbo].[FactMaterialMovement].[Qtyinunofentry],

[dbo].[FactMaterialMovement].[Volume],

[dbo].[FactMaterialMovement].[MateriallantAttributeKey]

FROM

[dbo].[FactMaterialMovement]

WHERE

thanks

Niharika