OneStream Platform Forums

I am looking to extract the data of a selected row in a grid view by click a button inside a dashboard;  

Hi Community...!    I want to perform Threshold operation in FDX report using SQL Query.. Anyone who knows please share the format for reference... Thank You...!               

Hi,  We are thinking of implementing People Planning module. As this has been floated as plug-n-play solution, we want to see if we can build it ourselves or build majority of it. What is the best way to know more about it? I see some documentation but is it good idea to download the People Planning module and look at the design of that? We have GolfStream demo but not sure if it has latest version of People planning. Any info on this is appreciated.   Thank you, PM

I have declared CurrYear and CurrMonth to retrive year and month respectively. Dim CurrTime As String = api.Pov.Time.NameDim CurrYear As Integer = TimeDimHelper.GetSubComponentsFromName(CurrTime).YearDim CurrMonth As Integer = TimeDimHelper.GetSubComponentNameFromName(currTime).Month can you help me to retrieve month in CurrMonth? 

Hi , In one of my report the user want to show a column for audit which will show who commented for that variance explanation intersection, can you please help me to get this audit. Please let me know if any more information required. 

Hi Guys,  I'm at a project where we use Data Cell Detail, we have created classifications and added 2 lines of test data. I can find the data via a data adapter Method query: But now i want to add it via a BRApi, i've found a post here but what ever I try i cannot get it to work. I have a cube view with 2 columns and the only difference is the UD8 member, so i first want to get the current data cell POV and set UD8 to None: Dim objMbrScrBldr = New MemberScriptBuilder() 'Apply current POV to memberscript and override UD8 api.Data.ApplyDataCellPkToMemberScriptBuilder(objMbrScrBldr, api.pov.GetDataCellPk(), True, True, True, True) objMbrScrBldr.SetUD8("None") Then I call the datacell containing the amount:  'Return the sum of the DataCells that contain the selected Classification Dim objDataCell As DataCellInfoUsingMemberScript = BRApi.Finance.Data.GetDataCellUsingMemberScript(si, api.Pov.cube.name, objMbrScrBldr.GetMemberScript()) and check if the data has DataCellDetail: I

api.Data.Calculate("A#FCTR:F#EndBalanceLoad:I#None:O#Import:V#YTD:U1#00000:U2#00:U3#GL:U4#0000:U5#00:U6#00:U7#None:U8#None = A#Assets:F#EndBalance:I#Top:O#Top:V#YTD:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:U7#None:U8#None:C#Share - A#Liabilities:F#EndBalance:I#Top:O#Top:V#YTD:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:U7#None:U8#None:C#Share - A#Equity:F#EndBalance:I#Top:O#Top:V#YTD:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:U7#None:U8#None:C#Share") Error in formula: Error processing source script 'A#Assets:F#EndBalanceLoad:V#YTD:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:C#Share' or destination script 'A#FCTR:F#EndBalanceLoad:V#YTD:O#Import:I#None:U1#00000:U2#00:U3#GL:U4#0000:U5#00:U6#00'.Error processing data. The item was not found. Entity, Parent, -1.

I have the existing BR rule to export the region hierarchy which is working for last one year without any issues and I am trying to reuse the BR rule for country hierarchy export purpose. I copied & pasted the BR rules, and I am getting the error below while compling. Can you suggest what are all the possibilities to check these issues?   1) Error at line 313: Type 'SessionOptions' is not defined. 2) Error at line 315: 'Protocol' is not declared. It may be inaccessible due to its protection level. 3) Error at line 324: Type 'Session' is not defined. 4) Error at line 329: Type 'PGPLib' is not defined. 5) Error at line 338: Type 'TransferOptions' is not defined. 6) Error at line 339: Type 'TransferOperationResult' is not defined. 7) Error at line 340: 'TransferMode' is not declared. It may be inaccessible due to its protection level. 😎 Warning at line 18: Namespace or type specified in the Imports 'WinScp' doesn't contain any public member or cannot be found. Make sure the name

Hello, When we configure a linked CV from a source CV and that we input and save something in this linked CV, by default when we close this pop up window, updated or added data does not show in original CV. We need to manually refresh the source CV to see update of input done in linked CV. Does anyone know of a way to automate the refresh of the source CV upon closing the linked CV's pop up window? Thanks for your help!

