OneStream Platform Forums

If (uiItem.uiItemType = XFReportUIItemType.PageFooterDate) ThenDim combinedText As String ' Get the current date and timeDim currentDateTimecurrentDateTime = NowcombinedText = "Date & Time: " & FormatDateTime(currentDateTime, vbLongDate) & " " & FormatDateTime(currentDateTime, vbShortTime) ' Get the local time zoneDim timeZonetimeZone = "Time Zone: " & TimeZoneInfo.Local.Id ' Combine date/time and time zonecombinedText = combinedText & " | " & timeZone ' Set the text in the report footeruiItem.Text = combinedText ' Calculate the left position for the combined text to be right-aligneduiItem.Left = args.Report.CurrentPageInfo.RightPosition - uiItem.WidthEnd If  This is my code to display date/time and time zone in the report footer but the code is not pulling the time zone. My question is, is it possible to pull the time zone?? If yes please provide a sample code  Thanks in advance!

Hi Team,   Hope you are doing well and I would like to know the process to provide access to a particular dimension as user is facing an issue Steps I performed: 1.Created a group under System 2.Created  a user with OKTA verification  3.Updated the group to the dimension in Access Group property. 4.Assigned the user to that Group But user is getting as below Error: Application access denied because user account is not found or has been misconfigured. Contact your system administrator.   Thanks

Hi OneStreamers,   I have a set of scenarios for forecast, rach one must have its own rate tables. Is it possible for me to use only one rate type and combine that with each scenario to input the rates ?  Thank you, Adam

I have a 3 step Data Integration process which I need to automate,1. Extract OS data and push it to DB tables - DM Sequence2. Execute list of DB Stored Procedures3. Import data from DB to OS - DM SequenceI started with an Extender BR calling them using BRAPI.Utilities, but the execution of Stored Procedures itself will take 6-8 hours and the DM Sequence time out before even SP completes.Appreciate suggestions to automate this process. 

Hi, Did anyone have any situation when they deleted a DM Job by accident? How can you retrieve that? There's no Orphaned area for DM jobs for us, unfortunately. I can't find any back up for it. Would save us a lot of time if we avoid rebuilding it. Thanks in advance. Regards, Irina

Hi Team,I wanted to insert a text to data cell (for example 'Add comment'). Is it possible to be done by using api.data.calculate?This is how I see this:Dim Comment As String = "Add comment"api.data.calculate("V#Annotation:A#xxx:F#xxx:O#xxx:I#xxx:U1#xxx:U2#xxx:U3#xxx:U4#xxx:U5#xxx:U6#xxx:U7#xxx:U8#xxx=" & Comment) Thanks a lot! 

Does anyone know if/when OneStream plans on addressing the incompatibility issues between Power Query and quick views/cube view reports? I've got a number of reports that utilize the get/transform functionality in excel but saving an offline version of any reports that contain an @getcell() formulae will wipe out any queries, connections, tables or table-named ranges. Is there a way to avoid this happening via the settings in the excel add-in?

Recently I heard in these forums that FDX methods (like FdxExecuteCubeView) should be used from a BR whenever the performance of the data is critical. Can someone help me understand why they are faster? We've already built quite a lot of client-integration software using cubeviews.  The cubeviews are being executed via the REST api.  We are retrieving data with "api/DataProvider/GetAdoDataSetForCubeViewCommand". Now that I have discovered the "FDX" methods, it puts me in the troublesome position.  I realize that a ton of our integration software should probably be re-written to use those FDX methods.  The re-write may take some time.  Why won't onestream just extend the "normal" cubeview interface of the REST api, and add an option to run it in FDX mode?  That would be similar to the "turbo" buttons they used to put on a the tower of a PC to make it run faster (for those users who had a preference between a fast computer and a slow one.) It would be h

Hi dear contributors / members,I am trying to format the Cube View cells to final value divided by 1000. Any idea how to do this?Thanks in advance.Kind regards,Irina

   Hi,I would like to add up all the children of the accounts and put them in the getdatacell, to create a row of Total, both for flow1, flow2 and flow3 

I want to execute a list of DB Stored procedures after executing a DM step in OS. Is it possible to call a DB Stored Procedure from OS?After the Stored Procedures are run, I want to execute a list of DM Jobs for data imports to cube.Appreciate any pointers how I can implement this.  

Changing the "Is Consolidated" option on parent Entities will impact consolidation performance. Question Credit: Jack Lacava Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Please let me know what controls/dictates what entity parameters are being asked when running a dashboard.  I'm looking to cleanup some of the dashboards we currently have built.  Currently in our production environment we have a dashboard that is asking for the entity to be selected twice before running the dashboard, but in development it's only asking once.  I'd like the production environment version to run like the development one.  I've tried comparing the differences between both environments but having no luck.  The cube views we're referencing are the same parameters as well.  For Entity Members the |!WFEntitiesAnyLevel!| is being used for all.  

Does anyone have a good solution when viewing dashboards that require scrolling? We have a P&L view set up as a dashboard, which is fed from a cube view, but are hearing a lot of noise around the scrolling and loading of additional data. When a users scrolls down on their report they get the loading circle and need to wait a moment for the rest of the data to load to continue scrolling and get the same thing. Once they reach the bottom they can scroll back up and down without issue. I understand why OS is set up this way, but if anyone has any feedback or input on the different ways they improved their performance on that I would appreciate it! TYIA

