Knowledge Base Article

Cool CubeViews with Custom GetDataCell Functions

"Hey boss, look a this Cube View I made - it shows our EUR Fx rates against all currencies in our app. Cool, uh?" "FX rates we loaded last month aren't cool. You know what's cool?" "... You?" "...
Updated 2 years ago
Version 2.0
dashboards
rules
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

MarkBird I expect CVC/CVR will only be recognised in a regular GetDataCell script - where you have them now is effectively in the BR declaration so they probably won't be resolved, I guess the function will receive the string "CVC(Col2)" instead.

I think Substitution Variables and Parameters should work though, so you can try to be clever with them.