Hi All,   How can we map one source column (from our old EPM system) to two different dimensions in onestream (Flow and UD2) In this column we have for example acdclosing whichs need to be mapped to the flow dimension but acdCD needs to me mapped to the UD2.   Thanks in advance for the help!

How can I download the intercompany matching reports it does not appear on my app. I tried to download it through Market place report package and I load up the zip file but nothing appears. 

Hello,  My colleague and I retrieved OneStream data using Quick view XX and noticed that there are discrepancies in the outcomes. We identified that the POV settings are different even though we used the same Quick View XX. Why this happened and how you update your fixed setting?  

Workflow form has different scenarios Actual, forecast. I have created the step for Force Consolidate and Scenario Type filter is set to (ALL). when i complete the form only Actual Scenario will consolidate but not forecast scenario.  i tried to add another step to consolidate forecast scenario but it didn't work.  May i know how to set up for all scenarios to be consolidate at once.

Hi, Encountering the following error when attempting to drill back to the source system. Does anyone have any insights? Exception Type: XFExceptionThread Id: 330Message: Smart Integration Connector remote query failed.ORA-00936: missing expression

Seems I have found a bug, not sure if this is the right place to get it solved. We have a calculation where we use text3 on the customer, which is the country code to find the freight rate on the country customer with that name. In the latest forecast the calculated numbers were lower than expected. While checking there is no value calculated for customers with text IN, Indian customers. The Cubeview I created now to check gives below message: Text in the Cubeview is: U3#39939, U3#30612, U3#Customer.base.Where(Text3 = 'IN'), I tried also Text3 startswith IN and Text3 = IN, all give the same message. When I change to IT (for Italy), there is no error. Somehow IN is invalid for this purpose it seems. Any idea how to solve, I can give it a different text, but would not be consistent.   Thanks in advance Ben

Hi all, Is it possible to apply .base/.children to the non-primary dimension in a member filter? For example, the below screenshot, I tried to apply the below member filter (A#101:U2#100.base), but it only returns the first member from the UD2 dimension. I understand that I could put the U2 dimension to the next expansion level, but just want to explore another way to combine the script into one expansion level. Thank you.

Hi Everyone, I've written a business rule that peforms a certain task when the process button is clicked in the workflow via the "No Calculate" function within the calculation definitions of the workflow profile (see reference (1) in the screenshot). Broadly speaking it works ok, however I intended for it to only be triggered when clicking process on the "top" node of the workflow (see reference (2) in the screenshot). In actual fact it's running when process button is clicked in any of child workflow step (eg. "Asset Movement" in the example here, see reference (3) in the screenshot). So my question is: can I have a business rule that is triggered by the No Calculate function but only in certain steps within the workflow? Or will it trigger wherever process is clicked? I had thought it would be possible because calculation definitions can be defined in each workflow step which is why I was surprised with the above. (By the way calculation definitions are blank in the "Asset Movement"

I'd like to change the Show Header property of a Cube View component on a Dashboard from a button on that Dashboard. How do I programmatically reference that property?

We have some bunch of Step in our Sequence that we are calling it from Workflow Process step and this whole process is taking more than 2 hour around 2.5 hour . The process status is getting failed if it's running more than 2 hour but the Sequences is still running , as our process step showing failed we can't certify the Workflow . can you please help if there is way to fix this .

Hello, Is there a way to create a mapping rule for an account that looks at all entities but one?For example, A#123:E#*but E#456Thanks!

What are the options available in onestream to distribute monthly standard excel reports (Email/Save to a network drive/Sharepoint site) to non onestream users?   Also high level steps would be wonderful for the set up.  

hello team, new in OS , i need help if someone works on this tool.i am wondering if there is an equivalence of the hfm functionality "org by period" in OS ?is it possible in OS to manage the structure on a “Time sensitive” basis, and to have effective dates for changes ? i am aware that it's possible to do the changes of % of ownership or even change of type of ownership (full Conso, equity...) by period but am wondering if it will be possible if a change of the parent of the entity and having two hierarchies existing on the same cube/app thank you in advance

Hello,  I was wondering if there is an option to have text in the row header wrap?  The current version we are running allows us to wrap text in Excel by using ExcelWrapText=true in the formatting tab, but was wondering if there is a similar function available for the text to wrap in the row header?  Thanks!

In OneStream how to eliminate intercompany process (POV, configuration)

  How ownership data can be uploaded or copied from one period to another in the OneStream App.