Application Build

Hello, we are about to start our work on next year budget and we already know that, following a recent restructuration, there will be a lot of pot swaps between departments (e.g. Licence costs used to sit in the department using the software but will now all sit under IT). Some of the them will be just moving a cost center and its history from one department to the next so that will be easy.  Our issue is when we do a "pot swap" that moves part of a cost center. In this case we will have a disconnect when we compare actual and forecast unless we restate actual (i.e. also move the cost in actual). My question is on how best to tag/flag the "pot swap" in the actual data so that in reporting we can do like of like comparison (i.e. with past data restated) but also keep the original data. I have 2 potentials solutions: Flag the restatement using an UD: do the restatement of past periods under a specific UD so that we have the ability to see past periods with or without pot swap adjus

In V7 I had a cubeview and V#Annotation was open for capture but in V9 it is not but V#Auditcomment is open for capture.  Any idea why ?

Hi All - I have a question on the SetDataCell Does the below work? I am trying to write 1 to an account.api.Data.SetDataCell("S#UltOwnShipConsolTracker:V#YTD:A#DirectOwnership:F#None:O#AdjInput:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None", 1, False)My Origin is AdjInput & Consol is OwnerPreAdjThanksKrishna  

In People Planning, is there a way to sum all the values in either the PLP register or calc plan for all employees to get a total to calculate an allocation. My client would like to allocate a Pension Pool by the Employee’s Wage / Total Employee Wages. I am trying to find a way to calculate the Total Wages for all Employees using Allocation Methods as they run by RegisterID/CalcPer. Any ideas. 

Hi all,I'm experiencing an issue with the connector in one of the cubes. Although everything is set to "replace," the stage is not being cleared, and old data is being loaded together with the new data. As a result, I have to manually clear the stage to resolve it.The log, is says replace Data keys are 2025M10,2025M11,2025M12,2026M1, but if i check th estage after the import i have periods outiside this rangeThe log indicates 9,261 lines, exacly the same amount of rows that the query produces. But the import shows 248 pages. With 50 rows per page, that would be around 12,400 rows loaded, which is quite different from what the log reports. I'm not sure if I'm missing something here, but I haven’t noticed this happening in other data loads. I still need to replicate the issue in a different app. Has anyone seen this before? Thanks in advance!  

Hi All,Apologies if this question has been answered before. I tried search community but couldn't find.I noticed that data can be loaded via Forms into BeforeAdj member.Two questions:(1) Wouldn't it mean that if data is subsequently loaded into both Forms and Import, the previously loaded data into BeforeAdj  member would get replaced?  Isn't BeforeAdju supposed to be an Aggregated member?(2) Why would anyone want to load data into BeforeAdj member in the first place? What is the benefit of loading data into BeforeAdj member directly and not using Forms member if data is input via Forms?Thanks in advance for any insights.

In the cube view, I have the customer selection on the dropdown list. When NoCustomer is selected, they want to see data that is loaded on Import. But they want to block the input for NoCustomer on Forms. is there an easy way to achieve this? Like if NoCustomer, read only?  

We have a consolidation button in the excel add-in that does not work. However, it works fine in Spreadsheet. This is in version 8.5. I've seen others have had this error but no commentary on a solution. Is this resolved in later versions or is there something to change in the excel add-in

I have a requirement to setup auditor (view only) access within the Task Manager solution.  Unlike Account Reconciliations, there isn't a dedicated Role within the Global Options settings of the solution.  My initial thought was to assign an Auditor role to the "Viewer Group", however this would require every single task to have the role assigned.  Does anyone know of a better solution, or do we actually have to assign the viewer group on all 2,000+ tasks? E.g., regarding assigning the auditor role to the viewer group.  

Hello, We are creating a user activity dashboard to monitor system activity by user.  In the TaskActivity table, there is a column for Task Type (TaskActivity.TaskActivityType), but it stores a numerical value. Does anyone know where the corresponding text description is stored to pull into a SQL dashboard data adapter? Thank you, Eric

Hi everyone, I need to delete all records from the error log, it became very slow and heavy to use. I tried the buttons abovebut they do not clear everything from it. I found some discussions partially covering the topic, they suggest to manipulate the table 'ErrorLog' via query, but it seems like that table does not exist.Is there an easy way to do it? Thank you

Hi OneStream, Please let me know when shall Core Platform Architect certification exam become GA? In the exam portal i still see OCP - LA certification exam. Thank you,

