OneStream Platform Forums

Hi, I have account for which I don't want entity aggregation to occur. I have tried using the dimension for aggregation on entity dimension as FALSE but I have not received the desired result and its showing the invalid intersection and hence I am not able to input the numbers at base level. Moreover suggestion on account type are also required. any suggestion would be helpful.

I have a single Connector BR that makes several independent API calls to external systems. When it's called the Task Progress window sits at 11% with the message "Parsing Source Data". I would like to update the task as it goes along so the user knows something is happening.  I found reference to the below snippet but don't know how to properly instantiate the extenderArgs variable. I tried using it with Nothing but it did not seem to work as intended. Is there a sample of how I can do this in a Connector BR? Dim bValue As Boolean = BRApi.TaskActivity.UpdateRunningTaskActivityAndCheckIfCanceled(si, extenderArgs, activityDescription, percentCompleteToAdd)  Thanks.

Hello all, is there a way to export a file to a users local folder (Outside of OS share)? For example the exports drom Data Management or anything that we created in a BR?   I know how to send it to a table/DB, but the question is if i can export directly from OS to a local folder. Am I missing something very obvious?   Thank you in advance

Hi, I have a u8#memberformula that I am trying to use for the first time - to format the background color of a cell. I know that setting  BackgroundColor = pink will cause the cell to turn pink. BackgroundColor = u8#memberfomula my u8#memberformula has only one line: Return "pink"  For unknown reason, 1S is not formating my cells pink ??(I assume the text "pink" is returned by u8#formula) I know my formula is executed by 1S because I put a debug statement in there and it is showing in Error Log that my formula is executed .  

I am trying to clear entered data from the particular Cube but unable to do so using "Clear Data" Rule. Can anyone suggest me the process to clear data from any cube without disturbing other cubes' dataset.

Hi allis there a way to disable the "Create Journal" button  (red)and keep the ""Create Journal using selected template" button (green) I would like to force users to select specific templates where the entity selection is limited to the E#Root.WFProfileEntities So that users cannot make mistakes posting a journal on an entity which is not part of the workflow. Thanks in advance for the help.Marcello  

Hello I have built a workflow structure for a statutory application where every legal entity has is own workflow. In the entity assignment only 1 entity is assigned to the specific workflow. Data load and input forms work fine because Onestream blocks user to enter data on an entity <> from the WF entity. Inside each entity workflow we enabled the user to post adjustments.   But for journals Onestream behaves differently.  Because when creating a journal, Onestream propose the list of companies the user has access to regardless which is the company assigned to the workflow.   Here I am in the workflow of company 1.   But Onestream prompt with the list of entities I have access to. So I can post a journal on entity XYZ on "company 1 workflow". So I am allowed to post a journal on an entity outside the assigned workflow.   Is there a way to force the user to post a journal only to the workflow entity?   Thanks, Marcello      

Hi I am tried to configure a hard error on quarters and warning on off months for IC balances above thresholds.   The error I can use frequency Quarterly but for the warning I want it to run 1,2,4,5 etc.  I tried #TWFYearM1 or just 1 or just M1 but none of them worked.  Help?  Also checked the documentation says nothing about format and there are no examples in Golfstream.

I can use substitution variables across multiple OneStream applications on the same server. Question Credit: Gabriela Columna   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

Hi All, I'm hoping someone can help. I'm trying to create a formula for a planning solution that calculates an average over a dynamic number of time periods but for hundreds of intersections. So essentially I somehow need a data buffer covering multiple time periods that I can then use in my over arching planning formula. The main thought was to loop through the time periods, which is fine, but I can't use an api.data.getdatacell because of the volume of intersections I want to calculate the average for. Is it possible to build up a data buffer in a loop? If only i could create a V#TrailingXmonthavg  formula where I can replace the X with a dynamic value. Any thoughts would be greatly appreciated. Many thanks in advance.

You will get this error during the import step. Reason - The load file doesnt have any data after transformation.( ByPass).  The underlying code looks to summarize the data when it finds nothing, it throws an error.

Hi, I have a number of files in my export folder that were created using a Data-Management step. However, even though I have system admin rights , the option to delete any or all files is 'greyed out'. So, how do I delete them when I have finished downloading them. Also, how do I then delete the 'date' folder as well ?   Thanks Mark

