SAC ANALYTICS DESIGNER - use dimension member property value to setDimensionFilter

[former_member720276]

Hello,

I need to use dimension member property in my script.

Lets say, I have dimension "Version" with property "YrMth".

Property "YrMth" has value "202001".

I want to write the script in analytical app to show only Date which is maintained in property "YrMth".

How to read the property and use it in script to set the filter in Date Dimension.

Thanks,

Roger.

[chia-yu_wu · Accepted solution]

Hi Roger,

here are some screenshots, hope this helps you get further.

1. Select the table

2. Select Properties shown in the screenshot

3. Select Year Month and click ok

I am not sure though, whether it is possible to blend out the Version Dimension and only show the property.

Cheers,

Chia-Yu

[former_member720276 · Accepted solution]

Hi Chia-Yu

I want to populated Date based on Member maintained in Property of Version Dimension.

Thanks!

Roger

[chia-yu_wu · Accepted solution]

Ah, ok...

I hope i understood your request this time.

What you could do is.

1. save Table_1.getDataSource().getResultSet()[0]["Version"].properties["Version.YrMth"] as a variable

2. find out the syntax of your Date Dimension ID by using console.log(Table_2.getDataSource.getResultSet) and run the application.

3. define the correct Member id from Date Dimension ID, normally looks like this: [Date Dimension ID].[Hierachy].[yyyymm] something like that.

4. then you could use Table_2. getDataSource.setDimensionFilter("Date Dimension ID", "Member ID");

Hope this time, i understood your question 🙂

Cheer,

Chia-Yu

[chia-yu_wu]

Hi roger_2018,

Say if you have a table where you also show the version property, this would be the syntax;

console.log(Table_1.getDataSource().getResultSet()[0]["Version"].properties["Version.YrMth"]);

Hope this helps answering your question.

Cheers,

Chia-Yu

[former_member720276]

Hi Chia-Yu

Thank you so much for your reply.

My requirement is : Desired Analytical App table need to show Dimension "Date" in column with value "201906" that is maintained in "Version" Property "YearMth" against member "Plan".

Please see the attachment for detail view.

Thanks,

Roger