SAP Design Studio 1.6 Exclude Not Assigned

[vitran23]

Has anyone had any success using the SetFilter or SetFilterExt to exclude not assigned values of "#"? I've tried the using !# like it shows in the samples but it's not working.

[former_member197738]

Hi Tran,

Before you try restricting through script like using setFilterExt (). Its important to validate the format query accept.

Try restricting in edit initial view. Right Click Dimension "Filter Member'. Then cright click again 'Filter by input String, this way you will get the format of the String.

Now, pass the same you using setFilterExt.

Regards,

Fahad

[vitran23]

Yeah trying to use both those methods of "!#" didn't have any affect on the output.

[former_member234401]

try

DS_1.setFilterExt("your dimension", "!#");

[TammyPowlas]

Please try using the suggestion in this thread, at startup:

https://archive.sap.com/discussions/thread/3592485