Reporting

We are using XFString to present text on Cube Views in different languages. It is documented here: https://femsadev.onestreamcloud.com/OneStreamWeb/Help/Content/Design%20and%20Reference/Presentation/Reference%20Alias%20via%20XFString.htmI don't want to prompt the user for their language - is there a way to use the user's culture code and suppress the prompt?Thanks

I have created a Cube View showing Entity, Account and IC members in rows. Under the Data section, I have set the "Use Suppression Settings On Parent Rows" to True and it is working fine. The entity name will not show for every account/IC. However, when I export it to Excel, the entity name will repeat on every account lines.  Is there a way to  get the "Suppress Parent Row" function to work also when exporting to Excel?  Thanks

Hello, When using the Book functionalities, one could loop parameters and change variables. That being said, I am looping a UD1 parameter (parameter name : MY_UD1), that is used by an XFCELL function in another parameter (parameter name : MY_UD1_VALUE). My question is : do I need to use a "change variable" in order to change the value in MY_UD1_VALUE (which is calculated by an XFCELL) ? Here's what I have currently done but is not giving an output :   Regards,

SOURCE: ONESTREAM CHAMPIONS Hi Team, Greetings for the Day. We have a requirement to download the registers data into an Excel Book with all Account as different Sheets and that too from within one stream. One STream table view is the best option provided to fetch the data from one stream. The question here is we have 100+ Accounts in there, which we need to bring in the tabs, and to achieve that we need to add all tabs 1 by 1 under Spread Sheet - Table view (Refer to attached screenshot). Is there any automatic way to append the Table view with all accounts tab names using some macro or inbuild One Stream Functions?     image.png1114×546 39.1 KB    

I noticed that the application tables have an odd time format in column called timeid   is there another table that houses the times in 2023M3 format or is there a way to convert this column easily when using it in a SQL data adaptor?

Hello!  My brain is mush so I'm posting this for the bigger audience to please help me brainstorm or answer me directly if it's possible 🙂  Can I use a middle digit on an account name in a member filter? For example, the 4th digit of our cost centers represents location but I'm wondering if I can actually do anything with that. I want to list all CCs with a 4 in that spot but can't quite figure out a good member filter that works. I tried ? like the placeholders in transformation rules and * to no avail. Here's a sample member filter for reference (I'm using it in a QV): A#RD_tot.base.where(name starts with 'CC_SAP_***4') Any thoughts? I could add that fourth digit in a text field or otherwise create an alternate hierarchy but I'm wondering if there's a way to utilize it as is. Any thoughts are welcome!  Thanks & happy Friday! 

I am looking to get more information on how the OneStream Parameter Dialog Box figures out what parameters to present for the end user when they run cube view report. Is there a way to leverage that same functionality to create a delimited listing of the user parameter inputs that can be displayed on the report header or footer?   I know that you can simply add all the parameter references into the header or footer but I am looking for something that would dynamically update to account for new parameters as they are added into a cubeview report.

In BI Viewer,  Is it possible to drilldown to the base level members using Pivot Grid within the same dimension. Like if I pull Entity dimension in a row then is there any way to drill down to the base level members ?Also, Can filters list out the members in a hierarchical /tree format?  Generally combo box/list/tree map displays it in a flat structure so is there any alternative way to achieve it ?

We have a user that has the Solver Add-in installed in Excel.  He has to disable the add-in when he wants to use OneStream.  Has anyone else had a similar issue and found a different resolution other than enable and disable the solver add-in?

Hello folks, I'm trying to add a regression line on a scattered chart in Bi Viewer. I'm trying to use Calculated fields but when I arrive to the point of calculating the y in the equation I get an error as a "summary expression" is expected: [intercept] + [slope] * [V4] If I surround V4 with Max or Min it's accepted but no line is plotted on the chart.  Does anyone have a clue if it's possible to add a regression line on a chart?Many thanks  

Hi,   Anyone knows what the LoadDashboardReasonType or LoadDashboardActionType after the user selects the parameters for the prompt upon opening the dashboard?   I want to put a code after the user selects values for the dashboard parameters (see below) and click OK on the prompt.   Thanks!

