OneStream Platform Forums

When loading data through batch file, does transformation event handler invoked the same way as running through manual workflow steps? Also, how can I execute Workflow (import->validate->load) through batch?

Hi All, I need to access parameter A which is present outside default workspace in my cube view. |!A!| this doesnot work as it only pulls the parameters within default workspace.  

Hi all,  I'm encountering an error with one user who is attempting to export a report to Excel. The download process is functioning correctly, and the file is being saved in the OnStream temporary folder. However, the issue arises as OneStream is unable to open the file automatically. It appears to be an issue related to permissions on the user's laptop. Could not find a way to fix it, any ideas? Thanks.  

I need to update the security on a scenario using a dashboard button, is this possible through a dashboard extender rule? Essentially a meeting will take place and certain scenarios will need to be locked down so no one can make changes besides the appropriate security group on the call. I will then need to change it back to the original security settings with a separate button once the meeting is over

I know I can have a different scenario where I can combine actuals and forecast each month with data management job and I can use AllPriorYInearInclusive for Actual columns and AllNextInYearInclusive for Forecast to do this when i want just months. But I want to also have quarters summing 3 months potentially actuals and forecast together if date selected is in middle of quarter. And YTD columns summing actuals and forecast.   Below is example of what i want to achieve. Is there CubeView Extender i can build to make this happen. For Quarter and YTD columns i can just use getdatacell(CVR(Col1)+CVR(Col3)+CVR(Col5)... etc. but i would like to somehow switch actuals to forecast for all future months of WFTime, TimePOV or Parameter selection.

Hello:   Has anyone had any success with grouping columns in a cube view in a report linked to excel, or grouping them as they export? Of course in the data explorer version you can use the tree function and toggle the row expansion mode to get the intended effect, and in rows you have the excel outline settings you can play with. However, there doesn't seem to be a way to manage this using settings. And obviously if you format the cube view when linked them refreshed the column grouping goes away.   Interested to hear and thanks!

Hello OneStream Community,I'm working on how to implement a REST API in OS, but i'm not sure to understand all the steps, i've already read the documentation and i've found it very hard to understand, can anyone please explain how can we implement it in OS what are the steps to follow, i started by downloading and installing POSTMAN for the tests but i don't know what should do i do after, please any help will be much appreciated. I'm also woundering if there any data management that should be used for this Thanks and merry christmas.

Hello OneStream experts: Thank you for the helps in the past. I found this forum is very helpful.  I feel the MultiplyUnbalanced function is very nice and wonder if it can take more than 2 components to multiply. They give an  example: If I want to do A#UnbalancedMultiplication=A#60000 x A#41000:U2#Parts   I can use the following: api.Data.Calculate("A#UnbalancedMultiplication = MultiplyUnbalanced(A#60000, A#41000:U2#Parts, U2#Parts)") But, if I want to do multiply three components A#UnbalancedMultiplication=A#60000 x A#41000:U2#Parts x A#51000:U2#Material how to use the MultiplyUnbalanced function? Thank you in advance for any answers.

Hi all Are there any key short cuts in the business rules editor? Cheers

Hi AllDoes anyone know how to add a carriage return in Annotation text (if it's possible)? We have a Cube View with an annotation member that displays data. Currently the annotation text can take up most of the screen on some rows and it would be really useful to be able to enter a carriage return. I have tried Environment.NewLine, vbCrLf, \r\n, <br>

I would like to apply a member filter on a scenario, which will return a list of a scenarios based on it's properties like Name, Description, WorkflowTime, WorkflowStartTime, and WorkflowEndTime...i.e.  WorkflowTime = |someYear| or WorkflowStartTime = |someYear| or WorkflowEndTime = |someYear|I can do this S#Scenario.where(Name contains paramScenario) I can do this S#Scenario.where(Description contains paramDescription)I cannot do this S#Scenario.where(WorkflowTime = 2025)I cannot do this S#Scenario.where(WorkflowStartTime = 2025)I cannot do this S#Scenario.where(WorkflowEndTime = 2025)What am I missing?

Hi, I'm trying to build a getdataset rule for the first time in ws assembly. I ran into this compile error while setting up service factory, any idea why? Thank you.  

Hi everyone, I am very much new to OneStream but i am not able to see any resources for learning about OneStream. Can someone guide my about finding the right sources for getting started and learn the basics of onestream

Hi, I am using an XFGetCell Formula which references the POV for Time. I would like to use a formula to pull in the period prior to the POV in the same worksheet and keep it dynamic based on the POV.  Any suggestions? If it's not possible to do in the formula, I will need to create a UD8 to return the prior period time.  Does anyone have a ready-made formula for this?  I would greatly appreciate it! Thanks!         Thanks!

Dear all, Could you please advise how to show Text field of Entity member in cube view instead of Entity Name. For example, I have: Entity member with Name A, it has Text1 field Country 1, Entity member with Name B, it has Text1 field Country 2 Entity member with Name C, it has Text1 field Country 2 I would like to show in cube view in rows figures on Country 1 and Country 2 (so I need to aggregate figures of Entity B and C in this row). Could you please advise is it possible? If it isn't possible to aggregate figures, could you please advise if I can simply show three rows Country 1, Country 2, Country 2 in cube view instead of Names.

Hello, it's probably simple question to solve, but I wasn't able to find a solution.Is it possible to display the dimensions (master data) of the query in the cube views?e.g. columns, CV should generate a table with the following: Account | Amount | Cost Centre Number | Cost Centre Name | Profit Centre | Profit Centre Name |... and so on. I have tried it via UD (where the information is located), but I only get the amounts, but not the elements/master data/dimension or description. What am I doing wrong? Thank you!  

G'day, Pls share if there is an Excel template for Cubes like the Metadata Builder for Dims and Workflows.That will help us update OS Dimensions in many Data Cubes with various Scenario Types. TY.

Are there any out box reports available to show constraints by dimension?

I have created a literal value parameter  for entity that I want to refer in my finance rules for calculation.   Can someone share me a code where I can look up values from a parameter I set instead of running a  E#Root.base or something. Running a E#Root.base where txt1='value' is not an option .   Thanks

I have come across a validation error that is kind of vague. I created a new entity, confirmed it is setup the same way as its sibling, and added it to my transformation rules, but my validation step kicks out an error. Any ideas?  

Hi Everyone. I had a Business Rule that checked the Workflow table to see if a scenario was blocked, but it always showed WFProfiles as blocked. I don’t know where this information is coming from, as those WFProfiles were unblocked in the environment but appeared as blocked in the table. How can I verify this information?  

Hi Everyone. What I want to do is change the value of: si.WorkflowClusterPk.ProfileKey What I want to change is the ProfileKey of a Profile that can obtain the value by name. I need to make this change to modify a process that relies solely on the information from this attribute. Therefore, I would be grateful for your assistance.

Dear all, Could you please advise is it possible to combine several cube views into single Excel file and download it from the application? If so, could you please advise how to do that.

Hello All,I want to use application reports Market place solution to get the journals for all workflow profiles. How to achieve this. Currently I get journals for only one workflow profile as per your select WF POV. Is there a way to get the journals for all workflow profiles as a report in one go.Thanks

Hi All I am upgrading the MarketPlace app Reporting Compliance (TCR) so that it has its own separate Workspace (V8.1). I have added the Business Rules as assembly files and they all work. The current environment (V6.8) has a Data Management job to run calculations so I am now adding a Data Management job to the WorkSpace Data Management Groups. The only problem is that when I add a step (type Execute Business Rule) to the Workspace Data Management Step, the drop down list only shows Business Rules in the general Business Rules area and not the file assembly area. How do I get the Workspace specific Business Rules in the Workspace specific Data Management Groups? Thanks