OneStream Community

sudarshan · 03-28-2023

Hi Community, We have a few scheduled calcs and consolidations running on an hourly basis, and sometimes these start queuing up and cause other DM jobs to fail/get cancelled by the system. Is there any good way to monitor or alert the admins via emai...

sudarshan · 05-27-2022

Even a simple globals.getObject("_ex") throws a object reference not found error. Is the use of the globals object prohibited inside a spreadsheet rule? The code: Error log when this spreadsheet rule is used: But if I comment out line number 24, the ...

sudarshan

Hi Saurin, Can you share the syntax of how you were able to do this?

sudarshan · 11-24-2023

Hi, We have a similar use case where we require the hierarchy of a UD to be replaced and not merged. We go with the approach of "Break and Build" using xml to completely replace the existing hierarchy with the new one. First create a break xml for th...

sudarshan · 10-03-2023

Indeed you can, right click on the dimension, choose "Select Members to Extract" And then you can extract only the relationship of the members you want.

Re: Create custom member filter - Tree · 08-11-2023

Hi Jack,Not able to nest expressions like this or maybe I'm doing something wrong. Do you have any other alternatives?Thanks,Sudarshan

sudarshan · 08-09-2023

You can try exploring WINSCP library, there a few examples which you can search for.

OneStream Community

User Statistics

User Activity

Ideas to monitor queued jobs

Globals object in a spreadsheet rule

Re: CubeView Parameters

Re: OS metadata

Re: Metadata Extract

Re: Create custom member filter - Tree

Re: Upload or Download Files using API