OneStream Platform Forums

Hi,We want to import data from Oracle EBS Cloud (v.12.2.9) into OneStream Cloud. What would be the best way to do this? Should we use REST API? Thanks!

Dear community, I have a Connector-type business rule that works like a charm.However, the SQL query which is the source of this connector is currently returning data for all entities, while this should be use for each entities that are affected to the given workflow profile. --> What is the best way to achieve a connector business rule that would be filtered by workflow profile entities ? Any exemples out there ? Best Regards,

Hello, has anyone seen an error like this before? I'm loading information from our PreProd to Prod environment and am getting the following error: "Summary: Error processing XML file type 'TransformationRules' XML: Line 379, position 22, element transformationRule. Rule already exists in this Rule Group, [Aggregate amount of institution's - 1- largest loan commitments]." From what I can tell there isn't anything particularly special about this line of code, it's just the line showing the given rule. And if it already exists, shouldn't it be overwritten through the load process? Any help in this matter would be greatly appreciated.

Hi,   Is it possible to define restrictions for input in a cube view between two UDs dimensions ? In order to "guide" the user in their input, I would like to define a restriction between UD4 and UD5, so that only specific UD5 elements (in columns) could be editable based on the UD4 (in rows). I don't see any restrictions on UDs elements in the datamodel, so what would be the best way to achieve this ?   Regards,

Hi Team, Is there any option to delete user groups in RCM under the Account Reconciliation Market place solution using a template? We have close to 3000+ obsolete user groups which need to be deleted.

How do you prevent users from accidentally loading data via QV submission to a non-forecast scenario ie; Actuals. The CV is set up to point at the WF scenario so if a user doesn't change their WF POV it will submit the data to the incorrect scenario. 

Is there any documents for Entity Aggregation ?

Is there any way to get a complete listing of active users and disabled users

HI All, I am working on script to copy data from one channel member A to channel member B (New member),  requirement here is to copy Actual, planning and forecast data. After data copy Member A become parent and Member B become children for Member A. As per my knowledge this can be achieved with below mentioned options. 1.  Right custom script copy data from Member A to Member B.  2. Export data from Member A and load back into Member B. apart from this are there other ways like mentioned below. 1. What will happen if I rename Member A to Member B, is this work ? I mean data move from MemberA to Member B? 2. Post creating member B, is there any workaround to map Member A data to Member B by changing reference back end tables? Thanks, Sandeep

I have a extensibility rule which copies and adjusts rates in modeling scenarios. Works fine for Administrators, but I would need to get this working also certain divisional users, which do not have the Manage FX rate role (as per now). To my understanding the rule is not able to update the rates since the session info contains user which does not have Manage FX rate role. Is there any way of getting around this, other than granting the Divisional users the Manage FX rate role, which would give them access also to certain rates that they should not be able to adjust?

Hi!   I have a matrix source file with cost centers (UD1) in different columns. As I see it I run in to two problems. First one is that I extract a separate file for each entity, and different entities have different amount of cost centers. The second problem is that a file can have more than 100 columns and I want to avoid to create that many source dimensions, if it is even possible at all. So is it possible to create a dynamic data source that checks the number of columns in a delimted file?  C    

We like to have a "Prod Yesterday" version in Test that has data from the overnight backup of production.  This helps when working with data issues and testing where one wants to have up to date data.   The major stumbling block to automating this is the need to automate the Rename Application functionality in OneStream Database Configuration manager.  Has anyone found a solution for this?  Or, for the more general solution of automating a daily restore of production to a lower environment for on premises OneStream?  Overall process:  MS SQL job restores the MS SQL DB to the lower environment  We run the One Stream Database Configuration Tool , select the database, right-click and select "Rename Application"  Restart the IIS servers  Import (IE "Load") XML files to apply Test environment config 

Hi,   I have some accounts I either need to map to an asset account (100000) or liability account (200000). The mapping should be based on the total account incl. sum of all dimensions. e.g. A#12345:I#IcpA = 2000 A#12345:I#ICPB = -3000 Then both accounts should be mapped to the liability account, but still to IcpA and IcpB.   If I create a derivative rule with create if < 0 and > 0 then it looks at all individual rows. If I then create a prefix check account where I set all dimensions to e.g. Total_Member, then it will also be Total_Member it includes in the further mapping.   Any way I can do this in OneStream?   Thank you   /Kenneth

Hi , I am trying to write a statement similar to below in a Finance business rule. This copies all data for source scenario to target scenario for Base accounts under a specific node  and some additional filtering. This works fine when both Scenarios are of type Forecast. However for Actuals to Forecast it is not working and this is because our Actuals are extended and uses a deeper granularity than forecast type scenario ( which uses a summarized granularity). I have seen O/S snippets and article that we use a convert data buffer command to make this copy work , but unable to find the exact syntax which can help me to also filter accounts and other dimension as shown below.   api.Data.Calculate("S#" & Target & " = S#" & Source & ", V#Periodic" ,"A#GMACM.Base" ,,"O#BeforeAdj.Base","I#None",,,,,,,,,AddressOf onEvalDataBuffer,,True)

Hello, has anyone seen an error like this before? I'm loading information from our PreProd to Prod environment and am getting the following error: "Summary: Error processing XML file type 'DataSources'. There is an unclosed literal string. Line 11771, position 4968693." From what I can tell there isn't anything particularly special about this line of code. It also appears that the remainder of the datasource file was loaded even though this error was received. Any help in this matter would be appreciated.

Hi, I have built a Finance business rule that users a data buffer to identify base level UD1 members with data at a specific intersection and sort the results. The user is prompted to select a parent level Entity and that is passed to the BR and used in the buffer.  Note:  The BR is called from a Cube View. What I need to do next is take the parent level Entity that the user chooses, pull in a list of base level Entities under that parent, and then loop through my data buffer for each of those base Entities, and then add the base UD1's to my list if they meet the Text# conditions I check for.  How do I go about calling the base level Entities member list and pass them in one at a time into my Data Buffer so it loops through them? Thank You

Hi all,  is there a way a flip sign can be applied to a mask account mapping that contains a complex expression? See screenshot below (partly), the customer created nearly 4000 lines of code in here.     

Hi All,   I'm looking for documentation on best practice to write and NCI calculation? If anyone could point me in the right direction that would be greatly appreciated.   Cheers!

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.