We are currently on version 6.6. We use LogonAndOpenApplication via Powershell to login and run DM jobs. But after enabling SSO, the call doesn't work and gives error "Error processing External Provider Sign Ininformation" I can see at below post that it would work in 7.2, but was wondering if anything can be used in 6.6https://community.onestreamsoftware.com/t5/Platform/Excel-Add-In-Macro-VBA-function-Add-Ability-to-Pass-SSO-Token/idi-p/5457

 I'm trying to figure out where I can access the Key related to this error. I created a series of new accounts and member formulas by extracting an existing set of accounts from our application.I opened the extracted file in Notepad and performed a find/replace on account names and formula members, saved my changes and uploaded the modified file.When I try to consolidate, I get the same error as above for every account I added this way. is there are way to fix this, short of deleting the new accounts and adding manually within the application? 

First time poster here!  I created a data source called Vista that has 4 different entities using it.  Each of those 4 entities has their own Workflow Profile and each entity is “assigned” to their respective Workflow Profile.   In the Data Source, how do I address this in the Entity field?  Is there a formula I can use to pull the Entity name from the Workflow Profile that is selected by the user?  So if the user is importing the “Chicago” entity (which is assigned to the “Chicago” Workflow Profile), can the Data Source somehow read that?

Hi all: Looking for advice on how to implement multiple parameters in a report book.  The standard loop functionality does not meet current needs.  Our reporting requires a user to specify 3 UD's to report out their area of responsibility.  Each user will have multiple sets of 3 UD's to generate all of their reports.  In theory, they need to 'loop over' this set of parameters generating reports for each set.  However, the standard loop functionality is only 1 parameter and nested loops will generate unnecessary combinations as it would be the cartesian product of all parameters. Example:   Anyone have suggestions on how to implement this?  Is there a way to call a BR from the report book to substitute multiple variables at a time? I envision the ideal state as: User populates a simple CSV file with their report sets consisting of a name, UD2, UD3, UD4, and owner User opens the report book User selects their report set CSV file The report book loops

Hi there, thankful for immense contribution from community that has made life easier as a system admin. Currently working on a requirement to query stage data for specific Entity, Account, Scenario, UD1 through UD5 and reseed it back to a intersection that got changed by user input to allow admin to revert any changes done by users. I tried using the below:   Dim criteria As New Text.StringBuilder criteria.Append("U1T = '" & ud1_seeded & "' ") criteria.Append("And U2T = '" & ud2_seeded & "' ") criteria.Append("And U3T = '" & ud3_seeded & "' ") criteria.Append("And U4T = '" & ud4_seeded & "' ") criteria.Append("And U5T = '" & ud5_seeded & "' ") Dim dValue As Decimal = api.Functions.GetStageBlendNumber("TestCube", "TestEntity", _ "TestScenario", "2024M1", "TestAccount", BlendCacheLevelTypes.Custom, "Test", _ "TestWorkflowProfileName", "U1T,U2T,U3T,U4T,U5T", criteria.ToString, "Amount", _ BlendNumericOperationTypes.FirstValue) &nb

I want to read a list of members from a excel file which is store in OS file system and store that list of member ID in a list to perform further calculation

Is there a list of keyboard shortcuts available for OneStream using Excel.  Having a hard time trying to find any documentation on shortcut keys that work for OneStream excel addin.

I have SQL Table Editor with about 70 columns. I have the bound column tied to a parameter. But I need to access the value of another column of the selected row based on a button click. I want to process that row in the BR function. PLease help.

Hi All,Setting up the context for the question:I am trying to load the data via 3 different import channels (chan1, chan2, chan3) in a same WF.2 of the import channels (chan2, chan3) are for the sales data load and 1 (chan1) is used to load the historical data for those entities in the similar data unit.  Basically, data from chan1 has data units that is shared between chan2 and chan3. I enabled the overlapped sibling settings to merge the data from (chan1 and chan2) and also for (chan1 and chan3).  The issue I am facing is as soon I load chan1 after loading chan2 & 3, the import channel status for 2 and 3 goes to LOAD CUBE from PROCESS CUBE. If I reprocess the chan2, the status for both chan1 and chan3 gets changes to LOAD CUBE despite of the fact that chan2 and chan 3 have different data units (Both of these channels are hitting different sets of accounts)?Has anyone faced this issue in the application? If yes, please guide me to freeze the status of

We have users that frequently desire to mass updates to their transformation tables.  We use the TRX download/upload process to export current mappings and upload changes.  This works great except the TRX buttons are only available to administrators.  I believe that these should be available to admins along with anyone within the assigned maintenance group.  Is there a way to provision this? 

We leverage many cube view for monthly expense reporting and one particular report will not return values for certain columns that are pointed to a single User Defined dimension, but returns data for other columns.  There are no security restrictions on this or any dimension and the users security is no different that others who have no issue running the cube view and rendering complete data.  Has anyone else run into this or a similar issue?  YTD 6/30/2023     UD4#AlphaUD4#BetaUD4#OmegaUD4#TotalOperating Expenses$100,000BLANK/NA$150,000$250,000