Recent Discussions
Report Books - Dashboard Chart
Hello, I have an automated report book and would like to expand the functionality to include charts (in addition to the existing cubeviews). I was able to add the chart, but I'm struggling with trying to control the formatting. I would like to modify the header and have the chart fill the page (too much white space). See below. Thanks! Is there a way to format the chart output, in particular I would like to enlarge the chart image and have it stretched across the page?
Cube View sum of columns sums only values from column with first child
Hi everyone, I'm having an issue with a cube view. I have a column whose parameter is E#GroupEntity.Base. When launched, it shows one base entity per column, with its respective data. I need to place a new column at the end of the cube view that sums the values of all the base entities. I tried to use the CVC function to sum columns, but it only sums the data of first base entity, ignoring all the other base entities. Is there a way to achieve what I need, and if yes, could someone please help me? Thank you!
Using "ColumnDisplayType" property in grid view component
The ColumnDisplayType property has two options: WorkflowStatusImage & OneStreamClientImage. I am looking to leverage one of the two options, but have found minimal documentation on them. What I have found, is that the WorkFlowStatusImage is related to values in a Status column like "2" equals a green circle, "10" equals a red circle. This uses the XFClientImageTypes library. I am not sure how to leverage this library and populate my SQL table/grid view with one of these status images/icons. Any assistance is appreciated. I have the status column value equal to "2" or "10" but I can't get the icon/image to display on my grid view component.Bulk edit dashboard frames
Is there a method or tool that can edit dashboard frames (names) in bulk? I would like to create a base dashboard template that would include headers, content, and footers. This would be copied & pasted to separate maintenance units and then customized for each dashboard. Is there a way to bulk-edit dashboard frames, or assist with copying & pasting dashboards without renaming them one by one? The only way I know of now is extracting to an XML and changing the text through notepad.
Application Reports & Parcel Service
Hi all, We have an interest in being able to provide the Map Changes Audit Report (out of the standard Application Reports dashboard) to a group of users via the Parcel Service function. I've been able to narrow down the application report itself to an "RPT" component but not sure where to go from there. Has anyone out there managed to set this up and if so, would you mind providing a high level view of the steps involved? Thanks very much in advance, KimCube View Cash Flow Report QTD or MTD
Our cube view cash flow reports were built using an account hierarchy and includes parent cash flow accounts to rollup base accounts. The cash flow reports were originally built on a YTD basis. Later the view parameter was changed to also generate cash flow reports on a QTD or MTD basis. The QTD and MTD cash flow reports reflect the correct calculated movement of balance sheet accounts for the parent cash flow accounts, but still reflect YTD calculated movement for the base accounts. Any income statement accounts included in the cash flow reflect the correct YTD, QTD or MTD amounts for the parent cash flow and base accounts. OS Community - Does anyone have a similar cash flow report build including options to generate the report QTD or MTD and solved obtaining QTD or MTD balance sheet base account calculated movements?Genesis Cube View with Drill issue
I've been working on getting up to speed with the various Genesis content blocks and am having trouble with the Cube View With Drill block. When I try to select a cube view, the tree view only goes down to the Cube View Group level, not the Cube View level. I was able to tweak a business rule to allow it to select a specific cube view, but then the drill doesn't appear to work when I select a cell to see the details. I'm certain there is data that can be drilled down to, but nothing changes when I click various cells. I've even tried setting the cube view to show a base-level intersection and confirmed that I can see a number that is the same in stage. Anyone seen this issue yet or have any troubleshooting tips?
Intermittent 500 Error when calling OS Data Adaptor using Rest API 5.2.0
We have several applications calling OneStream data adaptor via Rest API. Very frequently and randomly the connection fails with a 500 error. If we wait and retry the connection is successful. We have not been able to find the root cause. We observed that when the Rest API has 2 entries in the Log Activity table in OneStream the connection is successful. The screen shot is from the Logon Activity table in OneStream. Every so often the connection fails with a HTTP 500 Error and we observed that only one the set is entered in the table. Have any of you encountered this type of issue.
