Application Build

Hello everyone,Is it possible using a business rule to make a quick certification for a Certify Workflow?I was abel to complete the Certify Workflow task using business rule but the certification status remains rejected.Thank you in advance for your help.Regards,Antony

Hello OneStreamers,The purpose of this note is to share my end-user experience getting the new Developer Studio installed and configured.  I hope it helps you.What is Developer Studio?  This is a new tool to move code between your local file system and OneStream. Initial SetupDownload Developer Studio from Solution Exchange - OneStream Software Install Developer Studio by running the executable Launch Developer Studio and select File / Download OneStream Reference Assemblies… and store both versions them in a common directory such as c:\nuget  Register Sources  At the command prompt run this command  dotnet nuget add source c:\nuget --name LocalRepo Confirm the source has been added by running the command dotnet nuget list source  This directory should be the same one that has the reference assemblies downloaded in the previous step.  It can be anything, but in this example it is “c:\nuget.” Congratulations!  You have installed Developer Studio and configured your local machine

We're working on a solution, where users can enter and view a date through a Cube View using the Cell Type Date. The challenge is how OneStream handles date's (datetime) with time-zones. When a date is saved to the backend, it's converted to UTC time-zone. The Date component in the Cube View is also Time-Zone aware, so that it uses the local time of the user, to convert back from the backend UTC to local-time. The challenge with this is 2 fold: 1) Assuming we would calculate a rent for a given period. The user, based in CET time-zone, enters 2022-1-15 using the Gridview. This date is converted to 2022-1-14 as UTC (2022-1-14 23:00:00). Using a Custom Calculate method to calculate the rent from start (2022-1-15), now adds one day more, as the server time is UTC. (don't mention Daylight Saving Zone)  2) If another user, based in US Central, is reviewing data in the same Grid View (and same POV), this user will see a wrong date, as the server UTC date, is converted to this user's loca

We're currently evaluating the upgrade to OneStream 9.3.1 and noticed that this release requires a move to .NET 10, which appears to be a more significant prerequisite compared to previous 9.x upgrades.For those of you who have already completed or are planning the upgrade, I'd appreciate hearing about your experience and any lessons learned.Questions for the Community1. Infrastructure & CompatibilityDid the .NET 10 requirement introduce any challenges in your environment? Were there any compatibility issues with existing servers, middleware, integrations, or third-party software?2. Upgrade EffortHow much additional effort did the .NET 10 migration add to the overall upgrade? Was the .NET upgrade straightforward, or did you encounter unexpected issues during installation or testing? Were any rollback plans needed? any issues occur and popup related?3. PerformanceHave you observed any performance improvements or regressions after moving to 9.3.1 and .NET 10? Were there any noticeabl

Does anyone know of any information related to the new VLWDataRecord tables that are new in OneStream 9.3?There is nothing in the release notes and nothing in the documentation. Teams are seeing issues with the Data Records tool on the system tab. The vDataRecordAll View excludes those tables (and there is no vVLWDataRecordAll view at all). Has anyone tested solutions that may access data tables more directly (like FDX) to see if there are issues? Does anyone know how OneStream is choosing where to store data? It appears that some data is going to the new tables, but some data remains in the old tables.We have some nervous team members and nervous clients looking to upgrade, but unsure of the implications of this change. Honestly, I can’t blame them, since fundamentally changing the database schema for how your cube data is stored in OneStream without any information is a bit nerve-wracking. We’d appreciate any conversation related to this topic so the community has a better idea what

Hi All, We are using the OneStream 'cloud' solution with the desktop application required to be installed to access the OneStream functionalities. We would like to perform load/performance testing for the application with 250+ users to check its performace under the load. Have anyone done performance or Load or Concurrency testing for OneStream cloud application which is accessed through OneStream desktop application? If you have done this testing before, please share the performance or load testing tool and protocol used for testing the desktop application of OneStream with cloud solution. Your help will be much appreciated. Thanks!

Hello to everyone. Does anyone know how to build in Excel Add-ins for Task Manager? Our OneStream version is 8.2.2.16127? Guidance for this version provides the step-by-step instructions how to set up Add-ins for Word and PowerPoint, but not for Excel Add-ins.  Our Task Manager version is PV800 SV100. If to be very specific, we are looking for the opportunity to install Excel Add-Ins to link the preparation status from excel file to particular task in Task Manager. For example, if we have the excel file somewhere outside OneStream (on Sharepoint), and when the work done inside this file, we can push built-in "Complete" button in this file. The completion status from this file automatically forces the change in the preparation status in Task Manager for this task, which is linked to this file through the action type functionality in Task Manager.  Does it sound real? Could it be potentially implemented from technical point of view?   Thank you in advance fo

Where can I download CPM Express? I checked the Marketplace but couldn’t find it there. Is it available for partners yet?

Is there any known way to prevent a user from utilizing XFSet in Excel?

I am trying figure out how to make a dashboard page show up by default when a user signs into their application. Does anyone know how to accomplish this?

Hi, I've had a dig around, but I can't seem to find it.  Anyone know where I can see the disk space utilisation?We've set up a number of new apps in our environment recently, and I'm concerned we might be running out of space.

