OneStream Platform Forums

Hi, we have 40-50 workflow nodes which makes the workflow assignment a large burden to complete.  We are using workflow templates to manage these nodes.  Is there a way to assign the workflow to the template vs each individual node in the workflow?

I'm getting this content back from the REST calls to a data adapter: null   Here are some headers:StatusCode: OK, Content-Type: application/json; charset=utf-8, Content-Length: 4   There is no failure, just a "null" content where JSON should be. There is nothing in the onestream error log. It seems to happen a large percentage of the time (20% or so).  What should I do to investigate?  Is it ever the expected behavior that the API will return HTTP-OK with the word "null"? Using version 6.5.0.12623.      

Hello, Is there a way to aggregate the result of an expansion within a member filter?  For example, I have multiple entities that are Australian.  I would like to aggregate the balances of all of those entities into a single row.  I'm using the attached syntax which produces the entire list, but I would like all the results to be aggregated into one line item without all the underlying detail.  Does anyone know of a solution? Thanks, Sean

Has anyone come across a simple way to incorporate user input values with a Quick View?  Our users very much prefer the Excel Add-In with Quick Views and tend not to like the predefined nature of cube views.  This has been one of the main sources of frustration expressed since we switched from Hyperion to OneStream about 1.5 years ago. Here is a simple example with the Time dimension of what was frequently done with Hyperion Smart View. An Excel file has 10 tabs, one named Input.  On the Input tab the user enters a Time member in a cell.  The other nine tabs link to that Time cell.  With Smart View the user only had to change one cell no matter how many other tabs there were.  With Quick Views the user has to change the T# value in every Quick View in the file. I know this is a simple example, and if it was always for month-end, something like T#Global could be used, but they wish to be able to set the values for any number of dimensions and only have to s

Hi Fairly new to OS and i am looking for a solution/workaround on MemberName and Description in POV. To explain further, in Quick View when any dimensions is in POV (See attached Pic)  then OS only shows the MembersName not Description. I need to see Description there as my naming convention for UD is Code - Description. Having code to be viewed in POV is tough to track and know what code means.  Thanks in Advance...Sandeep S    

