Populating Future period in a Cube View
Hello, I'm trying to create a cube view that grabs actuals from People Planning and populates the future periods with the latest month of actuals. e.g. in M3, M1=M1 Actuals, M2=M2 Actuals, M3=M3 Actuals, M4-12=M3 Actuals. I need this in a cube view because we need to be able to show the data in both local currency and USD. People Planning is currency agnostic. I tried this directly querying XFW_PLP_Plan with SQL and a biViewer, but ran into the problem of not being able to bring in FX rates. I can only show local currency. Has anybody done this or have any ideas? Perhaps something with UD8? Perhaps there is something simpler I'm overlooking? There is SO much to learn with OneStream and I know I'm only scratching the surface.
How to pull Workflow Parent in CV or QV
Hello Team, Generally, User will open a form through workflow and input data and certify that. i need pull a data Like, which user has certified the form for respective site. and in which table those User certified details will be store. Can you please help us on this.
Adding Gross Profit as a Column in a Bar Graph (BI Viewer)
I was wondering if it's possible to include Gross Profit as a column in a bar graph in BI Viewer. Specifically, I want to calculate Gross Profit as the total Revenue minus Expense accounts and display it as a separate bar in the chart. I've tried using Calculated Fields, but I haven't been able to get the total to appear correctly in the visualization. Has anyone successfully done this in BI Viewer, and if so, what approach did you use? Any help would be greatly appreciated!
BI Viewer does not show Data After Initial Setup
Edit: Have determined that if I remove a column from the BI grid view and then replace it, data will populate the component again. Still don't have a reason or fix for the issue. Hello, I have a BI viewer that works fine in the initial setup/shows data pass through. I will run the BI in a dashboard once and it will also work correctly. If I run the dashboard again, it stops displaying data. I checked and my data adapter functions as expected, and if I delete the BI and make an identical version it will also work initially in the BI Viewer component once and the dashboard once. The viewer operates off of two combo box member lists, and I've confirmed that those update my dashboard data set rule when I refresh my dashboard. If anyone has any input on this situation it would be much appreciated.Entity Drill Down BI Viewer
Hello, I'm learning to use BI Viewer, is there a way where I can drill down the entity dimension from region to base level? I've tried different expansions and I either get only regions or everything and when I try to drill down the region, it just gives me the region again and not the base entities that make up those entities. Thanks, Will
How to make the column names dynamic in BI-Viewer pivot or Grid
Hello, I am facing a problem in making dynamic names for BI-viewer. I have a data adapter with Command type as Cube view. I am using this adapter in BI-viewer. I want to make the column names similar in cube view. For example, in my scenario I have columns changing according to the time. but here it will show as Col0Value, Col1Value. As per cube view headers, Col0 is 2024M1 and Col1 is 2024M2 and this will change according to time updated for next periods. It will not be same every time. How to get the same names as per cube view into BI-viewer column list.