Hi Experts,  Kindly advise if there any possibility to import CSV file into Dashboard.   Thanks, Naresh

We're trying to export a Form into Excel and we are receiving the following error.  Has anyone had this error when trying to export a form into Excel?   Thanks

Hello, I have a cube view that is driven by the workflow. In this cubeview the user sees base level entities as columns . This is achieved by using the synthax E#Root.WFProfileEntities. At the same time I would like to add a column that totals those base level entities to see what the totals are at the parent level. Does anyone know what the syntax is? Thank you in advance for your time.

Is there a way to make dashboards stop refreshing every time you navigate to another tab in OneStream and then come back to the dashboard?

Looking for some guidance with using the attribute field.  I think I found a limitation with using it, but I am hoping it’s a simple fix and not a legitamate limiation.  Scenario:  creating a cube view where the first few rows are drive by account,  the next several lines are driven by UD4 and Account.  UD1 (departments) are driving the columns, except for when it comes to the rows that are driven by the UD4.  At this point we need to use the UD4, Text 5.  To do this, we created UD8 members that pull in attributes based on the UD4, text 5. The cube view: Rows are the UD4 and accounts.  The columns are UD1 but we have row overrides for the rows that need to be driven by the UD4 text field.  The row override pulls in the UD8.  This works for the first few UD4 attributes being pulled.  Then it just stops after roughly the 4th parent member under UD4. I can force it to work but adding in a column override (I don’t know why this wo

What is the difference between 'drill down' and 'drill back' functionality?  is it just the matter of different names refering to the same function?  thank you.

Hello,  We are using the Excel - Addin and made some templates to work better with OneStream. It worked great, however we found that the users sometimes have the error of clicking "Submit Workbook" instead of "Refresh Sheet".  We tried to customize the ribbon to separate them but it is not possible because the Refresh and Submit button are in the same tab ("Data"). Is there a way to modify it? Is it a common mistake? Thanks for the attention and best regards,  

I am trying to use the the GetDataCell function for both Rows and Column and the math is not working.  For the row, I am using GetDataCell to sum several G/L accounts.  For the columns I have Actual(C1), Budget (C3)and the 3rd is a GetDataCell (C3) to take the difference between Actual and Budget.  I am not getting any errors but the Variance Column (C3) is returning the value in the first column.  Its as if the second column has a zero loaded.

Hello, For a project management perspective, I would like to use the Gantt component in a dashboard. The documentation only explain that we should use XFGanttTaskCollection for that. Are there any implementation that have been using this component, any documentation to share about it ?   Regards,

Is there any way to create a Cube View or Dashboard which has the ability to drill through without logging into the Application? The non authenticated users should be able to access the artifact and view the data. Any help would be appreciated. Thanks

I am trying to get the description for prior year in my Excel header for cube views. There is a substitution variable for current year but nothing for prior year. Anyone have any suggestions? Instead of the format 2023M3, I want the header to bring in the description that says March 2023. Below is my current year variable.

I created a combo box in a dashboard and the combo box is associated with a parameter that provides a considerable list of elements for selection. The user would like to have a button to clear all the selected elements as needed. Would you know of any alternative to clear the selected elements from the combo box? Thank you for all the help.  

Hi,Is there a way to show a prompt for a dashboard ONLY during the first time the user opens the particular dashboard? User will provide some POV and this should be saved to be used by the dashboard everytime the user opens it. I am thinking of creating a custom table on the database that gets populated with the username, and the POVs that the user chose.  It would be best if I can make use of the dashboard parameters prompt, and just create a rule to (1) check if the user has an entry on the custom table, (2) do not show the parameters prompt if the user has entry. Thanks! Thanks!

Hello, I hope someone can help me out with the following issue.   We are trying to add the Report Header/Title to a report, but we would like to have it dynamically adjust to the width of the CV or Report itself (so also fill the yellow highlighted space). When I try "-1" (how you would do it in the CV settings) it becomes very small.   Furthermore, I would also like to remove the light blue line under the header (or make it the same color, dark blue). I tried to adjust this in 'Application | Application Properties | Standard Reports' but with no luck.   Thanks in advance for your help!