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 Guy
Cubeview: 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, Nicolas
Publish 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 Prasad
Data 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 advancedCube 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)Create 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?Explanation 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,
CV 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!Narrative Reporting setup Issue
Hi Team, In our system Narrative Reporting setup has done, but when we open Narrative Reporting. could not able Fetch and Load and anything. seems like everything is empty(below screenshot are for your reference). Can you please help us to setup the Narrative Reporting in the system.
