Reporting

Hi All, I need to share few specified columns  from one Cube View to another, Can anyone suggest how to use specified  columns in Cube Views.     Thanks in Advance.

When I develop cube views, is it possible to have the description in the header for the data in the rows, for instance first column might be Account, second column Customer.  When I extract the cube view the header for these is blank and I have to manually insert a description to the dimension is relating.  Same issue occurs with quickviews.   Any solutions

Hello.  I have a user who is attempting to refresh his excel workbook using the Refresh Workbook button.  The file contains multiple tabs with XFGETs only.  He is returning the following error message.  I can re-create the error on my end, but the refresh workbook also appears to work intermittently.Has anyone come across this error before and know the cause/remedy? 

Hello all !I come to you about quickviews which crashed when we tried to open them.We built lot of quickviews for the top-reporting or analysis of figures. We store them on the server company and when we try to reopen them to update, all formulas crash (hsget... hsset... )Did you already see a similar case ? Did you find a solution ?thank you all,VN

A#Cash.TreeDescendantsInclusive.Where(Text8 = L1).I have used the above formula to display only level1 members of one account but now I want to like to display level1 members along with the parent members of L1.Help me out in reframing the above formula.Thank you.

I have a cube view that displays values that are entered monthly. For the months that haven't had any data entered yet, it automatically fills in a 0 in a greyed-out format. Similarly, if I display this same row in a YTD view, it shows the YTD value in the months that have not been entered in yet. My customer would prefer these cells display no value. I cannot find any setting or formatting that will display it that way.I've tried changing the number format to empty string ("") based on IsNoData or IsDerived but that has not yielded the desired result.  

Hello; Im crating a cube view with 2 rows (maybe more) that one of them is a result of a complex function: "A#INCOME_STATEMENT.Base.Where(Text1 Startswith On-Campus)" and shows several rows qualified as Text1, now I want to sum those Accounts but don't like to use each Account; it could be possible to use a function in a 2nd row like this: GetDataCell(A#INCOME_STATEMENT.Base.Where(Text1 Startswith On-Campus))::Name(On-Campus) is that possible?   Thanks in advanceand best Regards. Mario GV

How to customize the OneStream Excel Addin Ribbon.     In Excel, go to File > Options Select Customize Ribbon Select Main Select the OneStream Tab on the left – that is the source of all the buttons Select the Onestream Ribbon on the right – that is your target customization Move the buttons you need from left to right. You can create groups for your menu too.   If you want to separate the Save and Refresh, you first need to Remove it and then recreate it. Like shown in the screen above. You can then create a ribbon like below where I separated the Data Refresh vs Data Save. Unfortunately each user has to do that.  

Hi,I created a cube view group in the in the application and it works fine. I placed it into a cube view profile so I could then pull it into an excel workbook via the onestream add-in. This also worked fine.However, now when I go to refresh the data, as this will be a monthly report, the cubeview is not connected and everything is essentially hardcoded. What changed to cause it to go from a living report to not connecting to the data base? 

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,

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

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.

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

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.

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!      

I am trying to create a Cube view report that should show English Description of Entity members istead of default Description. Is there any XF member property function to do the same or any other solution?   Thanks, Neha