Recent Discussions
Data Adapter SQL Query to view data submitted through Excel
I am here with one of my typical requests to see if anyone has (SQL query) code I can borrow 🙂 We had an issue with two users who discovered how to submit data through Excel and circumvent the workflow forms. As a result they are inputting data to intersections where we do not want forecast data. I would like to have a dashboard I can run where I can select a specific scenario and it will return a list of intersections that were modified through an Excel submit. Or just a list of users and then I can run the ONC application report User Data Entry Detail to get the details of the intersections. I know the data lives in a table somewhere but I am not sure the table name and the fields to filter on and return. In the ONC User Data Entry Detail report I am able to select a scenario, WF time and user name and can see data they changed via forms and data that was changed via Excel. But, there is no option to see all Excel edits for all users and I am trying to catch the rule breakers 🤫. Any help with a SQL query would be greatly appreciated so I can create a data adapter, and display it via a grid view in a dashboard. Thank you, Denise
Pass through external parameters into dynamic cube view services
Hello, Is there a way to pass a combo box paramater into a cube view service? I think would be through the Service Factory. Since the cube view service runs when the cube view is executed and there is no call as XFBRs or Dashboard extenders, Is there a way to pass parameter values into the cube view service business rule?Drill-Down to Stage with Attribute Dimension
Hi everyone, I have two attribute dimensions in my model that I use to filter Cost Centers by Region and Line of Business. The issue is that when I try to drill down on those cells to reach the Stage data using “Load Results for Imported Cells”, I’m not able to get to the maximum level of detail. I assume this happens because the system is filtering by attribute members, which do not exist in the Stage tables. Has anyone experienced something similar or found a solution/workaround for this? Thanks in advance!
BI Viewer Pie Chart Labels Not Displaying Properly in Dashboard – Any Workaround?
Hello Everyone, I created a pie chart using the BI Viewer in OneStream. The chart displays correctly when viewed directly in BI Viewer. However, once I add the pie chart to a dashboard, the labels are not fully displayed as expected. Has anyone experienced the same issue? Is this a known limitation when embedding BI Viewer components into dashboards? Is there a setting I might be missing? Do you know of any workaround to force labels to display properly? Any feedback or suggestions would be greatly appreciated. Thank you!Text Field - Default Format When Rich Text
Is there a way to default the format in a text box where rich text is allowed to something other than Calibri? it remembers the state of the component when I open a dashboard change it, save, and close the component but when I create new items from the dashboard the new items that get always default to Calibri.
Worflow form tracker
Hello, We are looking to create a form tracker that provides a global overview of the progress across all our entities, do you know if this is possible ? Headers = All our entities Rows = all of our forms Data = Text to see if the form is complete Thank you in advance for your help, Regards, Antoine
RCM Child Balance Report
Hello, We need an RCM report to tie recon balances back to OneStream for audit purposes. Has anyone created or knows how to build a report showing balances for child recs (without the balance for the associated recon) and balances for recons that have no child recs? The rcm database tables aren't very intuitive and a little guidance would be a huge help! Thanks!Extensible Documents Cubeview margins
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.
How to merge column headers in Cube View 8.4 - MergeAndCenterColumnHeaders not working
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 properties The merged header is not appearing. Has anyone successfully merged column headers in version 8.4? What am I missing? Thanks! Output required:
Top-side Entries
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?
