Added Member in Planning Model not showing in the Table

[ferrygun18]

I am quite new to the planning model in SAP Analytics Cloud. I have added the member highlighted in the red box manually in "Generic" dimension Material, but it didn't show up in the table in SAC Analytic App.

I can only see two records here. How can I get the updated records in the table based on the generic dimension Material ?

[former_member6443 · Accepted solution]

Hi Fred,

I see what you mean you have created a Calculated Dimension based on the Properties of the Material Dimension hence the Unbooked Data being blanked out.

Perhaps try the Table_1.isZeroSuppressionEnabled() , that should help you, more information here Product Update

Good luck and you have done so much for SAC community.

Cheers

Afshin

[ferrygun18 · Accepted solution]

Thank you Afshin, it is working perfectly now.

[prasadgurla]

Ferry,

The unbooked, data should be "ENABLED" NOT disabled.

Prasad.

[ferrygun18]

Thank you Prasad, it is working perfectly now.

[prasadgurla]

Unbooked data (as Afshin said) + make sure you have Application.refreshdata() in the right place to update the table.

[ferrygun18]

Unbooked data is disabled...see my comment to Afshin. Thanks.

[former_member6443]

Hi Ferry,

My guess this is using zero suppression so you need to right click on Materials and show Unbooked Data.

I hope this helps

Afshin

[ferrygun18]

Thanks Afshin,

I am unable to show "Unbooked Data" as it says data cannot be shown for tables with dimension properties.