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.32Views0likes1CommentFiltering account by UD's
I am creating an alternate roll-up of our accounts for some specific reporting which requires that certain accounts only return data for specific departments. What is the best way to do this? I tried using a dynamic calculation to create new accounts that filtered on UD2 but it did not return any data. The formula that I used was Return api.Data.GetDataCell ("A#61550:U2#Dept48")Solved39Views0likes3CommentsGenesis 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?65Views0likes2CommentsAlias Dimension Property in V9.1
The newest release (9.1) of OneStream introduces the Alias property for just about all of the dimensions. The only place so far where I have found the Alias as being useful is in search. I have not been able to figure out the correct syntax to be able to use the alias in Cube Views, Quick Views or any business rule. My guess is that we are going to have to create a custom business rule that will allow us to call the Alias name and present in a viewable format. Does anyone have an example of where they have been able to display an Alias value in a Cube View or Quick view instead of displaying the default member name and/or description?Solved57Views0likes4CommentsApplication 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, Kim5Views0likes0CommentsIntermittent 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.10Views0likes0CommentsScenario management for FX
We are in the design and build phases of OneStream and it is really important to me that we get the foundation right and use OneStream the way it was intended to be used. What are the recommended design solutions in OneStream to enable users to quantify the FX translation impact separate from performance when comparing one period of time to another (e.g., YTD actuals versus budget or full year latest forecast versus full year budget). Hi HFM we do this through recalculation scenarios. For example, we have the following budget and forecast scenarios. 14 forecast scenarios - one for each month, one to recalculate the prior forecast at the most recent actual rates (used for comparisons against YTD and month actuals), one to recalculate prior forecast at the forecast rates (used for full year comparisons to prior forecast and full year budget). The latter two get overwritten every month with the latest previous forecast data and new rates. 3 budget scenarios - one for the original budget, one to recalculate the budget at the most recent actual rates, one to recalculate at the latest forecast rates. The latter two get overwritten every month with the new rates. The process works well in HFM. Should we design the same solution in OneStream? How do other people manage this?28Views0likes1CommentFailed in the registration exam
I plan to register for the OCA(Implementation Foundations) exam. However, after I entered my credit card information, according to the registration guide, the page was supposed to be redirected to the MonitorEDU interface and then I could choose the exam time. But my interface didn't jump over, instead, it returned to the registration exam interface. I tried several times, and it was possible to register for other exams(for Example OCA R2) and succeeded, but only for the OCA exam, the registration failed. Does anyone know the reason?18Views0likes0CommentsDynamic Grids
I am looking for anyone with some experience with Dynamic Grids or are aware of any good documentation. There is very little in the OS documention beyond how to create the component and shell of a service. I am looking for any examples of how to actually create one. Right now I have a dynamic grid that produces nothing. It calles the WsasDynamicGrid class but I have no idea what to put in the functions. I think Dynamic Grids will be helpful in my usecase but can't get off the ground with a basic example to explore its possibilities. Thanks in advance.Solved155Views0likes8Comments