Hi,I have setup the Global drivers in the People Planning module to be XFCell formulas, so that users can input drivers by Period/Scenario via cube views. The formulas look like this one:(XFCell(Cb#People_Planning:E#RU0451:P#GL1151:C#Local:S#Plan:T#|WFTime|:V#Periodic:A#PP_Acc_Driver_DE007:F#None:O#Forms:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None)) The formula works fine as long as the value retrieved is lower than 1000. The reason is that the retrieved value is by default retrieved in the #,###.000 format, which the People Planning module doesn't like. This is an example of error message:Summary: Error processing Data Management Step 'CalculatePlan_PLP'. Unable to execute Business Rule 'PLP_DataMgmt'. Global Driver [DE Max health insurance wage] Expression ErrorNon-Numeric value found after substitution: [Expression Before Substitution =(XFCell(Cb#People_Planning:E#RU0451:P#GL1151:C#Local:S#Plan:T#|WFTime|:V#Periodic:A#PP_Acc_Driver_DE007:F#None:O

Quickviews are not showing in task activity . Is this a bug ? Or is there any other ways to monitor the quickviews launched by users

I am trying to build a cube view where the client can insert suppressed row members for account, ud3, and entity with ud3 having 2000+ members. I can't figure out how to work the suppression so it only shows the top row and allows the user to enter in the suppressed rows without having all combinations visible through expansion. Currently it is showing all possible combinations or no combinations. Thanks in advance for the help!

Is it possible to build a Business Rule (Dashboard Extender) that connects to and updates the Task Scheduler Table without the use of a BRApi?  Our team is currently connecting to the table using BRApi.Database.ExecuteActionQuery.  This function allows users to update the Task Scheduler through a dashboard.  But we would like to find an alternative approach to updating.

Happy end of masking!! We are trying to pass multiple months to: wfClusterPkChild We tried to pass Qtr1.base but we get error message. Any suggestions on how to pass M1, M2 , M3 - which are base level children of Qtr1 ? Here's our code: wfClusterPk = BRAPi.Workflow.General.GetWorkflowUnitClusterPk(si, profileName, scenarioName, timeName) where timename is 2022M1 Dim wfClusterPkChild As New WorkflowUnitClusterPk(profileInfo.ProfileKey, wfClusterPk.ScenarioKey, wfClusterPk.TimeKey) --- where timename is 2022M1 - it works great. However, when we tried to make timename = Qtr1.base, we get error message.   When we try to display using wfClusterPkChild.ToString, we see this "ProfileKey (ffb8c7f5-2cc0-48bb-b483-a2c81cb84875), ScenarioKey (0), TimeKey (2022003000"   wfClusterPkChild= ProfileKey (ffb8c7f5-2cc0-48bb-b483-a2c81cb84875), ScenarioKey (0), TimeKey (2022003000), wfClusterPk.TimeKey = 2022003000 

If each Cost Center is mapped to a single profit center, can that be stored as a Text attribute in the metadata and then referenced in Transformation Rules?

Statement: A parser business rule is commonly used with a data source Question Credit: Chris Bielinski   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   Want more Fact or Fiction? We’ll be hosting a LIVE game show at SPLASH San Antonio! Come participate or you’re welcome to attend. Secure you spot today by contacting Press@OneStreamSoftware.com. We hope to see you there!

What is the best way to design and implement constant fx rate analysis?  We want to apply a budget rate to all months for actual/fc/budget.  Entities are loaded in local currency and I thought it would be simple to use an entity hierarchy in which I'd put the custom rates at the parent level so during consolidation it would use the set fx rates.  Unfortunately this is not working as I had hoped, I'm not seeing a difference at the parent level between the "real" hierarchy and the constant rate hierarchy. Thank you.

Does anyone have any sample code they can share to see how to trap errors during an automated dataload process?  Currently, all I can see is that the dataload process executed and completed but it does not tell you if something happened in between.  I'm having no luck capturing if an error was encountered during the import or validate steps.

I want to add a dotted line to differentiate between scenarios. In this example - we are reporting actuals and forecast -- Any ideas?    Thank you, Mustafa  

OneStream is the best EPM app for consolidation and everything planning - it is going to kill Hyperion / Essbase !!Does anyone have a sample business rule BR for a column (e.g. K) to Accumulate what is in another column (in Cubeview)?I probably have a written something similar long time ago, but would like to see if someone else wrote a better BR.

Happy "end of forced masking" everyone!    Why can't we log in as user administrator recently? We get message "invalid user or password" Maybe Our user administrator is locked out due to too many attempts to login with invalid password. How do I unlock ? (ps. I read OS Design and Reference guide about enabling users - I see that user Administrator is enabled. 

This is my first time creating a book. I'm working on creating a book that presents an income statement by location. The ideal outcome is that the IS is displaying location at the top and each subsequent page displays a child location member.  I have my loop setup as a member filter that references the location dimension as shown below. My change parameter is setup to change the POV.  When I preview the book it's still showing location at TOP for all the pages instead of showing TOP and then each location base member. Any suggestions on how to fix this or any literature would be appreciated.   Thanks.

Hi All - I am trying to copy Base accounts from Actual to Plan Scenario but it is not working when I try to consolidate but it is working when I perform force consolidate. Below is the code and any help would be appreciated.   If ((Not api.Entity.HasChildren()) And (api.Cons.IsLocalCurrencyforEntity())) ThenIf api.Pov.Scenario.Name = "Plan" Thenapi.Data.Calculate("S#Plan = Eval(S#Actual:O#Top:I#Top:U1#Total_CostCenter:U2#Total_ProfitCenter)","A#[Corp_US_Sales].Base",,,,,,,,,,,,AddressOf OnEvalDataBufferScrFilter)Brapi.ErrorLog.LogMessage(si,"APIDATA") End IfEnd If Private Sub OnEvalDataBufferScrFilter(ByVal api As FinanceRulesApi, ByVal evalName As String, ByVal eventArgs As EvalDataBufferEventArgs)TryeventArgs.DataBufferResult.DataBufferCells.Clear()For Each sourceCell As DataBufferCell In eventArgs.DataBuffer1.DataBufferCells.Values'Only process cells that have dataIf (Not sourceCell.CellStatus.IsNoData) Then'Apply filtered source cells with data as the new Data Buffer CellsDim

Hi Community ! Is there a way to get the culture of the user, by using a retrieve function like XFGetCell? Basically, I have to retrieve the user culture in an Excel file in order to define Titles and other periferical elements in the spreadsheet. Regards,

how can i get 2 columns on a quick view to be shown as %? 

We are trying to develop logic to do the following during transformation: If the G/L account in the load is in a certain range and the UD2 member is valid, load to that intersection      otherwise If the G/L account in the load is in that same range but the UD2 member is invalid, map UD2 to None   Has anyone gotten something similar to work?   Thanks,Bil

Hi to all, Im looking for any idea on how to inactivate users automatically. Let me know your thoughts.

Hi to all. Wondering if any of you have been able to connect PowerBI as a data source in Onestream. In this case, PowerBI is an Analysis Service server. any thoughts on how to start doing that?  Thanks in advance

Hi experts, The business users had posted some retained earnings adjustments to both base and parent entities at OwnerPostAdj consolidation level. I have a very simple opening balance rule that works across all entities and consolidation levels: api.Data.Calculate("F#100= RemoveZeros(F#EndBal:T#PovPriorYearM12)","A#<balance sheet accounts>.Base") We are seeing that the opening balance (F#100) member is correctly pulling the OwnerPostAdj numbers for the base entities from prior years, but is not bringing in the opening balance from the parent entities at OwnerPostAdj level. I did a 'Force calculate with logging' and see that the 'ReadDataRecordsinDataUnit' step is showing zero records in the database. However, I can confirm that the journal was posted in M12 at the parent entity and C#OwnerPostAdj level. Any suggestions as to what else I might need to check? Regards, S