Hi All, PRM is used to assign access to the users (adding, removing, adding to groups etc) However, we need a different team to handle the security provision without having access to any other components in OneStream. It seems challenging to provide such group/user who can assign access without having Admin role. Does 6.6 version fix this with the Security updates available in 6.6 or the Provision manager again needs to have the Admin role? Or are there any APIs we can use to modify the users based on requests.

Can someone provide any  documentation and use case for different Source Type in dimension properties section?    

Hello,I would like to align vertically and horizontally the text on my column header (in Cube Views and Reports).It seems there is no option to do that in the format parameters (only in Excel).I have tried to use an inline Formula, at least for the Report format, but it is not working. I keep having errors messages.Do you know a solution to get a more consistent presentation ?Thank you in advance,Morgane

So we have a UD2 mapping set up in the List section. What I want is to be able to set up a Complex Expression in the UD2 Composite section so that for certain accounts it does nothing and so moves on to the List section, but for everything else we have a hard coded UD2 (e.g. None). I have no problem with setting the criteria in the Complex Expression, but I don't know if it is even possible to write some code that forces it to skip on out and look at the List mappings? I realise this is maybe a bit back to front compared to how the Composite mappings work, but we have a very tight list of accounts where we need to do the List UD2 mapping,  and everything else (which can be any other account) should just go to None.

Is there a maximum number of source id values that can be loaded to one workflow? Is there a maximum number of source id values that can be loaded for an entire application?

Hello OneStream Community, A few days ago a colleague of mine wanted to know the meaning of the various PropertyId constants present in one of the Application Database Audit Tables.I was unable to find any OneStream specific documentation on this PropertyId code and its meaning, so I created a business rule to complete the puzzle and get what we needed for the metadata audit at a very granular level.  For any one else experiencing an issue similar like this here is a table of the Member property Id's and their meaning.Dimension | PropertyID | PropertyDescription Entity PropertyID | 100 | Currency Scenario PropertyID | 100 | ScenarioType Account PropertyID | 100 | AccountType Entity PropertyID | 150 | IsConsolidated Entity PropertyID | 200 | IsIC Scenario PropertyID | 200 | InputFrequency Account PropertyID | 200 | FormulaType Flow PropertyID | 200 | FormulaType UDx PropertyID | 200 | FormulaType Scenario PropertyID | 300 | DefaultView Account PropertyID | 300 | AllowInput Flo

Hi all,  How do other customers go about archiving applications?  We've been live since 2017 and every year after filing our SEC reporting, we copy the production application and rename it with the year that's being archived. This is helpful as in the past we've move products in segments as well as various other master data changes affecting reporting.  The issue is that now we're nearing our storage capacity as the size of our application has grown over the years as we add in more data and features (35GB for the 2018 archive while our current 2021 production app is at 155 GB) and clearly this problem will continue every year.  Any suggestions on a more efficient and cost-effective strategy?  Thanks!  

Hi all, How to download the table contents from the System --> database --> Tables or Views, when I tried to download, it is allowing to download the 50 rows only - I'm not sure where is a restriction like this and how would I avoid these issues? Thanks  

Dear Community Members,Found several great posts about creating account members from a rule.  I am trying to clone a scenario member (Forecast with Range defined). I have to admit that i am running into a knowledge gap when it comes to how to create some of the properties.I am reading the properties of my source scenario and naively thought i can just use SetStoredValue with the property of the source scenario.  Got stuck at InputFrequency.Any pointers to documentation, Golfstream, Community posts, or samples would be greatly appreciated.

Hi,  at the moment we are migrating OS from v6 to v8. The logon procedure in V6 and V8 is SSO, while login in V6 on there is a small pop-up window to choose an account for OS. This pop-up automatically closes after the choice. In V8 the button External provider sign in is not there, instead via logon it opens a full window that does not close automatically.  is there are solution to get this full web-page closed in v8?   thanks,

Is there an easy way to bulk delete members in OneStream?

This was originally a question.It took a while to figure out, so to save someone else the hours of trial and error, here is the process I use in detail, start to finish, to run a Workspace-based Data Management step in a Workspace Assembly business rule.Here's a How-to step by step:List of abbreviations used below:DM: Data ManagementWS: WorkspaceMU: Maintenance UnitBR: Business RuleAS: Assembly1. Workspace:Set the NameSpace Prefix - this is what gets filled in at runtime for __WSNameSpacePrefix2. Assemblies: Note these properties 3. Create the Assembly Business Rule:Create an "Extender" business rule, this is done by right clicking files and selecting "Extensibility Rules"Add some test code, to verify correct configuration, such as BRApi.ErrorLog.LogMessage(si, "Hello from the new extender!"then code the way you would any other extender4. Create The Data Management Group: Create a DataManagement Group in the same workspace that the Assembly that has your business rule is in 5

The Question Text Column scroll bar in my Certification Questionnaire is not working. I have a long question text which does not fit the default cell size. The scroll bar is not clickable/draggable, so my reviewers aren't able to view the entire question during certification. The workaround I have is just to expand the column size so that the text fits into the cell. I am wondering if anyone has the same user experience or has a solution to get it to work? My current software version is 7.1.3.  

Hello,I am getting this error when I try to extract a transformation rule group. Any ideas on how to resolve?