Reporting

Hello, I am trying to insert an excel file (tab) into a book that will export to excel. The purpose of the file is to insert a tab as a separator between report tabs so that the name of this excel tab denotes the type of reports that come next. I am having trouble inserting an excel file so I have created a work around by creating a blank cube view and giving it the output name that I want it to have and then brining that "report" into the book, but I don't feel like I should have to do that. If anyone has any knowledge on adding an excel file to a book, that would be great. Thanks!

Hi everyone. I’m working on a cube view, and I have a variable that handles the scenario, and I want another column to have the PY of that selected scenario, so if you could help me know how this can be done. Example for the scenario to modify.  

Dear all, I'd like to know whether you've been faced to this issue. When defining the CV there are several nested dimensions in the row definition and I'd like to show it so that the header is repeated to avoid empty headers on the rows (see image below). Do you know how it could be possible to edit it? Thank you    

Hi there, I have the same issue as that of the link below but I'm looking for a solution without using a DynamicCalc nor GetDataCell because the parameter "Allow sparse row suppression" is set to True. Does anyone have an idea about how to proceed? Regards How to bring attribute "Text" fields value into a Cube View - OneStream Community (onestreamsoftware.com)   Edit: When using a DynamicCalc member and "Allow sparse row suppression" = True, it entails an error (see following image)  

Hi, I am wanting to show the scale of dollars in a report, I have the parameter |!Divisor!| which has display items as Whole Numbers, Thousands, Millions, and Billions. When I use that parameter in a report instead of showing the display items it shows the value items which are 0, 3, 6, and 9.   Thank you, Jeremy Morgan    

When refreshing a quick view after having changed the PoV, any formula in the row that is refreshed will be cleared.Is it possible to retain the formula ? Example: A1 Formula B1 PoV C1 PoV When changing B1 and C1, and refreshing A1 will be cleared. Thanks!

Hi All, I am trying to add two UD2 dimension members in the Cube view member filter and obviously , its not allowing me to enter them. I went through the approach of creating a dimension in UD8 and then copying all the data from the UD2 dimension to UD8 dimension in order to show the two columns. However, it is not working for me. I used the following code in dynamic calc formula for UD8: B2C_PGC_Provider so that I can reference it to UD2 ( all member dimensions and included data):  Dim U2Filter As List(Of Member)=api.Members.GetBaseMembers(api.Pov.UD2Dim.DimPk, api.Members.GetMemberId(dimtype.UD2.Id, "Programs_Provider")) For Each memberObj In U2FilterBRApi.ErrorLog.LogMessage(si, memberObj.Name)Next. Please let me know what is wrong and how this can be resolved.

Hi,My company has entities 2,5,8,N,U,O,X,Z.When I prepare the loop and if statement in the books;not sure why I could only use the if statement for N/U/O/X/Z but not 2/5/8.I have tried different settings but still not working.Can you share with me how should I write the code if the entity name is purely a number?Thank you.(|Loop1Variable| =[2]) Or (|Loop1Variable| =[U])Or (|Loop1Variable| =[O])Or (|Loop1Variable| =[X])Or (|Loop1Variable| =[5])Or (|Loop1Variable| =[8])(|Loop1Variable| =2) Or (|Loop1Variable| =[U])Or (|Loop1Variable| =[O])Or (|Loop1Variable| =[X])Or (|Loop1Variable| =5)Or (|Loop1Variable| =8)  

I had one of our head budgeting people bring me a question the other day and I feel awkward that I didn't know how to answer him.He loaded data. He validated his 100k. The following day, he sees it's 75k. Neither of us has any idea how to tell who entered the data.He emailed the group of users who have security access to that data and one user confirmed that she had in fact submitted the updated number but... we did have to ask.Have I just lucked out and gone years without needing to do this so have become blind to a whole auditing feature I didn't know was there all along? Or, is it that recording per-cell auditing for every single edit is just impractical and there really is no way for us to do this? I don't see questions about it in Community. I don't even see any particularly relevant products/labels for this question! So, I'm at a bit of a loss. What don't I know that I don't know?Edit: I do see a mention in the Foundation Handbook that data auditing is there and can be used to fi

Hi, I know I could create a custom member list of an XFBR rule for the scope, but is there an easier option to get the cube view rows ordered alphabetically based on member names? Eg. currently, if I have E#Ent1000.Children in row, the cube view is by default showing the members children of Ent1000 in the order with which they appear in the Entity hierarchy. I would like them to be ordered based on their name. Thank you

Hi everyone. I have the issue that when clicking on a row in an SQL table editor, it doesn't open the view with the correct value, but instead, it displays the value from another table. I have 4 tables that use the same view to edit information, and each one has a different bound parameter, and that value is assigned in the SQL table editor section. Example: As you can see, it's set up in the same way, but where the DItemID value is assigned is where I'm having issues. ¿Any solution to this?  

I am building a donut chart in bi viewer. I am using my Geography UD2 as the arguments. My member names are long: 'United States Region', 'Asia Region', etc. I would like to rename them visually for this report. Is this possible? I cannot rename them in my dimension library, and renaming them in the cube view with the :name() member expansion does nothing. Thank you in advance.

