Reporting

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 thanksGuy

Hi,I'm trying to find Narrative Reports in the Solution Exchange.Can anyone let me know where it is so I can download.ThanksGuy

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 

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,Nuryana

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

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)

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?  

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,

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 wf

We are having an issue with users and page breaks in the excel add-in.    Example 1:  A user creates a cube view connection and pulls said cube view into an excel worksheet.   The result, however, does not render all the rows.  There is a page break and they are forced to page through to see the rest of the rows.   If I replicate these actions, I do not get the same page break, my results render all the rows on a single page.  No page breaks.  We went through preferences and other excel settings together to make sure our settings matched.  What is causing this to happen?  What other things can we try to resolve?   The user must have all the rows displayed at once (no page breaks).  Example 2:  A user creates a quickview only to have the results get cut off with a page break.  If I replicate the quickview, the return does not cut off the rows.  I get everything on the sheet.  Any hints, tips,

statement 1: gives zero which is correct =VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "F99", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE")) statement 2 : gives value which is correct =VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "FNONE", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE")) statement 3: gives incorrect value =VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "F99", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE"))+VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "FNONE", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE"))This works correctly in 8.4, but not after upgrading to 9.1

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!! 

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.

The title and image attached should provide enough context but please let me know if I can provide any additional information.

Hello,  When i am running Books from File Explorer -  Application Database, I am getting the below error, did any one come across this issue. requesting to help me how to handle this issue and get output.   

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!   

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.    

Hello, I have a table view where I also allow users to save changes. In my code I'm checking for the cells that have changed using "If tvr.Item("Bonus").IsDirty()". This seems to work fine for non-numeric columns, however, I find that for the numeric columns the cells are always marked as dirty even if they are not changed. I tried different things, e.g. marking the column as decimal data type "tv.Columns(7).DataType = XFDataType.Decimal" but so far no luck. Do you have any advise how this can be solved? Thanks, Volker

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?

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!!

Hi,I am working on the cubeview below, where I have 2 dynamic calc accounts. On some of the cells their value is greyed out. The dimension on column is UD4. Can somebody help me understand why some of the values are greyed out? Thank you  

Hi,A user is facing two issues with Excel add-in.  XFGetCell and XFSetCell formulas with XFGetMemmber Property are used (XFGetMember function only at the top of the page). There are 15 sheets in the Workbook page.Has anyone experienced issues described below?  What is the likely solution?  Is it V8.4.1 specific issue? Thanks in advance for any help/pointers.Two issues:(1) Retrieval formula dont work and have to keep refreshing the whole workbook/worksheet. When refresh one worksheet, the rest will went error. When refresh another sheet, previous sheet went error.(2) When trying to save an offline version of retrieval file but error keeps pop up as attached.

Hi everyone,  Is there a possibility restrict the user only view the comment in specific CV and specific column cell.

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 advance  

I have a cube view with a parameter on UD5 |!param5!| that I would like to put in a tabbed dashboard that has one tab for specific members in UD5. I though the way to do this would be to use the literal parameter values in the Dashboard Properties. I have tried entering the following:param5=member1and done this for 4 dashboards. The problem is, ALL the dashboards have the value of member4 since this was the last dashboard in the list to be rendered. If I swapped the order (1,2,4,3) then all dashboards have member3 as the filter. I have tried setting the parameter up as a literal and input parameter and it behaves the same way.Is there something wrong with the syntax? TIA,James