OneStream Platform Forums

Scenario: I have a Sql Editor component, with a couple of date-columns. If the value in the belonging custom-table is value NULL, then the value in the editor will always be the minimum value of the sql datetime type. I just want to show a blank value instead of "1/1/1900". Anybody solved this?   Cheers Frank

I am trying to utilize the UD2 and UD3 Default Member fields on UD1 members.  For example, I have UD1 members that always go to a specific State.  Nothing is showing up in UD2 for the State after transformation.  Also, I'm not sure how to set up the Data Source for UD2 when utilizing this field since UD2 does not relate to the imported file.   From the Reference Guide UD2-UD8 DefaultThis is the standard default Member that can be mapped for a setting and saves having to map toeach Member. If the setting says Default, the mapping will always go to that default.   Any help on utilizing these fields is appreciated.  thanks

Hello,Is there any way to load a PDF file to OneStream from the Data Sources? What are the steps required to convert the file to Txt (readable format) and can these steps be automated?Thanks,Priya

Hi experts. I have a query with regards to drill-down feature to locate the journals from 'AdjConsolidated' member. The entity hierarchy of the client has multiple levels and they post journals at each of this level (i.e at parents as well as base entities). When we drill down by origin from a top member and want to further analyze the balances under 'AdjConsolidated' member, we understand that drilling to entities won't give the desired results as the jnls were posted against Adjinput members.    Hence, they have to start the drill down by entities from Origin 'Adjustments' Member and keep checking for each sub-structure below it to see if the jnl comes from an Adjinput / Adjconsolidated member. Is there a better way to directly drill down to the actual jnls that were posted. Regards, SC      

Hello,   I have a question about multiple applications.  I know typically people think of OneStream as having everything within one application seperated by cubes.  Thinking of an application where Planning activities are quite different than existing consolidation activities and I am a bit weary of trying to jam it all into the existing Consolidation application.  I am wondering if it would be easier to organize in a seperate application altogether so there would be a planning application and a consolidation application and the planning data would eventually be loaded into the Consolidation Application after it's approved.  There are a number of reasons that lead me to entertain this idea one of which is performance and that we may only ever want to 'Aggregate/C#Aggregated' the data in Planning and 'Consolidate/C#Local' the data in the Consolidation application and we don't want it to get confusing with what data to use for the users.  Other reasons relat

Has anyone used Git or another version control / source control system with OneStream?  Currently, we keep a lot of commented out code in our OneStream system.   It would be a lot nicer to be able to only have to keep the latest in production, and have a version control system track the changes.    By default ( not that I know how to change it) the OneStream app does  only 1 XML document per type, so the changes aren't tracked at the individual object level, and you'll get a lot of changes to search through.  Has anyone made it work, or are you aware of a best practices document or other doc for this?

I was asked today, 'Am I correct to think that Databuffers do not return Null/Blank cells and therefore you don't need to check whether the cellstatus is Not NoData?' The full data unit is in memory and Time is part of that.  The system needs it in memory so it can figure out impacts to the whole year.  When you can a data unit for a month you are calling only part of the full data unit. For future period the data will be there, but not in the prior months.  If the data was there in Jan, but not Feb - Feb would be derived zero. Only because period is part of the full data unit, it is possible that you could have a value in Feb, but NoData in Jan. In that case when call the Jan data and buffer only Jan, you might think you have a true No Data. That is why we have the function to check. Honestly though, if the value existed in Jan, you probably need to run it for Feb too though. Using Is Not NoData should NOT be a default, you decide if you need it or not.

Is it possible to use the where clause for the member expansion ".Tree", specifically filtering on the AccountDim.  There is a top-level reporting cube and a few merged cubes sitting beneath (using entity extensibility). There are also a number of  extensible Account Dimensions utilized... i.e., Level 1 (Highest - Forecast Accounts)                     Level 2 (Consolidated Accounts)                            Level 3 - #1 (Lowest - linked to lower-level reporting subsidiary cubes using base GL Accounts - the account dimension names for these cubes always include 'Base')                            Level 3 - #2 (base GL Accounts)                            Level 3 - #3 (base GL Accounts)         &

Hello- I have created a business rule that uses a buffer to bring back UD1 members that have a value against them, then they are added to a list like this: myList.Add(api.Members.GetMember(DimType.UD1.Id, curUD1)) Later on in my code I do a sort Ascending, and return the results back to a cube view: objMembers = (From member In myList Order By Member.Name Ascending Select Member).ToList() I'm encountering a problem with duplicate values in the results.  This is because a small number of UD1 members have activity booked against them across more than one of the entities I am processing. Are there any quick solutions to removes the duplicates in the add to list or sort steps? The only thing I can think of would be to check if the value exists in the list before I add it, but that would require more coding. Thanks

