Reporting

Hi,We are having a grid view to display data through data adapter.How to display totals for a column at the bottom of the grid view?is there property to display total? like belowIsFilterable = False, IsSortable = False,     

Hi I am trying to make a welcome homepage using Genesis. I would like that the user always arrives at the news block (Green with blue underline) when logging into the system. But if the last time the user was in Reporting  then the dashboard starts up in reporting. See red box.  How do I force the system to start up in the green box?     Regards Ole 

Hi I have made a new instance regarding a new welcome menu to the users. Therefore I have two instances: The original when installing Genesis Welcome menu (named Welcome9) Du to practicality I need to embed number 2 into an existing dashboard. When entering the dashboard name ( container_bag_(App)_(Main)) in the embedded it takes number 1. Is there a possibility to enter Welcome9/Pnav_(App)_(Main)/container_bag_(App)_(Main) or how do I refer to the correct container_bag_(App)_(Main)? Or is it the wrong dashboard I am referring to? Regards Ole Strøm         

I'm creating a cubeview with comments page and trying to have comments tied to each individual group but comments are only saving with our top level group and not moving with the parameter. I've entered comments on our other groups and get the same result.  Below is what I have entered in commentary configuration.  Any ideas?

Hello the Community,Currently working on the formatting in a cube view, we noticed that the Transparent color in excel isn't working, most probably because Transparent isn't a police color recognized in Excel. Do you confirm you have the same on your side and do you have any other workaround than setting the text with the same color as it's background?Thanks in advance,Florence  

Hi the Community!I need to show, in a cube view, the subtotals of my rows, showing the dimension members presented in the Row1 header (I have 2 rows in this case). To achieve this, I built an UD8 dynamic calculated member and that works pretty well - when on the Row2 base members, then it shows the description of the members, if i am on the Total member, then it shows the member descriptions of the dimension which is set on the row 1). However, sounds quite basic, but I need to set another format on those subtotals, so I used the Conditional format based on the Row Member names (If RowE1MemberName ...), what is working perfectly fine, until I hide those row headers - in this case, then the conditional format doesn't work anymore !How do you achieve this kind of basic requirement in this case? Any idea would be very helpful :)Thanks is advance,Regards,Florence  

Hi everyone, I currently have a dashboard that shows the following table:the format of each field has been set in the SQL Table Editor settings, to allow the users to understand what fields can be updated.Nevertheless, I would need to make sure that the format of certain columns changes depending on how the users populate the table. For example, if the user inputs "MANUAL" under the col TAG, I would like the field "New Target Account" to become yellow automatically upon saving. So far, I only managed to make the content of the other cells dynamic using this construct in the Dashboard Extender BR linked to the SQL Table Editor:xfrow.ModifiedDataRow.Item("T_ACCOUNT_NEW")= "-----------------"Is there something similar that allows to also change the formatting of the cells?Thank you!

Hello guys!i have created aa cube view Cell type - combo Box, but there is an option that says No Data. Is there a way to hide or assign security to it, i don't want it to be available for my users.Thanks in advance. 

hi all, good day; we are using plug accounts and IC matching accounts property, we see the IC matching report but I would like to know if it's possible to get the partner currency in a cube view or though a fx formula in Excel? I konw that this is a derivated data, but would like to know if its available on any dimension or fx formula Thanks in advance and kind Regards. Mario Guerrero

Hi All,I have a Bi Viewer dashboard where the total for the "NET ASP" column (grey row) is the sum of the submembers. However, this is not correct for the totals [Net Sales / Net Units]. But I'm not really sure how to do it with the current data adapter, Cube View MD.Just some FYI - The first level of the rows is the products, and the second is the market. Did anyone ever face something like this? Thanks,Davide

Hi All,I'm struggling with the Bi Viewer pivot table. I'm trying to get a hierarchical view on the rows for our UD2 - Market dimension. I have to use the Data Adapter Cube View since I have some calculated fields that cannot be replicated using the Cube View MD. Has anyone had the same issue?Thanks,Davide

Hello, We are creating a cube view where the columns are dynamically filtered by the text fields of Entity and UD1.  I am fairly confident in building a business rule to return the correct result, but I am uncertain of how to then present that in a "totals" column within the cube view. What type of business rule should I use for this? Once I create the business rule to calculate the value, how do I get it to display in a cube view column? (extender rule, dynamic calc, etc.) Any help or guidance on this would be much appreciated.

