The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

BarryC's avatar
BarryC
New Contributor II
4 years ago

Calc’d A# with ‘VaryByTimeId ’

SOURCE: ONESTREAM CHAMPIONS Hi all, I’m largely self taught with vb, but have hit a wall with this, and thought I’d share here rather than ask the OS helpdesk, as it seems to be something that co...
Finance
Cosimo's avatar
Cosimo
Contributor II
4 years ago

Also want to add that UDX# in your calc formula is not valid. In the OS reference guide, they mention UDX though the X represents a value from 1 to 8 (i.e. dimensions UD1 to UD8).

You’ll most likely get an error once you get to the api.data.calculate line.

BarryC's avatar
BarryC
New Contributor II
4 years ago

Thanks, Michael, and yes Cosimo I used UDX to represent UD’s in string rather than list them out (as per OS reference guide). Here at Dyson we use all eight UD’s in our main cube and they wouldn’t have added anything to the query