OneStream Community

Clarke_Hair · 06-22-2023

We have 40 or so monthly Cert Questions over 50 Entities. Currently we are running the report and then comparing answers to last months report to find any changes in answers. Those changes require us to check on why. From No to Yes or Yes to No, we h...

Clarke_Hair · 05-18-2023

My CFO would like to be able to select a combination of children in our Department Dim and see our Net Income. Is there a way to dynamically calc that value. In the list below, he is asking if he can select to exclude IT from his query. We use FXGets...

Clarke_Hair · 01-11-2023

We have created a book that when run outputs an Excel file that is 67 tabs. It can take 20+ minutes to run on our desktop Clients and many times will time out if we are at home vs. in the office. Anybody ever created something that would allow this b...

Clarke_Hair · 10-27-2022

We built only our different types of security (Data, WF, Access, Certify...) into Hierarchical structures. When using the SAR solution, it just lists all roles and does not say it is direct or indirect so for some users the list is very long. This ha...

Clarke_Hair · 10-10-2022

Installed ACM after our latest upgrade to 7.0.1, created a number of Security Flows and all work just fine until the Commit set where they all fail. Anybody have a Security Add/Update/Delete Flow that is working in OS 7.0.1. I have noticed that the n...

Clarke_Hair · 06-26-2023

I will give this a go and see what we can workout. Thanks for the suggestin.

Clarke_Hair · 05-22-2023

Thanks, It was a long shot on the FXGet (My accounting grp loves them). Think now we are going split into two methods. Smaller reports (non-dynamic/licensed users) will use references back to fixed FXGet (we have an Excel guru who can build the logic...

Clarke_Hair · 05-18-2023

Was thinking. Can you pass a parameter in FXGet. Idea would be to create a Member with formula and you pass the values in that dim that you want to sum together. So in the example above you would pass #Member Name#, HR, Finance. The member would be a...

Clarke_Hair · 01-13-2023

Thanks, found the files, now just have to get them to have data :). Will get there at some point. Going to try ckattookaran's process as well.

Clarke_Hair · 01-12-2023

Thanks for pointing me to the Doc's What it said do, is what I had been doing but nothing was getting created and was running way too fast. Can you look at the below and let me know if you see anything that looks wrong.When I run it, it takes about 1...

OneStream Community

User Statistics

User Activity

Certification Questions - Require something if answer changes from period to period

Query Parent member less a child vs. Alt rollups in a Dim * Can you have a query that works *

Data Mgt job that runs a Dashboard or Book and saves output to Application File storage

User Security - Direct vs. Inherited (Audit) * How to report where it comes from

ACM (630/201) Security Failing at Commit step (OS- 7.0.1.13612)

Re: Certification Questions - Require something if answer changes from period to period

Re: Query Parent member less a child vs. Alt rollups in a Dim *** Can you have a query that works *

Re: Query Parent member less a child vs. Alt rollups in a Dim *** Can you have a query that works *

Re: Data Mgt job that runs a Dashboard or Book and saves output to Application File storage

Re: Data Mgt job that runs a Dashboard or Book and saves output to Application File storage