OneStream Community

GorkemSenol · 04-03-2024

Hi, I have this workbook with 2 spreadsheets. 1. A tableview retrieving data from a Custom table. 2. A sheet with a lot of formulas to calculate some numbers. When I try to copy a cell or range of cell from the second sheet it gives an error saying '...

GorkemSenol · 03-15-2024

Hi, I have a Spreadsheet BR that creates a tableview and I want a certain dashboard extender function to be triggered when they submit the data from the tableview(spreadsheet) I think this is the way to go but probably because of the namespace, I can...

GorkemSenol · 12-14-2023

Hi all, I'm trying to find a way to extract comments and text inputs using a data management job. OS doesn't let me select V#VarianceExplanation member in the dataunit section. Error processing Data Management Step 'ExportComments'. Non-numeric View ...

GorkemSenol · 11-07-2023

Hi everyone,I have a case in my hand I'd like to get your opinions on. I have an 12 period application already built so custom time dimension is not an option.The request is:1. The client wants the P12 results to be available for reporting but the P1...

GorkemSenol · 09-01-2023

Hello everyone,I have 2 scenarios in my application: Stat and Management. There is this one entity is not getting consolidated in the stat whereas it's getting consolidated in the management structure like any other entity.I realized the system elimi...

GorkemSenol · 03-18-2024

Hi Robb, This is gold, thanks a lot. Do you think I can reference to the MainClass in the Extender Rule rather than ExtraFunctions in your example? I guess that is creating a problem for me since MainClass is also being used in the Spreadsheet rule r...

GorkemSenol · 12-21-2023

Thanks Cosimo, I realized there was something wrong with how I set up the parameter. I'm also struggling to get the result of the parameter selection and use it to filter the SQL. Can you let me know how did you achieve that? I want OS to filter the ...

GorkemSenol · 12-21-2023

Hi all, Thanks for the help. I created the SQL and used left join to the member table to get the descriptions. Now I am able to get the data I need using a Table View. Only question I have now is regarding the parameters. I tried to use a parameter d...

GorkemSenol · 12-21-2023

Hi both, Maybe a silly question but when I add the parameter it just gives me a textbox to input a value for the dimension. Is it possible to present the user with a memberdialog or a list?

GorkemSenol · 09-05-2023

Currently 0. Because that entity is not getting consolidated at the moment.Do you think if it's possible to create some kind of custom script to delete O#Elimination if the IC# an entity with an ownership type Equity for example?

OneStream Community

User Statistics

User Activity

Spreadsheet error when I try copy/paste DocumentModel.IsCopyCutMode is false

How to call a dashboard extender function from a Spreadsheet type BR?

Extracting Annotations

Handling P13 in a consolidation application

Is it possible to block elimination from happening if it's booked against certain (Equity) entities?

Re: How to call a dashboard extender function from a Spreadsheet type BR?

Re: Prompting for parameters for Tableview

Re: Extracting Annotations

Re: Prompting for parameters for Tableview

Re: Is it possible to block elimination from happening if it's booked against certain (Equity) entit