Hi all Onestream stores a lot of information using an integer ID instead
of a name. And most of the time we also deliver a simple way, to get
objects (or names of objects) using an api or brapi call. Somehow
getting the name of a dimension from its I...
I want to round the values for the Revenue account for all UD2 members
to whole numbers. Do I have to get the values, round them and write the
value, or is there a simpler method?
Every cubeview, quickview and also every retrieve function in
spreadsheet or excel has drill down to stage out of the box: Select the
cell -> right mouse click -> select drill down -> drill down to a base
member -> right mouse click -> drill to stage...
You can launch a custom business rule to load from a datatable or a csv
file using a calculation. Query the table or load a file (you will find
samples in the snippets) Loop the rows/lines Identify the pov Use a
calculation API.data.calculate($“{pov}...
It depends, where you launch the request from, if it is a cubeview
stored in a workspace, it first trys to find the parameter in its own
workspace. All classically stored cubeviews are located in the Default
workspace.