I am having an issue with cube view parameters within the Genesis content block "Cube View Comments"?  I receive one of two errors - (1) Index was out of range (parameter 'index') or (2) Parameter is not supported.   However, if I put the exact same cube view in the "Cube View Advanced" content block, the parameters work exactly as expected.   Is this a bug or is there something I'm doing wrong?  Any help would be greatly appreciated.

I have a dashboard (not bi-viewer, standard OneStream dashboard) frame that needs to be shared with users outside the application on a regular basis. How can I use a screenshot of this dashboard as a picture or book file to be shared with users outside the app? Users currently screenshot the picture and save the file locally before sharing. I'm hoping to use a OneStream tool to accomplish this. I've investigated extensible documents and books, but they appear to require build a "report" dashboard component. Not looking to rebuild the dashboard from scratch.  Ideal situation would be similar to how cube views can embed to picture in Extensible PowerPoints, but I'm open to other options. Thanks in advance

Hi, In NRR, is there an out-of-the box way to identify (highlight) dynamic variables while editing but to remove the highlight when it's ready to publish? This is helpful when toggling between Show Fields Codes and Hide Field Codes.

Hi,  We're building custom variables for NRR to enable users to select from a set list. These variables are built in Parameters with custom querying. Is there a way to enable these variables to be selected from Artifacts -> Contents or somethin equivalent inside NRR.

Good afternoon,I was wondering if anyone has had the issue of In-Sheet Action Buttons turning grey and not working within the excel add in. The environment is 8.5.1, using the 64 bit version of excel, and has the updated excel add in.When using the in sheet actions within the spreadsheet tool, there are no issues with the Buttons and the DM steps run as expected.When opening up in Excel, the first button is greyed out and does not initiate any tasks, while the green button still works.     If anyone has any resolutions, I would appreciate it. Thanks, Ben 

Hi, wondering if there's any way to group all the coordinates pin point on a map. Similar to this: I'm running a Dashboard Dataset Rule and using a Map Component within workspaces. The issue is that the location text gets jumbled when zoomed out:            This is the excerpt of the code, but mainly lets it pinpoint the location on the map  Dim pin As New XFMapPinPoint(LCLat, LCLong, MemberInfo.Member.Description, XFIMageFileSourceType.ClientImage, "StatusBlueBall", 0, 0, MemberInfo.Member.Name, XFImageFileSourceType.ClientImage, "StatusGreenCheckMark")                            'MemberInfo.Member.Name    'MemberInfo.Member.Description collection.AddPinPoint(pin)                         End If                     Next           &nb

I’m working on a loop over Entity.children and trying to implement a condition where, if a particular entity x is selected, then entities y and z should be excluded from the loop. I attempted to write an if statement to handle this, but it doesn’t seem to be working as expected. Here's the logic I tried to implement:    

Hi everyone, I have a book having a simple CV with an Excel output. When the book is "processed and open", normally it opens an excel file in the local machine. Is there a way so that the output file is saved as an excel on a shared OS folder? Thank you.Best regards,Carlos 

Hi Team, Please help us if any possible way for below requirement. I have multiple rows and columns. here, If Variance column (column D) has the data then Actual column (B) should be populated for that Entity1 . If Variance(column H) has the No data then all column (F,G,H) should be suppressed for that Entity2, I have tried CV suppression setting but it is suppressing the columns when the entire columns have zero or No data and also tried with "use to Determine Row Suppression" property, but no change on the suppression. Kindly let me know if any other setting needs to apply.  

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

Hi all, is there a way to open the "Workflow Multi-Period Processing" page from a dashboard button?we were able to open the pages for specific time (YYYYMM) and the different steps Import, forms, Adj. But what about the Multi-Period processing which is exeucted at the year level (e.g. 2025)? Which is the Workflow name to use in the Change POV and Workflow button POV Action?here is how we set the button  Can anyone help?Thanks and regardsMassimo

Hi,We are transitioning over to OneStream version 9.0.1. As part of the transition, we are running validations on the data we have copied over from our previous environments. We are running reports like quickviews & XFGETCELLs to retrieve data. However, after clicking on Refresh Sheet/Workbook, we are prompted with the error message: Microsoft excel is waiting for another application to complete an OLE action Does anyone have a solution to this resolve this issue? This is holding us back with our validations, ultimately affecting our go-live date if this issue persists. We would not feel confident going live if this Microsoft Excel error continues to impact our user base from running their reports.  For additional context: Microsoft Excel is 64-bit version Excel Add-in version 9.0.1 is installed.  Tested on multiple reports along with recreating reports Tested with multiple users/devices

Hi  i am trying to fit row in one page for display. now data is shown in different pages