OneStream Platform Forums

Hi All,   Can someone please teach me guide me how can I set the Import validate Load or process the automation and catch the error log with file in the email step by step please.  Thank You so much in Advance. 

Hello All, Our customer, who is migrating from BOFC, would like for organizational and technical reasons to keep using his intercompany dimension to capture sales to third parties but would also need to group these sales by sales channels.Their entity structure has a parallel Distribution channel structure (entities that are not part of the consolidation scope).  Is there a way to aggregate only certain IC (the ones belonging to a certain sales channel for example) ?Can we even do an IC reconciliation by grouped intercompany? Thank you in advance for your help/advices

i want extract TB input form data for all base entities at once. is there any way to have mass extract? 

Can we install two versions (8.2 and 8.4) of OneStream desktop client and OneStream excel add-in client in the same machine ? Later on if i want to uninstall 8.2 does OneStream have an uninstaller using which i can un-install 8.2 Any inputs around this will be highly appreciated   

Is there a function to lookup the name of a member from description.  I've been looking at the functions for a couple hours and cant find anything

Dear Community, I didnt find a good hint wihin the reference guide. So, I hope you can help me.  I know a Quick View POV is always set to be the default, which is set in Onestream. Otherwise I see, that Account or time can´t be adjusted. It is always the same "starting quick view" which is visible. So, I wanted to know if there is a way to set the POV to be different per each user or user group.  In example, if a finance user starts a quick view, he/she should initial see, what they want to see. Meanwhile an administrator should see something different, without the need of changing the POV.  Do you know if it is possible to change the initial POV? Or is the initial one always the same?Best Regards, Markus

Hi Everyone, We need to understand the scenario settings due to which we can avoid the data backing off (shown as derived, not stored value) for the next month when we enter a data in a periodic view. After digging up the community, we found some posts redirecting to change No Data Zero View for the scenario to YTD but that still doesn't solve this behavior. Is there any particular in the application/scenario where I can change to show no activity months as "0"?Thanks!JackLacava 

Since upgrading to 8.4, the client is unable to see results in report view. They were able to under 8.2. Is this a known issue?  Here's all we see...  

We are having typical issue with Metadata, it's a single currency application. The Auto Translation for Currencies property is Blank and doesn't have any value. But when I check System diagnostics I notice that for all Entities(~12k) this property is having value and there is a warning. If I go into the property and see there is no value in the Stored Value, but "Remove Stored Item" property is enabled which is saying that there is some hidden value. I had to manually goto each and every member and click on "Remove Stored Item" property to get rid of the value. Reloading the metadata with this property set to BLANK is also not helping solve the issue. How can this be resolved without manually updating each Entity. Any thoughts anyone ?