I've created a form template and assigned it to a workflow profile. However, each time I access that workflow profile, I have to manually click on the form to open it. Is there a way to set a default form template so that it opens automatically when a user navigates to that specific workflow profile?

Hi, I've created an XFBR String Service file, and I would like to reference other (also XFBR String Service) files to break up the XFBR rule to manageable pieces. I keep running into compile issues. Any insights would be helpful. Thanks. Here are the screenshots of what I have: -Main XFBR String Service file (referenced in the Service Factory): -The secondary XFBR String Service file I'm calling & error: 

Dear Community Members,Due to my error in the initial definition of culture codes I ended up with two es-MX local language options in the dim library.I removed the es-MX culture code. One of the two options went away in the DimLibrary, but the second one persists.Then i removed all descriptions from the MemberDescription table where CultureCode = es-MX.  Still the DimLibrary shows Spanish AND even more surprising shows the Spanish descriptions.Which leads me to believe that those descriptions are cached somewhere?Any tips?  My ultimate goal is to have es-MX culture code and local descriptions. But only one Spanish in the DimLibrary.SystemConfig (this is a locally hosted client) only has en-US definedMemberDescription Table has only Englishbut DimLibrary still has Spanish descriptions but only where defined before. Other members that never had a local translation do not show Spanish (Mexico), see Scenario Actual below.Thanks in advance

Does anyone have any information/advice on testing applications in OneStream? Are there gotcha's or must test items?

Hi, is there a way to copy the list of all functions displayed after args.cubeview.?  

Hi,  I am in the process of testing security for applications. I have view dimension library access, I do not have manage meta data access. I have added security groups to access and maintenance groups for which i only have access to "Access group". I cannot edit any members, which is correct based on my security, but i am trying to understand the reason why the meta data is not greyed out? It appears as normal, and i can edit, but when i try save the changes, it says i do not have access. Which is great, it means it works. I was just expecting it to be greyed out like for example cube views. Just curious as to why meta data isnt greyed out as well? Would appreciate any feedback

I have an AIP (annual incentive plan) input form whose input range from 0 to 2. Can I create formatting rules to restrict users from entering any number beyond the mentioned range?

I need to automate a process of Extracting certain Dimension Descriptions into a Comma Delimited text file for exporting into PowerBI.  The application extract puts it into an XML format, and I need it into a comma delimited file.  Any suggestions?

Hi All,In your OneStream implementation, how many environments do you have?  Dev, UAT and Prod?Or do you also have Pre-Prod environment that is common in ERP systems?Also, in the UAT environment do you also have copy of data so that when testing happens or developers need to test the changes - there is enough sample data to test?Would you consider brininging data from Prod, randomize it and load into UAT env so that UAT env data at all intersections as Prod?Thanks!

Hi! We are trying to control the size increase in our production application. We know the growth comes from: Stage tables that allow users to drill down and back onto source data. Data records Audit tables (they can grow a lots if they are recording continuous changes to rules, data for example) Logs which will impact Framework database growth (task activity and error logs, will vary depending on the detail login set in BR, DM and on the system configuration as well as your retention policy) Load transactional data, which will increate your data units and data records unnececarily, which BIBlend should be used for this type of data load instead of loading it to the finance cube. We have analyzed it and we realized the StageAttributeTable and other stage tables has a significant size. Has ayone performed databse maintenance by deleting data from the stage tables? Is it possible to do that while keeping the cube data intact and workflows completed? Any ideas or best practices regarding

Hi everyone, I have a business rules that is triggered through a dashboard. This Business rule is looking at a True/False parameter. How do I add the parameter to the dashboard and with a dropdown list showing the valid values (true/false) that can be used to save the value to the parameter? Thanks in advance,

Data Management Access SecurityPlease share your expertise to set up a Cube's Data Cell Access Security / Slice Security to limit data read access as outlined below: Dimension: U1# - GeographyTotal_Geography = Child 1 + Child 2 = Total / Top         North_America = Child 1 / NA         International = Child 2 / Int'l Slice Security: Access Level - Read Data by Geography - in a CV and a QVTotal_Geo_Data = Read Total data | Read NA data and Read Intl data         NA_Data = Read NA data | no data access = International and Total         Intl_Data = Read Int'l data | no data access = North America and Total TY for your practical advice - SMEs. U1 Dim: Geography.  

Hi, I'm seeing this error for a user that has been setup in OneStream. We've attempted to exit out of the application and run it, but the same error message persist. So far no one else is experiencing a similar issue. Has anyone experience this issue? Would it be simply a configuration issue? Thanks