Genesis: BI Viewer Configuration, Data Source, Excel
Currently I get the following error when trying to make a data source from an Excel sheet: As I have tried to narrow the information down due to endless error messages the file looks like this My question is: Where do I find a description of how to set up a data adapter in Genesis to an Excel sheet.
BI Viewer drill down without hidden data items
I'm trying to create a drill down in a BI Viewer dashboard using only a data set return. I can add a column (in this case "category") to both the Dimensions and Measures area. I then enable the drill down under Data > Drill Down, however, once the drill down is active, the Category column is hidden on the output and won't show until you drill into a row. I want to ability to drill into a row, but a user needs to see the Category column first before drilling. Is there a way for me to drill into a dataset without using "hidden" dimensions and measures for a column? Also - what is the difference between "Dimension" and "Measure"? Thanks!
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!
Workflow Status Details including user names
I'm looking to add user names to the workflow status report we've already created but I can't seem to find where in the database tables that info is tracked. We've manipulated the WorkflowStatus method query to pull in the WF steps and the status of each. For example: I reached out to OS support and they pointed me to these two posts, one of which mentions CertifySignOffInstances. Workflow Confirm and Certify Users Info | OneStream Community Displaying user names on the workflow status report | OneStream Community I can also see WorkflowLockHistory as a table but any thoughts on which other tables store workflow status by user info? Appreciate any direction you're able to provide! Thanks!
Narrative Reporting Issue
Hello! Has someone tried Narrative reporting in 9.1 version? I am currently experiencing issues: 1.- Inserting charts/Advanced Charts / Reports if someone could insert an exaple on how they have done it. 2.- I cannot vie the artifacts and acces them, this message keeps popping up (and the names are fine) Thank you so much for the help!!Bi Viewer - Totals in Pivot table - Cube View MD
Hi All, I have a Bi Viewer dashboard where the total for the "NET ASP" column (grey row) is the sum of the submembers. However, this is not correct for the totals [Net Sales / Net Units]. But I'm not really sure how to do it with the current data adapter, Cube View MD. Just some FYI - The first level of the rows is the products, and the second is the market. Did anyone ever face something like this? Thanks, DavideBi Viewer - Hierarchy display
Hi All, I'm struggling with the Bi Viewer pivot table. I'm trying to get a hierarchical view on the rows for our UD2 - Market dimension. I have to use the Data Adapter Cube View since I have some calculated fields that cannot be replicated using the Cube View MD. Has anyone had the same issue? Thanks, Davide
