OneStream Platform Forums

Hi OneStreamers, I am using the table vStageSourceAndTargetDataWithAttributes in a dashboard to display cost centers (Source Account) and Accounts (Target Accounts) per all other dimensions, for a selected entity and period. It's working fine but the amount from the table is always in the local currency of the entity, and I'd like to see all amounts in EUR. Is there an easy way to convert the figures in the table ? I saw there was a column named "Converted Amount", maybe it can be used somehow to show translated figures ? Appreciate your insights on this. Adam

Hi all, Short question. I have a message similar to this:  "Unable to delete member 'XXXX'. Error removing member. Member 'XXXX' has data. Same as in post Unable to delete Entity member - OneStream Community (onestreamsoftware.com) With the exception that the cube is clear (in total there are 2 cubes; one without data and the other doesn't use the dimension in which the member exists). Should it be data somewhere else? If it is the case, where? Thank you. BR, Carlos

Does anyone know what this message is talking about. Sorry...new. Users are trying to drilldown by 3 dimensions in the rows and are only getting approx. 6 rows of data and then the message under the output. Their row settings are at 10,000.   Any help would be appreciated.... James

Hi Guys, We are upgraded to V8 and now need to update our integration to SAP BW as well. As of now, the ERPConnectStandard20.dll has added in the assembly folder under the gateway server folder. And per the SIC guide, only the smart integration function business rule can used to call ERPConnect function, so we believe the steps should be: 1)Build smart integration function business rule to extract data from SAP BW 2)Using connector business rule to call the above function for processing in the Import step But we didn't found any sample for this. Appreciate if any input or sample code on this. Thanks,  

Hi, I am building a BI Viewer chart and need my colors to be dynamic. I have three colors in my color palette for the BI Viewer component. I can manually set the color to match the option in the palette, but if I use the parameter changes my scenario or time, the palette color is reset and it selects a random color. If I use the automatic setting (which would make the most sense) it sets every color to black.  My ideal color settings are: First year actual: Blue Second/last year actual: Pink Second year plan: Green How can I set this up dynamically?

Hi Team, In Scenario 1, we are having an input upload form and in Scenario 2 we are having another input upload form. Both the forms are attached to the different form templates.  The input form of Scenario 1 is  getting uploaded in Scenario 2 as well. How to restrict the input form upload based on the scenario.  

Hi, I want to display all the data sources of each dimension. Tried to retrieve from ParserDimensionAttributes table, but not sure what is AttributeIndex, From which table I can get the attribute index value? Please help with this query/ Thanks, Manju Komara

Hi I am trying to add conditional formatting to my CubeView to bold certain rows, so that it stands out for my users. I'm using treedescendants(i) to list out all the accounts to minimize any maintenance, so I can't bold the rows individually. Also, the accounts I want bolded are not in the same indentation level, so I can't use that expression. I tried using If (MemberDescription = 'Apple') Or (MemberDescription = 'Orange') Then Bold = True End If. This works, but if I tried adding another Or statement, it would not work:  Eg:  If (MemberDescription = 'Apple') Or (MemberDescription = 'Orange') Or (MemberDescription = 'Banana') Then Bold = True End If.  Is there another workaround for multiple Or statements/ how should I update my condition? 

I am Running a Dashboard Data set rule. The process is a bit longer. For Each EntMem As MemberInfo In BRApi.Finance.Members.GetMembersUsingFilter(si, Brapi.Finance.Dim.GetDimPk(si, "DimName"), "E#Top.Base", True) For Each Parent As Member In BRApi.Finance.Members.GetParents(si, Brapi.Finance.Dim.GetDimPk(si, "DimName"), EntMem.Member.MemberId, True) If EntParentCheck.Contains(Parent.Name) Then Dim customSubstVars As New Dictionary(Of String, String) customSubstVars.Add("dmTime", Time) customSubstVars.Add("dmScenario", Scenario) customSubstVars.Add("dmEntity", Entmem.Member.Name) customSubstVars.Add("dmParent", Parent.Name) customSubstVars.Add("FileName", FileName) BRApi.Utilities.StartDataMgmtSequence(si, "Export Cube Data", customSubstVars) End If Next Next ERROR: Not enough quota is available to process this command. I think it is generally with long running jobs on OS Dashboards?      

I need to copy data, including adj data, from one fiscal year cube to another calendar-based cube.  The DM Job I tried to use does not work with ADJ data as the journals cross entities that don't exist in the target cube. The rule also needs to include variables for entity, account. and scenario remapping. Any sample provided is appreciated. 

Hi Everyone, I am trying to allocate forecast data to the gl's based on the last year actuals data. The allocation is not happening when the forecast scenario setting "clear calculated data during calc" is set to TRUE. If I set it as FALSE, the allocation is happening. This data is copied using the setdatacell from the allocated value to the target script in which origin member is O#forms.  It seems the value is not written to the origin member if I set the scenario setting to true. can someone explain me what is happening? Also, I tried adding the below calculate and clear code.  api.data.calculate($"{script} = 0 * {script}") api.data.clearcalculateddata(script) It worked until I did not change any data, once I changed the data, the allocation did not happen again.     Thanks, Jeevan  

