Updating the Measure NullProcessing property through not updated in the cube while opening from SSDT

Narendra Reddy 1 Reputation point
2020-10-23T07:36:16.003+00:00

HI,

I would like to update the NullProcessing property from Automatic to Preserve

foreach (MeasureGroup measureGroup in cube.MeasureGroups)
{
foreach (Measure measure in measureGroup.Measures)
{
measure.Source.NullProcessing = NullProcessing.Preserve;
}
}

database.Cubes.GetByName(cubeName).MeasureGroups.GetByName(cubeName).Process();
cube.Process(ProcessType.ProcessFull);

I am able to process the cube. but by opening the cube using SSDT, the measure NullProcessing property is not updated.

Thanks,

Narendra

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
436 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,242 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points
    2020-10-26T07:30:09.51+00:00

    Hi,

    Where have you implement this code snippet ? A little background could help us to understand the full scene better.
    Also you could try Martin's professional support by opening ticket with MS.


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.