Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
my Trellis container contains a KPI-visualization as master visualization.
The KPI is
=Sum({$< [%PK_ORDER]= {$(vDimValue)}, RESULT-={0}, RULE_NAME={'FIT NOTES'}>} FREQUENCY)
The dimension of the Trellis container is %PK_ORDER
In the trellis container $(vDimValue) is transformed into ‘1’ (1 is a value of the dimension %PK_ORDER) as expected and the visualization works fine.
BUT!
As I change the KPI to
=Sum({< $(vDimSet),RESULT-={0}, RULE_NAME={'FIT NOTES'}>} FREQUENCY)
$(vDimSet) in trellis container turns into ,[=[%PK_ORDER]]={‘1’} which is not the expected result.
I would have expected [%PK_ORDER]={‘1’} and of cause the trellis container doesn’t show a mean full result.
What did I misunderstood? Syntax error?
Best regards
Ruediger
Hi Ruediger,
A bit late though, but I had similar problems. According to what I see is that $(vDimSet) always has a preceding comma, therefore place it at the end of your set analysis statement.
I do agree that this is somewhat strange (not sure of a syntax error). I cannot think of any good reason to force one into a prescribed order in the set. If someone does, please enlighten me 😉
Regards,
Joost