Skip to main content
Newcomer
July 19, 2024
Solved

Composite Transformation Rule with Range and List

  • July 19, 2024
  • 3 replies
  • 0 views

I need to create a composite mapping :

For UD2, If Account is in range of 6099* and 6999* and UD2 is  [123 or 124], then UD2 is 100.

In UD2 composite,

If I put rule expression in composite like:   A#6099*~6999*     Target 100,  it works.

But, I put expression in composite like:   A#6099*~6999* : UD2#123;124   Target 100. It does not work.

It is ok, if I can even make  A#6099*~6999* : UD2#123 work. I can split above in 2 lines for list. But, I need condition for range and another dimension member.

Any suggestions?

 

Best answer by TT8

Below mapping works:

A#[6099*~6999*]: U2#[123;124;12000] works

3 replies

TT8Author
Newcomer
July 19, 2024

It is resolved. Please ignore above thread.

OneStream Employee
July 19, 2024

For those that would like know, would you be kind enough how you resolved it

Thank you.

TT8AuthorAnswer
Newcomer
July 22, 2024

Below mapping works:

A#[6099*~6999*]: U2#[123;124;12000] works