Additional argument in PALO.DATA function to omit hashtag (#) sign for data splashing
There are uses cases when data input on consolidated level is required and using # is only an additional step for end-user. PALO.DATA function should have an optional argument that would enable inputs on consolidated levels without using #.
ADMIN RESPONSE
Nov 13, 2020
Hi. This is a good idea. We are looking to methods to make splashing more flexible. While we cannot commit to a specific target version, we will consider adding it to our future internal backlog.
This is a must-have. This could actually help a lot when planning state measure (like FTE). Use Case: you have a dimension Employee and Month, you must plan FTE:
EmployeeX from 2027-01 until 2027-12
from 2027-01 to 2027-08 he has 0.5
from 2027-09 to 2027-12 he has 1
there are several possibilities to achieve that:
you input each month => not ideal you splash on YTG element => not ideal, especially for "normal" users you use extra measures => not ideal, this complexifies the setup with extra rules
now if you can splash without any operator (or pass it automatically to the function), this can be achieved quite easily. this can also replace some SVS routines
This is a must-have. This could actually help a lot when planning state measure (like FTE). Use Case: you have a dimension Employee and Month, you must plan FTE:
EmployeeX from 2027-01 until 2027-12
from 2027-01 to 2027-08 he has 0.5
from 2027-09 to 2027-12 he has 1
there are several possibilities to achieve that:
you input each month => not ideal
you splash on YTG element => not ideal, especially for "normal" users
you use extra measures => not ideal, this complexifies the setup with extra rules
now if you can splash without any operator (or pass it automatically to the function), this can be achieved quite easily. this can also replace some SVS routines