OneStream Community

Clarke_Hair

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 · 09-16-2022

Looking to start using the View txt fields (Annotation, Assumptions…) and understand that there is no natural way to have that information aggregated/consolidated up. I am told that a BR is needed to do this. Just checking to see if this is correct a...

Clarke_Hair

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

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...

Clarke_Hair · 10-13-2022

Solution was a known issue with Security Flows and the Multiple Items setting. Needed to check the box for Multiple Items for the commit to work. Requires users to add an item vs. it just defaulting in, but works just fine.

OneStream Community

User Statistics

User Activity

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)

Aggregation of View’s txt fields

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

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