OneStream Platform Forums

Hi,I have persistent derived figures in some calculated accounts that I cannot delete.My account is set with ZeroViewFoNonAdj = YTD, but for some reason the derived figures still appear in Grey in my Cube View:Is there an soft way to clear or reset this (except a Clear/ reset scenario) ?Thank you.Aurélien 

Hi All, Need some help in updating properties of scenario member through an extensibility rule. 'Workflow Time scenarioProperties.WorkflowTime.SetStoredValue(BRApi.Finance.Members.GetMemberId(si, DimType.Time.Id, objUtil.GetCycleFirstQuarter(si, api)))   'Workflow Start TimescenarioProperties.WorkflowStartTime.SetStoredValue(BRApi.Finance.Members.GetMemberId(si, DimType.Time.Id, objUtil.GetWorkflowStartTimeForScenario(si, api)))   'Workflow End TimescenarioProperties.WorkflowEndTime.SetStoredValue(BRApi.Finance.Members.GetMemberId(si, DimType.Time.Id, objUtil.GetWorkflowEndTimeForScenario(si, api)))   The rule compiles fine however fails on execution. Error message received: Error updating member. Invalid parameter 'WorkflowTime'. Would someone please guide me with the correct way to achieve this?

Hi everyone, I have been looking in the marketplace to see if there is any tutorial about 'Best practice' to set up Securities in OneStream. I couldn't find anything. Do you have any approach to suggest? Do you use the Child/Parent group often? It seems like it could become quite messy.. Any comment is very appreciated Thank you in advance

Looking for anyone who has used the CVRC() function successfully in their Cube Views. If so, is there anything special you are doing with the syntax for the Row or Column Index #?According to the OS documentation, I should be able to simply do this:  GetDataCell(CVRC(RowName,RowIndex,ColumnName,ColumnIndex).... ETC.) Example:  GetDataCell(CVRC(MyRowA,1,MyColA,2) + CVRC(MyRowB,2,MyColD,4) But even with the most basic test cube view, the result is always giving me an Invalid Index error.Is there some special way to express the row or column Index # that I'm missing here?Thanks in advance for any advice

Is there an easy or single step way to add a book to run from within another book?  Trying to avoid re-creating the book from scratch just to use elsewhere.

SOURCE: ONESTREAM CHAMPIONSHi Team,Just want to understand, can we customize the standard Drill down reports or may be add 2 more rows in there and call some cube view reports from there.https://discourse-static.influitive.net/uploads/db_8467a788_7b9e_45b8_8b6c_d37e1967220d/original/1X/7e895d9991933241d561622179a47990f62958d3.jpegCustomized Drill down.jpg701×421 61.3 KB Regards and ThanksDarpan Bhansali

Hi All, Has anyone set up a new scenario to load stub period data and is willing to share your experience. I will need to produce financial reports for the full year 2022 and partial year from Aug-22 to Dec-22.  So, I am thinking of copying Aug-22 to Dec-22 actual data to another scenario “Actual22”.  The data will be in USD to avoid translation issues.  However, I am not sure if I should use the same Scenario Type “Actual” for “Actual22” because of the business rules set up in Flow Dimensions for the opening, movements and closingCalc.  What do I need to change if I use Scenario Type “Actual” or another Scenario Type?  What are the other considerations I have missed? Please shed some light. Thank you in advance!

Hi, Is being able to Right click and choose Consolidate in a cube view an admin only function? We have a report where "Can Consolidate" is set to True but users are not able to consolidate from the cube view...they can from a data mgt job. Thanks, Haaris

Hi All,We're currently trying to map IC relationships in the transformation rules where the source data doesn't contain this field. We can map this based on the GL account from the ERP system but just unsure on how to do this in OneStream. Essentially we'd like to use 1-1 mapping but based a different column other than the IC in the source, is this possible?Thanks,

Originally posted by Eric Osmanski 5/15/2020 Is there something up with V#Footnote and V#AuditComment? We have a form where the user needs to enter in comments. There are no conditional input rules in this application or Data Cell Access restrictions on the Cube. If we use V#Annotation, V#Assumptions, or V#VarianceExplanation, then everything is good and the column is open for input. If we use V#Footnote or V#AuditComment, the column is read only. What am I missing?

Hello;  Would it be possible to round a number in a cube view? For example I have a result in cube view which has a value of -839 for an intersection, would it be possible to make this value to -840 using the Round or any other function in a cube view report.    thanks, in advance for any support!  

