Dynamics Community Forum Thread Details

DemandForecastCube error - ax 2012 R3

Hi! i added a new dimension and when i try to create the statical baseline forecast i get this error:

Query <Alter AllowCreate="true" ObjectExpansion="ObjectProperties" xmlns="schemas.microsoft.com/.../engine">
<Object>
<DatabaseID>aw__demandforecast initial</DatabaseID>
<CubeID>ReqDemandPlanningCube</CubeID>
<MeasureGroupID>ReqDemPlanForecastView</MeasureGroupID>
<PartitionID>WriteTable_ReqDemPlanForecastView_5637144576</PartitionID>
</Object>
<ObjectDefinition>
<Partition xmlns:xsd="www.w3.org/.../XMLSchema" xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:ddl2="schemas.microsoft.com/.../2" xmlns:ddl2_2="schemas.microsoft.com/.../2" xmlns:ddl100_100="schemas.microsoft.com/.../100" xmlns:ddl200="schemas.microsoft.com/.../200" xmlns:ddl200_200="schemas.microsoft.com/.../200">
<ID>WriteTable_ReqDemPlanForecastView_5637144576</ID>
<Name>WriteTable_ReqDemPlanForecastView_5637144576</Name>
<Source xsi:type="TableBinding">
<DataSourceID>Dynamics Database</DataSourceID>
<DbTableName>WriteTable_ReqDemPlanForecastView_5637144576</DbTableName>
</Source>
<StorageMode>Molap</StorageMode>
<ProcessingMode>Regular</ProcessingMode>
<Type>Writeback</Type>
</Partition>
</ObjectDefinition>
</Alter> was not successful because of exception Errors in the metadata manager. The 'Demand forecast Count' measure group is not allowed to be write-enabled if any measure aggregates other than sum..

Which is odd because it changed the name of an existing dimension field that i didn't modify... can i change the write-enable property somehow?

Thanks

Write enabled is a setting on the measure group partition, so you should be able to change it if needed. I'm a bit surprised it got enabled. You may want to confirm that no one is actually using the writeback feature before you turn it off.

The setting can be changed on the Partitions tab of the Cube Designer. Right-click a partition and choose Writeback Settings from the context menu to enable it. If write back is enabled, the write back table should be shown immediately below the partition. Right click on the grid row for the write back table, and then click the Writeback settings command. On the Writeback Settings screen, click the OK button to disable writeback.

See msdn.microsoft.com/.../ms174823.aspx for more details.

Hope this helps,

Lance

Quick Links