Statement: You can move data or metadata between applications Question Credit: Peter Fugere   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? OneStream Press Authors are subject matter experts... but do they know about the 80's, sports, movies, or other pop culture trivia? Are you able to tell if their knowledge is fact or fiction? If so, come for the crown, stay for the fun, and emerge the new Fact or Fiction Champion at Splash San Antonio. Prizes will be awarded! You can volunteer to participate or you’re welcome to attend. Secure you spot today by contacting Press@OneStreamSoftware.com. We hope to see you there!

Currently if a step fails the subsequent steps continue to execute

Hello Team,Is there any way to export DM groups and Sequesces & Ste

Hi everyone, Is it possible to set a search/filter option in the combo box where user can type in the value and it will be picked up from the underlying list?  Alternatively, another component that can do it? I have tried using the tree view with search and filter option but it does not display anything if I use member list as bound parameter. Any other parameter type should be used specifically for tree view to work?

I have five cube views attached within a dashboard that utilizes the tabular layout. The content dashboard where the cube views sit is redrawn when a combo box is changed. However, the dashboard always redirects to the first tab. Only the content dashboard is set to redraw when the combo box is modified, and embedded dashboards are utilized to build up to the main dashboard. The goal is to change the combo box without redirecting the dashboard to the first tabbed report. Has anyone else seen this behavior and has a solution to redraw the dashboard with the new combo box selection while maintaining the current tabbed report displayed?

I've extracted the formula file for all metadata formulas,  and have notepad++ installed as my preferred tool for reviewing. What language settings in Notepad++ do I need to use in order to replicate the colour and formatting of OneStream's internal formula editor?

Hi, let's say I have a dimension with Member001 to Member020 being siblings. In a cube view I want to have rows with all members from Member001 to Member012. Using cube view designer, what's the syntax to specify the range, without having lo list all the 12 members? Thank you

Originally posted by Vivian ViljoenWe are using the TXM Transaction Matching Solution PV 530 SV 100Is it possible to perform a mass or bulk unmatch of matched data while using the TXM solution?Currently the user can select 50 at a time (max per page) and the un-match, however, in our situation we ended up with a few hundred pages that needed to be unmatched.

Good morning, We're configurating IC matching permissions. When entity A sells to entity B and there's a difference in amount, user X must conciliate and match transactions. X belongs to seller entity A, and he has permissions in A, but not in B. That’s why he can’t see any IC transactions, unless we give him permissions in B. My question is: what are the minimum permissions in OS to give X the ability to do IC matching between A and B, but no more.   Thanks in advance,     Ramon Odriozola

Happy inflation and food shortages <Not!!>Quick question. I have over 15 years experience in Essbase and find it confusing that we have multiple 1Stream cubes in one 1Stream application - but they all share the same outline!! I think I understand 1S extensibility.Is there an article that explains the differences of Essbase vs 1Stream? I would like to suggest to 1Stream developers to show cube name somewhere when I open a workflow. I don't see a way to tell if that workflow is for which cube!! very confusing.  

I am passing 2 Entities in the Data unit for Calculation as Entity is different in both the destinations  So what i was expecting is that it will run as a for each loop with both the entities so it will pick enitity1 and then run the Calc and then enitity2 and then run the Calc  what i was expecting was that the order will remain same every time it will run that is Enitity1 then Enitity2  but what is happening is that it is first taking enitity1 and then entity2 but when i run it again it is taking enitity2 and then enitity1 in that for each loop  to solve this i used 2 different DM steps but why it is running like this i want to know  Can anyone explain why it is running like this ?

Hi everyone, Can someone explain how the UD Member property "Is attribute member" works? I would like to assign to my UD5 members some attributes and be able to create CubeView base on the attributes. As an example, my UD5 could be Customers and the attribute I would like to assign to each Customer is the type of Customer (Retail, non-retail etc).  I thought I would use the "Text 1" property of my Customer members to input the type of costumers. I would then create a separate UD5 dimension "CustomerAttributes" and list all the attributes. Finally, enable the "Is attribute memeber" property of my "CustomerAttributes" dimension members and do a comparison between the value in the Text 1 of my Customer members and the value in the "Comparison Text 1"  of my attribute members.

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.      

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