Dear CommunityI am facing the fact that my XFBR(BR_XFBR_String, ParentBold, sEntity = |MFEntity|) does not passing the Entity Name to XFBR.CubeView is organized in the way that Rows contains just a part of Entity structure Entity.ChildrenInclusiveR (this two step structure has no Base Members) and i need to format only Top Parent of that. It works when Variable comes form POV or CV but not from the Rows/MF.Is there any way to use |MF...| for passing information to XFBR?Thanks

Hi everybody, I'm currently developing a dynamic CV that gives the chance to the user to select an account hierarchy of choice to show in the report  (P&L, BS etc.) through the parameter MainFormParentAcc_PL I'm having issues with indentation tho, because if I add .TreeDescendants the accounts are still shown on the same level in the report.  I tried to look if there is a format I can apply, but if I understand correctly the only format available for indentation is for the excel view (ExcelIndentLevel = xxx). Do you have any suggestion on how I could solve this?Thanks in advance!

Hello People, I built this CV and then I'm building this BI I used the same CV above in the BI dashboard, however, I couldn't move the periods in the columns like in the CV. I would like to have the periods in the columns like in the CV to get the same data.do you have guys any examples of this?    thank you

I need to run consolidation from WF using the calculation definition upto the immediate parent of each entity level WF. what would the step to do that?

Hi everyone,                   I want some help in workflow.anybody knows how to get warning action during importing of data in workflow using conformation rules.If someone know please help me.                  Otherwise,you can tell any alternative method to achive this case like through the business rule(parser).The business rule should give the warning message at workflow import process(first step of loading data) and the importing process should me continued,not to be breaked.i.e)soft validating......we want warning action not error action.Thank you.

Hi all, I am trying to build out a CV for a report and I'm having trouble with the best way to build out the columns. My current approach is to just go at each column with differing member filters. For Example: 1st column - S#Actual:V#MTD:UD#Orders:...etc. Does anyone have a better approach that I could use? Or even just point me in the right direction in the documentation? Thanks in advance! Here is a screenshot of the report columns I need to build in OS:  

Dear Community, I have a requirement to generate a pop-up or warning message during the Data import process based on a specific condition. If the condition is met, the pop-up should inform the user, but the import process should continue without causing a hard fail. Is this achievable ? Can anyone please suggest a method to achieve this. Thank you.      

Dear community, I currently have a Business Rule connector that works fine. However, I would like to pass a parameter from a dashboard into the SQL query of the connector. This is because the user should load a set of data but they can decide which "slice" of data to use. Hence, the connector should filter the data, and then I need to pass an input parameter to my SQL query within my connector. Any possible way to do that ? Regards,

Dear Team, I'm trying to understand what caused the low performance of my code. I see that it's because of many loops, but I'm wondering if there's any possible way to fix it: Dim ResultDataBuffer As DataBuffer = New DataBuffer() Dim sAccounts As List(Of String) = New List(Of String) From { "1711050", "2742020", "1712020", "2745060", "1346010", "2413010", "1742050", "2716050", "1745010", "2713010", "3221010", "3221020", "3221030", "4451010", "4451020", "4451030", "1722060", "2741030", "4541070", "4321020", "4541010", "4541020", "3222010", "4452010", "4541030", "4541040", "4541050", "4541060", "5111010", "5111020"} Dim mICFilter As List (Of Member) = api.Members.GetBaseMembers(api.Pov.EntityDim.DimPk,api.Members.GetMemberId(dimtype.

We load the GL data with YTD View. Data was loaded for 2024M2. There is no data loaded for 2024M3. For some reason after the consolidation/Force consolidation is run for 2024M3, the M3 P&L accounts are appears to reverse the M1 and M2. I do not expect to see any numbers for M3 and we haven't loaded any data for M3. It appears, I am missing something.  

Hi all,  I try to paste new records to SQL Table Editor from Excel spreadsheet. It allows me to paste the data, it seems right, but it does not allow me to save it. It behaves like there is no data at all. What am I doing wrong? Thank you!

I have activated attributs in my connector and tied them to columns. However, they do not appear in my stage and my vStageSourceAndTargetDataWithAttributes is empty. Is there any additional setting that should be activated in order to get the attributes active in stage?

I have listed a parameter which has display items as Yes, No in one of cube view row override that displays in a Form. Along  with Yes, No items it is also showing "No Data" even if it is not listed down in Display items of the parameter. Could you suggest how to remove "No Data" item     

Hi, we have been working to build our Cash flow report and would need to include an account from the Balance sheet into the cube view report. We would need to include ''cash and cash equivalents at the beginning of the period'' and ''cash and cash equivalents at the period end''.Is this possible to include? When I tried to, I got no values from the BS account into the cube. If so, how would i proceed?Thank you!