Dynamic filter in SAC based on Property select members based on dimension property

[UmaArjunan]

Dear Experts,

In SAC 2023 current version Is it supporting to Select members or filter members based on the dimension attributes ?

Please advise

Thanks!

[N1kh1l · Accepted solution]

abap.dev

For Advanced Formula its not possible to use attributes to filter selection in prompts parameters. It supports only members. You can use attributes in the Formula code block though to filter out members in IF ENDIF block.

Hope this helps.

Nikhil

[UmaArjunan · Accepted solution]

with in IF and ENDIF block any other command would work to skip certain dimension members from writing the data during the posting of final results / can write any log message to Data action monitor

[N1kh1l · Accepted solution]

abap.dev

I am not sure of what you are trying to achieve but if you want to skip certain members from being written, The IF ENDIF should only check for TRUE condition. For e.g. If I only want to write back to first Quarter months I will structure my IF like below.

IF [d/Date].[p/QUARTERDESC]="Q1" THEN
	DATA()=1 // sample data
ENDIF

Also you can only scope the records based on a member attribute so that my dataset gets restricted in first place itself.

MEMBERSET[d/Date].[p/YEAR]="2023"

I would suggest you better explain your actual requirement to help you better.

Nikhil