Hi,Is there a way to find the primary node or secondary node of a member with alternate hierarchies in OneStream like the default parent of a member in Hyperion HFM?

Hello, This is in reference to accepted code sample posted for adding a dimension member through an Extender Business Rule. https://community.onestreamsoftware.com/t5/Accepted-Code-Samples/Extender-Auto-Create-Member/ta-p/6921 SaveMemberInfo Want to understand which tables are impacted by execution of the routine SaveMemberInfo. Does this make entry to the following tables? Member MemberDescription MemberProperty Relationship RelationshipProperty Please mention if I have missed some table here. Also, the article says that audit information is not stored with this save routine. Kindly confirm if below are the audit tables which should have the relevant details: AuditMember AuditMemberDescription AuditMemberProperty AuditRelationship AuditRelationshipProperty Would like to understand in general what information do below tables store? AuditParserDimensionAttributes AuditParserDimensions AuditParserLayouts  

Team   Is there a way we can add long text like comments to the cells through Forms?  Am trying to build a cube view with data and comments to it which is visible on view rather than adding it as "note" or "attachments". Please see the sample image below on the requirement.      

Hi All, Is there any utility rule available which helps to take backup of all the components of the application? This can then be scheduled to take daily/weekly application back ups.  Any leads would be appreciated.  

Hi All, I am trying to get my member formula to calculate an unbalanced balance sheet and I built a Quick View to see the calculation. However, it does not seem to be calculating anything with the member formula.    The following is the member formula under 'Calculation Out of Balance'   If ((Not api.Entity.HasChildren()) And (api.Cons.IsLocalCurrencyForEntity())) Then   api.Data.Calculate("A#Calc_OOB:U1#Manual_Input:F#EndBalLoad:I#None = A#Total_Assets:F#EndBalLoad:I#Top - A#Total_Liability_Equity:U1#Calculations:F#EndBalLoad:I#Top")   End If Any guidance would be greatly appreciated!

We have a bunch of related party accounts that need to equal other locations within the company similar to intercompany. It would be nice if this can be added to the IC matching table that is on the workflow. I do not want these to eliminate but have visibility to the locations that these accounts are out of balance. Has anyone dealt with something similar to this and if so how do you go about it? 

Hi,Do we have a mechanism to map unmapped item to a holding member ( specific member of the dimension) during the data load to prevent data load failure.Thanks 

Hi All -    I am attempting to export Stage Data through a Data Management Job using a Business Rule. The customer is hoping to remove some columns from the export and filter down the data by selecting Entity & UD1 prior to the export. Has anyone ever modified the data export sequence extender rule?     Thanks, Emily 

I'm starting to plan for upgrading our OneStream dev environment from 6.2 up to 7.0.  Part of the testing will have to involve the Excel add-in.  If I uninstall the 6.2 add-in, and install the 7.0 version,  can I still use it with our Production 6.2 environment?  

What is the best approach to choose the first base member in a hierarchy, the following member filters not returning the expected results. E#|CVEntity|.Base.First nor E#|CVEntity|.First.Base or  E#|CVEntity|.Children.First.Base Entity keeps pulling in POV as in CV which is a parent the goal is to pick one single member from the hierarchy for Input  thanks  

I have a tabbed dashboard with three tabs displaying cube views. I would like to give my users the ability to print, export to excel or to pdf with a single action instead of doing so with each cube view individually. I would appreciate any approaches that community can suggest. Thank you.

Hello team, I am trying to get a dump of Yearly data in one table where I will use joins of member table with data records and want to expose this in BI viewer so that analysis can be nicely done on Month on Month, YOY basis etc. however pulling so much data seems problematic and I came to know about a term 'FDX' (Seems Fast data Extraction). Kindly help with some details on it, I could not find any content on this.   Thanks Satish

Hi All, I have a requirement to open a web URL(it is a field in the table) in users default web browser. Current solution: I could do it using the "web content" component in the dashboard. I am capturing the field in a literal parameter and then using it in the web content component to display in a dashboard. It works.  Issue: Dashboard opens the web page in the dashboard window but does not render it properly. The component is pretty basic and does not have any option to customize it. It could be that it is using some costume inbuilt browser type component to display it and may not support all web page components require to display it properly. Looking for: A simple way to open the default browser in the business rule. I am sure there will some VB function which can do it but could not find it yet.  has anyone ever done that? appreciate any help.   

Hi AllIs there a way of clearing data that is already in the application using the XFF file format? I have tried NODATA, nodata and -. I have searched the documentation but I can't find any reference to it.Thanks