Discuss the features and functionality of OneStream.
Recently active
"Cube" is another name for the Financial Model Question Credit: Nick Hymes Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
Hello OneStream Community; I am trying to copy "Actual" Scenario to a "Plan" Scenario. the Plan Scenario uses Summary Account structure and the Actual Scenario uses a detail account structure which is a Extension of the Summary Account (so a base account member in the summary hierarchy used by Plan could be a parent in the detail account structure used by Actual). I am using a member formula in the Scenario dimension as below, using the "Option" member filter so that only base accounts in the summary account structure used by the Plan scenario is copied over from Actuals. But this is not working, since only base accounts in both the Summary (Plan) & Detail (Actual) account structure is copied over, the parent accounts in the detail account structure in the Actual scenario are not copied over. Any suggestion/help in the right direction would be greatly appreciated. - thanks Kumar api.Data.Calculate("E#WWPlanEntity:S#MultiYrActOL:V#Periodic = E#WW
HI I am trying to automate a data extract process to send data from OneStream to another system eg Anaplan. I have a data Mgmt job to Export the data to a CSV on the file share. I now want to move that CSV file from the file share to say my desktop for example (or any other file storage place). Has anyone done any routine like that? If so is there any BR in OneStream that can be used for that. I havent done this before but sure others may have come across this so just wondered what the best approach would be. Thanks!Tahir
Hi, when creating a Finance business rule, the proposed business rule template has a Main public function and a "Select case api.FunctionType" in it. What is a FinanceFunctionType? And if I want to be able to call the business rule from a Data management step (execute business rule step), within which FinanceFunctionType should the code to execute be included? Thank you
Ad Hoc Analysis is a way to use a spreadsheet environment to report on data loaded into the Cube. Question Credit: Becca Speese Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
Is there a way of setting the selected cell in a cube view when this is refreshed. As far as I can see this defaults to the top left data cell. It would be useful if this could be set using a business rule or a parameter.
Hi, Do you know if there is a way to display in a Dashboard where a Member name is used in the application (in which Cube Views...) ? Thanks, Regards, Harry
Statement: I can use global variables. Question Credit: Peter Fugere Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
Hello OS Community, I noticed there was a variable for suppressing no data records when using the FdxExecuteDataUnit function. Is there a way to bypass zero data records? Thanks in advance for your help! Clifton
Originally posted by Colin ONeillI would like to add an Excel "cube view run time" time-stamp to a cube view report. But I have been unable to find a way to do that. I can't be the first person with this question.
Hi, Is there a way to audit (in a report...) for all cube views, which one refers to a column or row cube view template ? Thanks. Regards, Harry
I have a set of Controller level users for Audit reasons don't have access to load or modify data. I am wanting them to be able to enter Variance Comments. The answer maybe obvious, but I wanted to be sure. Do I have to grant them access to load data to these data points to be able to also enter their comments?
In order to see data, are all 18 dimensions used Question Credit: Nick Hymes Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
Hello, Does anyone know how to turn off the Quickpost function for journal entries? Regards, Ronnie Karpinski
Hello,Has anyone experienced partial uploads when using the XFSET formula? Does anyone know if there is a way to set XFSET uploads to only upload data if there aren't any errors? Regards,Ronnie
Our team has been working through an Infrastructure project, which requires pulling task activity from the Framework Database. When pulled directly from the database, we see task activity type in numeric format. To get the descriptions I ran an comparison by extracting the Task Activity dashboard tool and was able to identify the below descriptions: (CASEWHEN a.TaskActivityType= -1 THEN 'Unknown'WHEN a.TaskActivityType=10 THEN 'Recycle Application Server'WHEN a.TaskActivityType=100 THEN 'Get Data Cells'WHEN a.TaskActivityType=101 THEN 'Get Data Cells Using Script'WHEN a.TaskActivityType=110 THEN 'Cube View'WHEN a.TaskActivityType=111 THEN 'Cube View Report'WHEN a.TaskActivityType=112 THEN 'Export Cube View To Excel'WHEN a.TaskActivityType=120 THEN 'Quick View'WHEN a.TaskActivityType=200 THEN 'Book'WHEN a.TaskActivityType=1000 THEN 'Data Management'WHEN a.TaskActivityType=1100 THEN 'Data Management Scheduled Task'WHEN a.TaskActivityType=2000 THEN 'Load And Transform'WH
Hi all,I have an issue whereby I'm loading our company actuals into OneStream, but if a General Ledger code has no data in it but had data in previous months, I think OneStream assumes the YTD value to be zero and so the opposite total of the previous months is being loaded.So for example the YTD total of repairs & maintenance may be £100 at Apr-22, and in May-22 there are no further transactions so the YTD position is still £100. However as no transactions occurred in May, when the data is loaded -£100 appears in May.I've checked the DateSource and TransformationRules we have set up, I cant see a reason why this would be happening as it's all set up as 'Periodic', and so only the data from the initial load should be include.Does anyone have any ideas as to where the problem my lie, or where I could look to try and see why this is happening?Many thanks,Ged
Is it possible to pull up a linked dashboard by using a button component instead of having to right click on a cell. I want the user to be able to click on a cell in a cube view, then click a button that pulls up another cube view showing the detail. I am using two bound parameters for account and department within the dashboard.
This seems very standard, so I have to be missing something. I have the row filter on a Cubeview "A#6020.TreeDescendantsInclusiveR". 6020 is the total line for all the single level descendants. How do I get only the last descendant to be underlined in the report before the Total line of 6020?
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, 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,
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.
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?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.