Filter on Account Dimension in SAC Model or Story

[jyothirmayee_s]

Hi,
As the Account dimension in SAC Planning is not feasible, is there a way to restrict a range of GL Accounts in a SAC story or at the Planning model please?

I tried both in Optimized and Classic mode but in vain. 

Any insights are helpful.

Thanks,

Jothi

[William_Yu1]

Hi jyothirmayee_s, 

  Account dimension in table widget doesn't support filter by range yet. Instead, you can filter on account in table by select member, parent node, or property. 

William

[gb_ithude]

Hi William_Yu

I'm trying to apply a filter on the property of my account dimension but i get an error in the table:

Warnings

Server Warning (2)

Invalid filter : Invalid filter, flat filters on attributes of the account dimension are not supported ([VDB.TIPBDG].[VDB.TIPBDG]). Query result may not be as expected.

Invalid filter : Invalid filter, flat filters on attributes of the account dimension are not supported ([VDB.CDR].[VDB.CDR]). Query result may not be as expected.

"VDB" is the account's name, "TIPBDG" and "CDR" are the properties i need to filter in my table

[William_Yu1]

Seems it's warning only. Does your table return any data? If yes, please verify your data returned.

[gb_ithude]

No, the table shows the data only without those filters