How do I view the POV of the datacell executing BusinessRule.DashboardStringFunction XFBR business rule?I think I can run this statement:Dim viewMember As ViewMember = ViewMember.GetItem(api.Pov.View.MemberPk.MemberId) BRapi.ErrorLog.LogMessage(si, "view = "  & viewMember.tostring) Is there a faster way to view all 10 dimesions in POV of the datacell ? These do not work: Dim POV As POV = ViewMember.GetItem(api.Pov.MemberPk.MemberId) BRapi.ErrorLog.LogMessage(si, "view = "  & POV.tostring)    

Happy Labor Day!!How can I use BusinessRule.DashboardStringFunction, i.e. XFBR string business rules to extract text out of a datacell in cubeview that has users' text stored in V#Annotations?We have successfully used XFBR string business rules to extract amounts from datacell in cubeview. However, when I tried similar lines of XFBR code in my cubeview – I am not able to pull users’ text.It is returning zero. Users are putting text into CV cell that has this combination - A#Explaination:U8#Comment:V#Annotations . Here are a few lines the don’t seem to work1)Dim Explain As DataCell Explain = BRApi.Finance.Data.GetDataCellUsingMemberScript(si, cube,"A#Explaination:U8#Comment:V#Annotations" ).DataCellEx.DataCell2) I tried the next line:Explain = BRApi.Finance.Data.GetDataCellUsingMemberScript(si,"A#Explaination:U8#Comment:V#Annotations" ).DataCellAnnotationbut I get the error message : " Does not recognize .DataCellAnnotation. 1) Error at line 71: 'DataCellAnnotation' is not a member of '

Hi All,How do I extract all the RCM account inventory to an excel csv file? I'm able to export page by page, but wondering if there is a quicker way to export all 10-15 pages. 

Hello All, It might sound like a simple question but I could not find the code in snippet or elsewhere of how to grab in a rule a list of all groups a user is part of. Could someone share how to do that ? Thank you Matthieu

Hello All,   I'd like to know if there is a way to have/combine somehow in a Cube View the fact to have the collapse/expand function that the .Tree expansion provides while still applying a filter on the member we want to render below the top member. Something like this in essence : TopMember.Tree.Where (text1 = 2). Seems we cannot apply a where clause on .Tree expansion, and I would anyway expect that the collapse/expand option is not active anymore when we start to filter with a where clause but I'm trying to explore options that would allow to meet this kind of requirement Thank you in advance for your feedback Matthieu

Hi,This is probably not something I can do. But I was wondering if it's possible to automatically lable a tab in excel witht he name of the cube view I download? It would be a great time saver when I'm dowloading multiple cube vews or creating a book. I haven't been able to find anuthing in the Academy site on that. Thanks in advance

Hi Team, We are creating a template in the input form to enter data. Is there any way to suppress the rows with no value while extracting the same form into the spreadsheet? Also can anybody suggest how to retain the spreadsheet format with multiple refresh?

Hi all, How can I run a batch file from a Workflow within OneStream?

We have added a new dimension and associated transformation rules. Previously this dimension we set to 'None' through a static value text definer from the Data Source.I have removed this and now added the respective transformation rules needed, however when retransforming the data, this new UD is still defaulting and sitting as 'None' Any ideas? Or do we need to remove all the data files themselves and reupload to update the mappings? 

  I can change accounts and entities by scenario, just using scenario views 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

Is there any way to edit Transformation Rules in Bulk?When I try loading a trx file or xml code into the system it doesn't overwrite the rules which causes issues in someplace.Is there a way or a template where with direct upload I can delete that transformation group and create a new one with the same name. (Example- Dimension delete template where uploading a certain xml file directly deletes some dimension members)Thanks.

Can we use an aggregated UD1 with a dynamic calc member in the Flow dimension across two cubes?  We have dynamically calculated members called ‘AggDetail’ in Flow Dimension with a rule on member formulas which aggregate base UD1 by entity dynamically.  All our base cost centers (UD1) are in the Financial Detail cube in the dimension library and this ‘FinancialDetail’ cube is called out in the dynamic calc rule. However, we have recently added a new sub parent in flow dimension under the “Financial” cube and it seems like this dynamically calculated flow member “AggDetail” is not aggregating the result for this new sub parent from the Financial cube. This is kind of close critical and see if anyone knows how to solve this in OneStream. If you know the solution, please reply to me here as quickly as possible. Thank you

Hi All, Is there a way to integrate OneStream with Hyperion to extract data from Hyperion without user intervention?