Hi All,   I think i have a very simple requirement but i cant seem to get it to work. I just want the API to make use of the entity which the user is currently using in the workflow. The code i now have is as following                    Dim sURL As String = "xxx"                     Dim pkWFunitPk As WorkflowUnitPk = BRApi.Workflow.General.GetWorkflowUnitPk(si) Dim sYear As String = TimeDimHelper.GetYearFromId(pkWFunitPk.TimeKey).ToString                         Dim sPeriod As String = TimeDimHelper.GetSubComponentsFromId(pkWFunitPk.TimeKey).Month.ToString                         Dim sAPIKey As String = "xxx"                         Dim sYearPeriodParam As String = String.Format("?yearPeriod={0}{1}", sYe

So this seems like it should be easy, and still may be, but it has me stumpt.  If I know the name of a cube, say "Houston" from Golftream, how can I determine within a business rule what Attribute and Value dimensions that cube has active for its various scenario types?  So in this example, for the Actual sceanrio type, Houston only has Attribute1 active with an alias of "InvoiceNo".  I can not figure out where to find this information.  I looked at both the Cube and CubeInfo classes but nothing jumps out at me.  It seems like CubeInfo has everything else but this information so maybe it is there but just not sure what property is is buried in.  Has anyone had to get this information for a business rule before?

Hello,   We have recently upgraded to v8.   With the new security properties on Adjustment Workflow Profile disabled, users still don't have the "Quick Post" button after creating a journal :  -Prevent Self-Post = False  -Prevent Self-Approval = False   Users have access to the 3 journal steps :  -Journal Process Group -Journal Approval Group -Journal Post Group   Does anyone know how to activate the Quick Post functionnality ?  Thank you.   Regards, Tahina  

Hi Guys, We got a request from user to get data from 2023M12 from actual scenario to forecast scenario. for Balace sheet accounts, the value from 2023M12 to be same till 2024M12 for specific account.  Can anyone help me to find way to retain same value for BS account, i have tried but due to activity calculation and endbalance input value, the value become zero for all the months. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- If Not api.Entity.HasChildren() AndAlso (api.Cons.IsLocalCurrencyForEntity()) Then Api.Data.Calculate("S#FCST_6_6_Test_Same_value:A#121010:V#YTD:T#2024M1:O#Import:U2#None:U3#None:U4#None:U5#None:U6#None:U8#None = S#Actual_Proforma:A#121010:V#YTD:T#2023M12:O#Top:U2#None:U3#None:U4#None:U5#None:U6#None:U8#None")End If If Not api.Entity.HasChildren() AndAlso (api.Cons.IsLocalCurrencyForEntity()) Then Api.Data.Calculate("S#FCST_6_6_Test_Same_v

is there any video available on 8.4 upgrades/features/enhancements?

Hi all, I am exploring the functionality of cell formatting based on the text of column header 3-6, I noticed there is a conditional formatting ColE1HeaderDisplayText and ColE2HeaderDisplayText, but not sure if the same function could be applied to header 3 -6 as well. Thank you.  

We are building a Consolidation application with 10 Base Entities and approx. 2000 Cost Centers. Each Cost Center is valid for only one Entity. In Other words a group of Cost Centers are valid for One Entity and the same group of Cost centers are NOT valid for any other entities. Given this requirement is it best approach to create Separate cubes for the 10 Entities and apply Extensibility on Cost Center dimension with Valid Cost centers for the Entity OR Create One Cube and apply UD Constraint on Entity with the Group of Valid Cost Centers ? Appreciate any thoughts or recommendation between these 2 options.  

Hello,  I am trying to change the columns of a cube view so that using entity ChildrenInclusive we get each column sectioned by each entity and in one single tab. We want this to be in one tab, not multiple tabs so I didn't think a book would work. I was able to make it look like this with these columns members. However, in the original CV we had specific formatting for the Variance B/W and Variance % columns which I cannot figure out how to apply to the multiple items in the nested column member. This is what I have currently for format. This works, but applies the pink formatting across the first 3 columns when I only want it on the Variance B/W column. Is this even possible? NumberFormat = [#,###,0;(#,###,0);0], If (RowName Contains FSLI) AND (ColName Contains Entity) AND ((CellAmount > 4000000) OR (CellAmount < -4000000)) Then BackgroundColor = Pink Any ideas or other ways to go about this? Thanks, Megan  

Hello OneStreamers, I'm looking out for a potential solution to create a custom Entity Drop Down that displays Text2 property value inside the dropdown. Eg: Entity Name Text 2 Property EntA ABC EntB DEF EntC GHI Now, when I fetch the Entity List, the dropdown should show like: ABCDEFGHI And NOT the entity names. Do we have a workaround to achieve this?Thank you!JackLacava OSAdmin 

Hi Everyone. I want to perform a subtraction of columns 1 and 2, I did it with the code below, but I see that it affects my performance too much, so I would like to know what other option I can do to do something like this without affecting the performance too much, I added that it waits 600 seconds but it still takes too much time. GetDataCell(T#WFYear-|!PLN_ParamNextFcstYear!|):Name(test) (I am subtracting the current year's values from the next year's values.)

Hi Community,I am building a Business Rule which will pull data base level data for a specific parent under the Account dimension.I am using FdxExecuteDataUnit to pull data from the cube, but I am not able to add Parent.Base as Account filter in the parameter.  It's seem like I am only able to put a member directly and not and .Base member in the filter. Dim sFilter As String = "Origin='Import' and Flow='EndBal_Input'"BRApi.Import.Data.FdxExecuteDataUnit(si, sCubeName, $"E#{sEntFilter},E#82,E#85", sCons, scenarioId, $"S#{sScenario}", $"T#{vPeriod}", sView, True, sFilter, 4, False) Thank  

Hello, where can I find the definitions of the LogonStatus codes in the UserLogonActivity table? I checked the design document and didn't see them there. Thanks! 

Hi Everyone. I have the following Databuffer, but what I want to do is to change the accounts to the following:  A#TRAVEL.Base, ,A#OTHERINCEXP.Base,A#ADVERTEXP.Base, A#PRINTINGSUP.Base, A#REPMAINT.Base, A#DELIVEXP.Base, A#COMMUNEXP.Base, A#PROFEES.Base, A#PROFEESDSPMT.Base, A#OTHERCONT.Base, A#DEPAMOREXP.Base, A#RENTEXP.Base, A#UTILITIESEXP.Base, A#OTHOCCOST.Base Dim SrcDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(CB#[HLFPLN]:E#" & curEntity & ":S#[" & curScenario & "]:T#2024,[A#OCCUPANCYEXP.Base, A#CONTROLEXP.Base, A#OTHERINCEXP.Base],[U1#" & curDepartment & ".Base])") but at the end I want to remove some specific accounts, so I would like to know how to do this without the parents that have the .base, example:  612900 621105

Hello, I'm building a cube view and we have some small amounts that are causing our B/W Pcts to have a huge %. Is there a way I can use conditional formatting to make the value show as 0 instead? Thanks, Will

We are setting up TXM/RCM and would like to have the workflows in a separate Cube View Workflow Profile.  We have added a suffix to the appropriate scenario types on the cube setup and created the default Cube View Workflow Profile for this new cube suffix.  However, the customer already has some workflows that are being used in the original cube.  Is there any way to move these to the new profile?  We know we can get it to work if starting clean, just not sure if it's possible to do anything with what they already have set up.

Hello! I encountered an issue where the results retrieved from a quick view setting varied significantly at different times. I want to understand why this occurred and how to prevent it from happening in the future. Can you help?