OneStream Platform Forums

Hi All,I am trying to export a cubeview using FdxExecuteCubeView, but I get every dimension even though my cubeview only shows 4 dimensions.  What is the best way to export a cubeview to retain its view.  I want to export multiple cube views and load them to a table so that I can have all of the cubeview data exported through one Data Adapter call via the rest API. Right now, I export one view I get 3 million rows, but when I aggregate it to the level in the cubeview I end up with 28,000 rows.  I'd like to avoid exporting 12 million rows if possible. Thanks,Scott

Hi Everyone!, I have been unable to set margins in a cubeview in a extensible document. Even though, the report margins in the cubeview settings are set and the argument IncludeReportMargins is set to true as can be seen in the attached images. But no margins are shown. Thanks for you help.

Have you seen a KB / post that met the requirements for daily data?Please share your experience / practical advice to help us meet daily data requirements.- for Planning- flat files: Daily Data per Month- flat files: Daily Import- Reporting by Day by Month Thank you folks for sharing your expertise.

Hi,I have created one one Smart integration function in to transfer file from sftp server to share point server. can we use smart integration function as a file or use existing smart integration function as dependency , not sure just need suggestions.

Hi Folks,  I was wondering if there was a way to display a description for the Cube Root Workflow Profile in the dropdown menu.  For example in my screenshot there is Corporate_MON and Corporate_WOR. I would like them to display: Corporate_MON - Monthly Forecast Workflows Corproate_WOR - Planning Workflows Note: I did try adding descriptions, they only seem to display for children of the main Cube Root Workflow Profile  

I am working on security groups; can we hide these sections to selected users? I can't find the right application/security role for this. Thank you.  

Good day to you. Currently, we are working on a Dashboard for User Access. We have successfully implemented the logic to retrieve Security Group Unique IDs along with their corresponding Security Group details. As part of this dashboard, we now need to retrieve Workflow Profile–level details, specifically: Entity assigned to the Workflow Profile Access Group Maintenance Group Workflow Execution Group Certification / Signoff Group So far, we have been able to retrieve details for points (1), (2), and (3). However, we are unable to fetch the Workflow Execution Group and Certification / Signoff Group details using either Business Rules or SQL queries. Could you please help us by suggesting: The appropriate Business Rule method/API, or A supported SQL approach, to retrieve these remaining Workflow Profile security details? Your guidance on the recommended approach would be greatly appreciated.

What do you use as guidelines to flip the "inuse" flag on accounts or entities? Do you wait until the entity balances are brought to zero in your source or some other trigger? What considerations do you make around any immaterial translation values? Interested to hear what your company is doing - thanks so much!  -Nicole

Is it possible to build a dynamic cube from multiple cubes?  For instance, could I build a dynamic cube that had income statement level data from our month end close cube and summarized headcount data from People Planning?  To my mind this is where the power of Dynamic Cubes would really shine.

Hi Community,Did anyone have successfully used VBA to connect via Excel macro?I had tried all of the connection code from the link below without success;Visual Basic for Applications (VBA) ProceduresRegards,Seang

I created a new entity and workflow in OneStream. The metadata, workflow properties, and configuration are identical to existing workflows and entities.However, I noticed a difference in behavior:For the existing workflows, the confirmation rule displays results at the company level, even for entities with multiple child BUs.For the new workflow and entity, the same rule displays results at the BU level, showing multiple rows for each child BU.I have verified that the rule, meta data configuration, and workflow properties are the same. 

HiIs there and XFGet type of formula that can be used to retrieve the name of the application that you are currently logged into?Thanks,Mark

Hi, I have created a transformation event handler where it throws an error when an user tries to "Clear" file/s. in Import step. Now, the error comes when user tries to delete his/her file or "All" files. I only wanted it to throw error when user (mistakenly) selects "All" imported files and click on "Clear" Is there a way to achieve this by some conditions or checks?  Thanks in advance, PM

Hi, I'm using OneStream 8.2 and trying to merge 3 column headers (Forecast, Budget, Var) under one "|!Entity_Selection!|" header. I've tried  Setting MergeAndCenterColumnHeaders = True in Column propertiesThe merged header is not appearing.  Has anyone successfully merged column headers in version 8.4? What am I missing? Thanks!Output required:  

I'm having an issue with specific top-side entries not being captured by cube views, dashboards, and even business rules. The entries were posted to the Adj workflow with entity member filter: E#Root.WfProfileEntities. Could it have something to do with the entity member filter assigned to the journals? 

Hello -  Does anyone know how to add row/index numbers to BI Viewer as shown below?   Thanks,Bil Brandon

How do we remove the gray/blue gridlines from the Excel export and when printing to PDF? The screenshots below have no formatting. The cube view exports directly to PDF with no gridlines, but when exporting to Excel and printing to PDF, the gridlines appear. Thanks.  

Good afternoon, I'm curious to see how other companies handle this situation.  We've recently launched a Dashboard allowing the vast majority of our user base, ~800 users, the ability to interact with and drilldown on their financials. One of the growing pains we're experiencing with this change is that the users have the ability to create a PDF Book for their selected Locations + Children on whatever Cube View they're currently on.  So it could be one PDF or a lot (50+ locations).  Opening the Book Viewer creates a background server task which on its own doesn't seem to be an issue. However, we have a couple of "triggering" events that cause an influx of our user base to all access the system for financial review and book publishing at the same time.  Prelim financials are ready to review, financials are closed, etc. The problem we're experiencing seems to be when we have a lot of users all trying to create books at the same time it appears that their tasks are ste

Hello, Is there a way to move a workflow profile up or down in the hierarchy tree? I created a new workflow profile, but would to move it up next to similar workflow profiles. The move up or down buttons only work for children and siblings.  

We recently encountered an issue where users are unable to save offline copies, (v9.1) which led us into a broader discussion around version control and file sharing for our getcell reports. We’re looking for ideas or best practices from others who have implemented effective solutions to manage the below. What we’re hoping to achieve:- Multiple users able to access the same report simultaneously- A shared experience similar to Google Docs (centralized file access)- Strong version control to avoid duplicate or outdated files- Ideally, a simple check-in/check-out type process to prevent conflicts So far, the only option we’ve considered is a potential SharePoint integration, but we’re hoping to find a solution that is less technical and easier to manage from a superuser/user perspective. If you’ve implemented a process, tool, or solution that works well for your team, I’d love to hear about it. Thank you!

Hi I have a method query that returns a data table of roughly 300k of records. Is there anyway to export the result of the method query to a csv file? I'm not keen on using a spreadsheet business rule or a grid view on a dashboard given the volume of records that is being returned. Thanks, Mark

Hi everyone,I was wondering where there is an alternative way to create and manage users within an application without using the 'Cloud Administration Tools' dashboard. Any help is much appreciated!

Hi All, qq--is there a way to disable SSO login for one account. we have one user created in OneStream as a contractor, and now we want to enable that user to login to OneStream application without SSO.Our OS app is configured with SSO sign, so we get a code whenever we login, but i wanted to overcome this to the Contractor id, is there any way that we can disable the SSO login.  Any Suggestions pls. Thanks in Advance. ThanksSatish P

Hi OneStream experts,Lets say a dashboard has 10 components in DEV and in PROD.Added 11th component  in DEV and want to move it to PROD by Extract and Load.Is there any  easy way to collect all related components of a dashboard?Manually collecting components is painful. What is the best secured way to collecting objects to move it to PROD? Thanks//Suresh

Hi,Is there any way to remove the empty rows which are showing up once a cube view is used in an extensible document or in narrative reporting?Thanks,Florence