SAC Table_1.getDataSource().setDimensionFilter

[Former Member]

Hello ,

I would like to set table measure but it doesn't work :

Table_1.getDataSource().setDimensionFilter("Account","[Account].[parentId].&[amount01]");

Can somebody please advise me.

Thanks

[venkateswaran_k]

Hi, Please elaborate with some examples, - that will help us to understand completely.

[Former Member]

HI,

I have table dimension Customer and measure amount.

I would like to replace table measure amount with amount01

before

Customer amount

C01 100

after

Customer amount01

C01 150

Unfortunately , below statement doesn't work.

Table_1.getDataSource().RemoveDimensionFilter("Account")

Table_1.getDataSource().setDimensionFilter("Account","[Account].[parentId].&[amount01]");