I want to navigate to a workflow from a dashboard button and thougt I found my answer in selecting the open page action and using "XFPage=Workflow".  This works and when i click the button it takes me to the workflow page using my current WF settings.  I was hoping to get more granular and go to a specific workflow and found in the Design and Reference Guide this example which I was hoping to explore: "XFPage=Workflow:NameofWorkflow"  Has anyone worked with this succesfully as I just cant seem to get it to work and not sure if there is some syntax nuance I am missing.  Using GolfStream as an example I am trying "XFPage=Workflow:Houston.Journals" as an example but nothing.  It stops going to workflow at all.  

I need help with keeping some CV formatting when exporting to Excel. The current CV I've built works just fine, but when the client exports to Excel, some of the percent values are truncated to the whole number and the '%' is removed. EX: OneStream CV shows a cell value as "35.6%", but Excel shows "35" I've tried to mess around with the Excel formatting in the designer tab for CV's, but I cannot get the setting to carry over during export. Any advice would be much appreciated! 

I'm looking to add a formula that takes an account and subtracts the difference between two scenarios. So, something like this: GetDataCell(A#ProductionTCFacSTd:S#Target_FY24) - GetDataCell(A#ProductionTCFacSTd:S#Target_FY24_SC). Can you please help see what I need to do to make this work in my cube view?

Good Morning!  Does anyone know how to build upon the set up variables in OneStream?   For Example: |CVYearNext| - This gives me the following year of the CV.  What if I want the following Year and the next one? Does anyone know how to pull that data?  So, if the CV is 2022 this variable will give the following year 2023, if I need 2024 and 2025 and so on.  How do you expand on this variable?

Hi Team, I am trying to create an Input CubeView with an expansion based on whether the 'Allow Input' setting is set to True for our UD5 Dimension Members.  To give a little bit of background, we are using the UD5 dimension for our Customer Codes. The setup is based on the different regions (which have their own cube) and the basis of the structure is captured under 'Customers'. The regions can have the flexibility to add more detail by adding members under this basis structure in their dimension: We have an Input CubeView that is currently set to .Base (from the dimension that belongs to the Cube we are inputting for). However, a member might be a Base member in one dimensions (however, we don't want and cannot input here), but a parent member in the other. That is why I am trying to create an expansion based on the Allow Input setting. However, when I try "Member.Base.Where(AllowInput=True) it is unfortunately not working.  Does anyone have any idea how we can solve this (

In OneStream cube views the features to either "Download Results And Save As A CSV File" or to "Download Results And Open" exists. Both features create CSV files with a comma as a delimiter. This is very annoying because when a comma is also used as thousands delimiter, so the CSV File does not get seperated in Excel columns correcty.Is there the possibility to change the delimiter fpor CSV files? RegardsMartin Gebhartl

Good morning, I am writing to ask if it is possible to prevent the graph labels from overlapping the data. The graph I am using is an overlapping column chart with very small percentages. This causes the data labels to overlap, making it difficult to read the chart. I have built this chart using a Chart (Advanced) component invoked in a dashboard; i have also tried to build this chart in a report component using the report designer, but i realized that i have the same problem with the labels. is it possible to control the position of those labels? Thank you    

Hi, I have a Bound List parameter with Command type SQL. 1. I have first tried to use an XFBR rule within the string of the Like condition. This works fine. 2. I have then tried to use the XFBR to return the full condition "cvi.Name Like..." (see below), but it looks like the XBFR is passed as a String to the SQL statement in this case, without processing the XFBR and returning its output (see error in the last picture). How do I force OneStream to process the XFBR before passing it to the SQL query? What is the right syntax? Note: things are commented out in the code below, but I have of course uncommented the lines as needed during the testing. Thank you

Hi all, I'm struggling to understand how the setting "Use suppression settings on parent rows" in cube views works.  I have this simple CV showing a list of accounts in the rows (1C205000 and descendants) and time in the columns: in the rows "Advanced" section, I set the following: my expectation here is to have all invalid, nodata or zero rows suppressed, except for the parent row (which I expect to be the row corresponding to the account 1C205000). However, when I launch it, also the parent row gets suppressed and I end up not seeing anything.  What am I doing wrong? Thanks in advance for any help!

Good evening, I would like to ask if it is possible to change the scaling from ##,###,###.## to ##.## in the Report Designer feature of the Report component. The data is read from a cube view with a scaling already entered. However, because I use an MD cube view in the data adapter, the scaling set is lost. Currently, by changing the setting in the Text Pattern, the desired result does not occur; I wonder if it is possible to change the Text Pattern so that it returns the desired result. Alternatively, if there is another way to solve this problem. Thank you        

Hi all,Trying to figure out how to position a component in a particular column (or give the appearance of that)It's a grid type and has 5 columns, 2 rows and 6 components (previously 6 columns, 1 row and 6 components but it's too wide for the screen that way) My hope was to put the 6th component on the far right of the dashboard (or at least to the right of the splitter) in a 2nd row.  There's no way in a Grid type dashboard that I can see where you can force a component to use a particular column, or is there and I just missed it? I've tried adding big margins to force it right but that doesn't work either.I'm thinking either this is not possible in a single dashboard and I will have to create a new 1 row dashboard to put that label component in.  But I would sure love to hear any ideas.  It feels like this should definitely be doable but I'm stumped.   I'm adding a diagram for better understanding of what I'm trying to accomplish Much thanks in advance for an

Is it possible to assign a page break in a cube view? We have a report when exported in PDF, the header of a section is appearing on page 1, but the lines under that section are pushed to page 2.  

Hi Can anyone tell me the name of the Market Place solution that contains a list of packaged UD8 Rep_Reporting dynamic Calcs?  Thanks Guy