Recent Discussions
Narrative Reportings Extensible Docs
Hi, I need to provide a demo for a customer who is exploring using Narrative Reporting. I am using the Termplate to create the Root/Section/Document structure. Can anyone provide me with the Extensible docs that are associated with the template and imported into NR? Displayed in green below: It would save me a lot of time and effort. Many thanks GuyGuyRogers5 hours agoNew Contributor II12Views0likes0CommentsCubeview: Cell type Date Format
Hi everyone, In my CubeView I have a cell defined with the Date data type and I would like to force its display using the number format dd/MM/yyyy, However the format never changes and is always displayed as MM/dd/yyyy, probably due to the US culture settings. Do you know if it is possible to override this behavior? I assume it should be since multiple date formats are available. Thanks, NicolasNicolasLorgeray2 days agoNew Contributor II21Views0likes0CommentsEmbedded 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, NuryanaAiLie2 days agoNew Contributor II43Views0likes4CommentsPublish a Document in Narrative Reporting
Hi Team, We have an issue in publishing the document in the Narrative Reporting. while Publishing the document, it is saving under respective user folder. how to publish a document in share folder or any group folder. Can you please help us resolve the issue. Thank you, Shiva PrasadShivaPrasad6 days agoNew Contributor III7Views0likes0CommentsData formatting GridView
I have tried multiple ways: Literal Perameters, Column Formatting, Data formatting to try to format GridView cells. I have some decimal data coming over. it is formatted as $#,###,0;($#,###,0);$0 I cannot get it to Horizontal Align Center, Negative Text = Red. This is really agitaitng. Trying to align my data, show Negative Values as Red. Thank you in advancedCaptJack7 days agoNew Contributor II26Views0likes0CommentsCube View : Top10 Business- One member above the base hierarchy
I need assistance in selecting the immediate parent of a base member. Currently, I am using a Business Rule (BR) to identify the Top 10 Business, but I am unable to retrieve the correct members. My requirement is not to select the base members themselves, but rather the member directly above each base member in the hierarchy. Scenario: I am using the following formula to select U6#Top_Business.Base.options. However, instead of retrieving the base members, I need to capture their immediate parent. Is there a member filter formula available that can achieve this? U6#Root.CustomMemberList(BRName = -----, MemberListName = Ranked, RankType = Top, RankCount = 10, LoopMemberFilter = [U6#Top_Business.Base.options(Cube=Main_Cube, ScenarioType=Actual, MergeMembersFromReferencedCubes=False)], DataCellToRankMemberFilter = Cb#Main_Cube:E#Top:C#USD:S#Actual:T#2025M11:V#YTD:A#Example:F#Example_activity:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U7#Top:U8#Top)bharathsm14 days agoNew Contributor33Views0likes0CommentsCreate Single Formatting Rule
Good morning, So, I am creating a Report Component with, at least, 75 different data cells from Data Adapters. When it comes to a Formatting Rule, I am looking for a single rule where the condition is dynamic based upon the value of the cell it is applied to. This is just a small portion of the cells. I would like to format all of them as ($##,###) in Red if it is negative. I have tried using [Value] < 0 in the condition but everything is turning red. I have created calcualted cells to turn any text into Decimal. I don't want to have to create a rule for every cell. Also, when it comes to the Format String, what is the syntax to make negative number show in parenthisis?CaptJack15 days agoNew Contributor II12Views0likes0CommentsExplanation of Storage Type & Existence type
Dear community, I couldn't find any documentation about Storage Type and Existence Type. Any help or hint toward documentations would be greatly appreciated, especially on the one highlighted in red below. What I mean about storage type and existence type is the status associated to a specific cell: Storage Type: No data IsRealData IsDerivedData Storage type: StoredButNoActivity Input Journals Calculation Translation Consolidation DataCellDetail DurableCalculation Regards,Sergey21 days agoOneStream Employee38Views0likes0CommentsRPTA 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 FunctionSolvedRussell22 days agoNew Contributor III34Views0likes2Comments