OneStream Platform Forums

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 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

hi,Cell data for the below intersection has been saved into the cube.  Error logs  shows the percentage value getting saved into the intersection. But its not showing up while reteieivng with the Quickview with the same intersection. Any property needs to be updated. UD8 member LRP_Percentage  has been used to store the percentage value.  Thanks 

Hi OS experts,  I want to exclude a base entity - as it must not be affected by the derivative - from its parent for the purpose of this derivative. All entity under a specific parent (ie TDM)  must be part of the derivative expression but excluding one base entity. Anyone knows how I can achieve this? This is my derivative expression ->  

Has anyone used or familiar with OneStream SAP Connector. Need confirmation on couple of questionsIs it SAP certified?Can it connect to SAP On-Premise (with OneStream On Cloud) ? If so what config are needed? Do we need VPN connection? Thanks,Sachin

Mocking up a Prototype using the new Assembly feature in 7.4, I would like to be able to reference an Extender Business Rule within a Dashboard Assembly file. The scenario is, that I have a custom class (POCRunner) in an Extender file, and want to be able to call functions on that class object, when hitting a button in a Dashboard. I can't seem to find the right combination of assembly name and/or dependencies. The argument to have the custom class in an Extender, is also to be able to utilize a Data Management Sequence to trigger a job, calling the POCRunner class.Otherwise open for any other suggestion / approach.Thanks

We have built a custom model in a dev environment and now want to migrate this to a user test environment.  The build includes a number of database tables that we want to copy between the environments as they contain a large amount of data that needs to be used by the user test and will also be required to be migrated to the production environment.  Is there a way to copy database tables between environments, there doesn't seem to be anything obvious in the Load/Extract object list?

Hi all, Is there a way to have the pivot grid in a BI viewer automatically expanded? I've built a custom JE report as a grid but the user has to expand every single column in order to see the JE description for example before exporting in order to get that data on the export. It's manual work where I should be able to set up the pivot to default as expanded or there should be an "expand all" button. Appreciate any direction you can provide! Thanks! -Nicole

Is it possible to show the task progress dialog (see picture below) of a DM task started in a BR. Dim task As TaskActivityItem = BRApi.Utilities.ExecuteDataMgmtSequence(...) ' Do something with task to show dialog? Or is there another way to consolidate from a BR, where it automatically shows the progress dialog?Context: Button -> Dashboard Extender BR to change params -> DM sequence -> Consolidate. I need the Dashboard Extender API on same button press to change params, so can't call the DM/consol directly from button press.