RPTA Application Reports Error in 9.1
After upgrading to 9.1 recently we can't use our Application Reports because of this. Error compiling Business Rule 'RPTA_SolutionHelper'. 1) Error at line 13635: Type expected. This line is causing the error. Dim dataWcfService As New Data() Even if I were to fix that line the next line would be wrong because there aren't any overloads that accept a GUID for the GetFXRateType function. Private Function GetMemberPropertyGuidValueAsText(ByVal si As SessionInfo, ByVal objPropEnumTypeItem As PropEnumTypeItem, ByVal storedGuidValue As Guid) As String Try If (Not objPropEnumTypeItem Is Nothing) Then Dim editorType As XFDataColumnEditorType = objPropEnumTypeItem.EditorType If (editorType = XFDataColumnEditorType.WorkflowChannel) Then If (storedGuidValue <> Guid.Empty) Then Dim wfWcfService As New Workflow() Dim wfChannel As WorkflowChannel = wfWcfService.GetWorkflowChannel(si, storedGuidValue) If (Not wfChannel Is Nothing) Then Return wfChannel.Name End If End If ElseIf (editorType = XFDataColumnEditorType.SecurityGroup) Then Dim securityGroup As Principal = EngineSecurity.GetGroupOrExclusionGroup(si, storedGuidValue) If (Not securityGroup Is Nothing) Then Return securityGroup.Name End If ElseIf (editorType = XFDataColumnEditorType.FxRateType) Then Dim dataWcfService As New Data() '<===ERROR HERE Dim objFxRateType As FxRateType = dataWcfService.GetFxRateType(si, storedGuidValue) If (Not objFxRateType Is Nothing) Then Return objFxRateType.Name End If Else Return storedGuidValue.ToString() End If End If Return String.Empty Catch ex As Exception Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try End FunctionSolved13Views0likes2CommentsWant to report on Workflow Profile Workflow Name (a property on the WF profile step setup)
I'm looking for a way to report on our workflow profile set up - specifically want to be able to pull the workflow profile (the forms step added to the WF) and the associated "Workflow Name" (which is an awful name for this). Workflow Name refers to the tasks on the step: The point is to make sure certain steps are all set up the same way with the same step tasks but I can't determine the best way to do this right now. Looks like the WorkflowProfileAttributes table may possibly show me but I don't know where I can find a listing of what the AttributeIndex equates to on the actual WF set up (design doc shows zero results when searching either of those terms). Any direction or guidance would be very much appreciated!!65Views0likes3CommentsHow to populate a Dashboard List Box referencing WFText4 but the UD dim may vary across Workflows?
As the title suggests, I am trying to populate a dashboard list box that references the Workflow text property regardless of the dimension being used. I'm able to populate the list box using a single dimension, meaning a UD3 member is populated on the workflow's WFText4 property and a member list parameter uses |WFText4| to pull it in. How would I get this to work if the Workflow text value is not always UD3? For Example (both workflows will be using WFText4): Canada Workflow A needs a UD3 Member.Base to populate in the list box when they run the dashboard in their workflow but Canada Workflow B needs a UD6 Member.Base to populate the list box when they run the dashboard in their workflow. Please let me know if I can provide more context.28Views0likes3CommentsEmbedded dynamic repeater
I have a cube view with a parameter on Entity |!Entity_select!| that I would like to put in a tabbed dashboard that has one tab for specific Entity member. I am using dashboard type "Embedded dynamic repeater" where the component is data explorer report. Data explorer report has data adapter component to the Cube View. I thought the way to do this would be to use the template parameter values in the collections. But it shows error as attached below. It seems that the template parameter value was not passed to Entity_select parameter. Is data explorer report component compatible for dashboard embedded dynamic repeater? Is there any sample of Embedded dynamic repeater dashboard using data explorer report component? TIA, Nuryana34Views0likes3CommentsCV Spreading
Hello, We want to spread data acrross multiple periods in a cube view, so we select the parent member (Year) and we expect that automatically OS applies spreading to all its base time members (months). However, we are working on a forecast scenario with the setting "Number of No Input Periods Per WF Unit" set to 4. And we don't understand how the spreading works. It seems the system calculates the difference between the amount entered at the parent member (Year) and the total amount of the closed months (the no input periods), and this calculated amount is the one that is saved at the parent member (Year), instead of the amount enetered initially. Could someone help us to clarify this calculation? Thanks!21Views0likes0CommentsNarrative 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!!103Views0likes2CommentsReports - Column Width
Hi Everyone, I recently developed Flux reports for my organization, I'm encountering following issues. When I type comment on the 'Comment' column, if the comments is of say 100 words, the red line which I marked in the screenshot keeps moving to the right. refer screenshot below. How can I fix this issue? I use, V#Annotation for Comment column. 2. When multiple users, try to update the comments, the comment from the last save is only visible. Could you please advise how can i overcome this? thanks in advance17Views0likes0CommentsDisplay Parameters of Embedded Cube View
OneStream Community, I am having difficulty applying visible parameters after embedding a Cube View in Excel. When I embed the Cube View and select "Use Display Value" the parameters appear but the parameter member list drop down is misaligned to the applicable parameter. Additionally, when the Cube View connection is removed and re-embedded without selecting "Use Display Value" on refresh the cube view shows an object reference error, but then after selecting ok the cube view will render with no issue. Has anyone come across this?20Views0likes0CommentsCreate Excel Book
Hi, I am trying to create a OneStream Book that contains data in Excel format instead of PDF from a dashboard component. Currently, the book uses a dashboard report component to generate a .xfDoc.pdfBook containing the data, which Parcel Service then attaches to a list of emails and dispatches in a zipped folder. I attempted to create a book that retrieves the data from the same dashboard component but in .xfDoc.xlBook format. However, every time I run the Parcel Service to dispatch the file in Excel format, the Excel file is blank. Could you please advise if there is a way to obtain the same data in the Excel attachment as we have in the PDF attachment? Thank you804Views0likes3Comments