OneStream Community

Montreux · 04-09-2024

I have a column template an the final column the client would like to make comments. This is the V#Annotation. I am doing balance sheet planning and have in the rows a mix of V#Periodic for flows and V#YTD for the balances. The views in the rows take...

Montreux · 11-22-2023

I have an input sheet in which data can be entered for an override of another number. The Cell Status "Is Real Data" flag is used in a rule. If an override is entered in the early part of the monthly year but not later parts a derived amount of 0 is ...

Montreux · 06-23-2023

Hi,I have a custom SQL table for people planning and want an ID field as my primary key. (The existing fields that would be good for a primary key need to editable (e.g. entry date) so I cannot use a set of existing fields as my primary key. Setting ...

Montreux · 06-21-2023

I have a dashboard with graphs and on the side a series of buttons opening input forms for key assumptions. The forms are usually cube views and sometimes a combo box. I would like the pop up dashboards with the input forms to auto size to the conten...

Montreux · 05-23-2023

Hi,I want to use the XFMemberProperty in a cube view to call the number of no input periods in a scenario. This isn't returning a number though or anything. I get an error.XFMemberProperty(DimType=Scenario, Member=|WFScenario|, Property=NumberOfNoInp...

Montreux · 04-09-2024

Thanks for the ideas!  I'll consider these but one should work for me.  

Montreux · 04-09-2024

x

Montreux · 11-28-2023

Ok, a derived/ notReal zero would be what I would expect from the copy process, not a notDerived/real 0. I will write a rule to copy data going forward. Thanks.

Montreux · 11-27-2023

Sure, here is the DM job for Copy Data, And here are the settings of the basecase and target scenarios, Here is the copied scenario's cell status, Simulation 2, Here is the original scenario, Basecase,

Montreux · 06-26-2023

This makes a lot of sense now. Running the rule to first validate, then set the ID, then save is the order I'm looking for. Thanks a lot!

OneStream Community

User Statistics

User Activity

Row Overrides in a Column Template

Copy Data Data Management Step and Derived Real Data

ID Field in Custom SQL and Setting a Unique Default for New Rows

Dashboard components pop up auto-size to conent

XFMemberProperty Property NumberOfNoInputPeriodsPerWorkflowUnit

Re: Row Overrides in a Column Template

Re: Cube View Row Overrides for Shared Column

Re: Copy Data Data Management Step and Derived Real Data

Re: Copy Data Data Management Step and Derived Real Data

Re: ID Field in Custom SQL and Setting a Unique Default for New Rows