OneStream Platform Forums

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 All, I have a bit of an extreme question here.  Is there any limit, whether system or logically, that there are too many cubes in an application?  My example (which I have simplified here for illustrative purposes) relates to UD1 for Cost Centers where we have 150 entities all having unique and different cost centers.  Since they each have 20 unique Cost Centers, that's potentially 3,000 Cost Centers in one dimension which feels big and very sparse.  Thinking through options for how to approach, one option we are weighing is to add a separate cube for each entity and assign a separate UD1 dimension to each cube / entity so they would only have 20 Cost Centers to contend with.  As it rolls up the entity structure, it would consolidate to a Summary cube that has one member called 'Total Cost Center' thereby shrinking the data unit in the top cube. Has anyone dealt with these high numbers of cubes before?  My gut tells me be that this could be troublesome

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

Originally posted by Sheila GraffIs there a report what will show the when dashboards were modified? Looking for something similar to the CubeView Audit. 

Hello,  So we loaded some data to an application database, which we are accessing within Dashboard. Does anyone know how to format the table values in general? For e.g. I want the decimal to show in pct.   I tried to format numbers within here - but couldn't make it work. Am I missing something? Please suggest Thank you!   

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 there!I have a Workspace called WK1I have a Dashboard called DB1I have a Component called "George" (coz, why not?)How can I programmatically add George to the DB1 dashboard in WK1 workspace?Note that i already have other components assigned to this DB1.Thanks

Hi team! I'm utilizing the "process cube" function within a JournalsEventHandler. However, whenever the event occurs after the journal is unposted, the process cube fails to execute; it gets stuck and never completes. if the event occurs after the journal is posted, it functions correctly. Not sure what is causing it. here is the piece of code: Else If (args.IsBeforeEvent = False) And _ (args.OperationName.Equals(BREventOperationType.Journals.PostJournal) Or _ args.OperationName.Equals(BREventOperationType.Journals.UnpostJournal)) BRApi.DataQuality.Process.ExecuteProcessCube(si, _ BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, _ EntityWFName, WFScenario, WFTime), _ StepClassificationTypes.ProcessCube, _ False) End If Thanks.  

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

Hello community can the Grand Total be added at the top instead of the bottom?   thank you a lot  

The Function in my rule : Brapi.Utilities.ExecuteDatamanagementSequence run the sequence in Background and allows me to do further operation in BR even before the step is complete.Is this the expected behavior?How do we avoid this. To run further operation until the complete sequence is complete?  

Hi everyone, Is there any possibility to display a message box when there is an Fail task during import a file? I am launching automatically an Import Validate Load of a file when the user import mannualy a file from a specific workflow task, and I would need to display a feedback when one of these tasks is Fail (wrong intersection for instance) ? Many thanks for the help, Aurélien

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!

Hi team, We are encountering an error when running a button that involves a Data Management (DM) step to a Business Rule (BR). The error message is as follows: "Summary: Error processing Data Management Step 'SAVE_DRIVERS'. Unable to execute Business Rule 'PLP_HLFPLPCopyAdminDriver'. Error processing script 'S#[Forecast 2024M4]:O#Forms:A#SalaryWorkdays= S#ForecastInput:O#Forms:A#SalaryWorkdays'." This process is run on a monthly basis, and this is the first time we have encountered this error. We have also tested it in our test environment during the same period and did not encounter any errors. We are unsure of what may be causing this issue and would appreciate any assistance in resolving it.This is the BR: Imports System Imports System.Data Imports System.Data.Common Imports System.IO Imports System.Collections.Generic Imports System.Globalization Imports System.Linq Imports Microsoft.VisualBasic Imports System.Windows.Forms Imports OneStream.Shared.Common Imports OneStream.Shared.W

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?

Is there a way to configure the system so that it will check if a consolidation is already running before allowing another user to start a consolidation?  If so, how do we configure the system to do this?

Hello, I was wondering if we can have forms only populate for certain months. I tried using the Form Frequency filter as Member Filter and tried a few different things to no prevail. I only need the form to show up in the WF for months 1-10 and I tried T#WFYear.Prior10 and a couple others. Thanks, Will 

Hello good afternoon, I need to extract a specific hierarchy without extracting all the hierarchies we have in the account dimension, as you can see in the next screenshot, I just need TP9E in order to extract and import into a different app: But when clicking into the application load/extract (metadata) I see only options to extract the hole dimension: Is this possible? Many thanks in advance.  

We use Standard (Calc On The Fly Share and Hierarchy Elimination).  What type of Rule should we leverage to reclass balances from one account to another during consolidation. For illustration purposes, the below is what we are looking at:  

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.