SAC Measure input control doesn't work

[ypinchuk]

Hi SAC Experts,

In a SAC story, I tried to create input control based on the calculated measure. 

This measure appeared in the list of available measures 

but didn't filter the table (I wanted only lines with 1 to be present).

The measure calculation refers to the Date dimension. The Date dimension is set up to show unbooked values, nevertheless, the filter didn't work either with booked dates or unbooked ones. 

In addition, another measure above - Age - is also a calculated measure, but it didn't even appear in the list of available ones for the filter.

Please, could you advise what could be the reason for this and how to make things work?

Thank you,

Yuri

[Vivek-Varma]

Hello @ypinchuk ,

One solution that can be considered is to create an Account/Measure-Based Dimension, select the account/measure based on which you want this dimension to be made and check "Use Account Values as dimension members". (please refer to below image)

This will directly use the measure values and you won't have to specify range conditions.

Please let me know if this solution works for you.

[ypinchuk]

Hi Vivek, unfortunately it doesn't help. I created the measure-based dimension as you suggest but it didn't impact the table neither as input control, nor as filter set in table builder.

[N1kh1l]

@ypinchuk 

If you go with measure based filter you might not able to plan in the table. Instead of measure based filter, try creating a measure based dimension using the measure values to create dimension category. Make sure you cover all possible values for the measure including null. Then you can use this dimension to filter the table.

Nikhil

[ypinchuk]

Nikhil, it's analytic table, not planning. I created a measure based dimension but it doesn't work with unbooked date members