Reporting

Jigsaw, one of the partners in South Africa needs to build an Onion Graph for one of our SA customers. Anyone have an idea how to do this?  

I have a report book I've built that loops thru a dimension and creates a tab for every member in a ud hierarchy. I've set book to label the tabs using the CVUD2 and CVUD2Description.  It works quite well except there are some descriptions that have hyphens in them which don't print out. Is there any way to print the hyphen included in some descriptions?

Hello! I'm looking for a solution to the new Quickview feature of splitting up Excel tables into pages, when the number of rows exceeds a certain number. I'd like to show all information in one page still, if possible.  

Hi all, We have dynamic number of columns in our cube views/reports and it changes the number of pages that the rows go over based on the number of columns and fitting the the width of the pages.  Is there a way to make sure that the rows are set to a set number of pages high? Thanks

Hi, When creating a simple cube view using both calculated rows and columns, the intersection of these two formulas doesn't display correctly. Is there a way around this? See attached photo where Variance and Variance % columns both show the value of the first cell instead of the difference and difference percentage as they do in the other rows.

Does the BI Viewer support ranking?

Originally posted by Cosimo Palmisano3/16/2020 When I then try to use this parameter in an XFBR call, the NameValuePair dictionary doesn't contain the full string value and it only contains the 1. Everything after the 1st comma gets truncated. Is there a workaround to this issue?

Originally posted by Ashok AmreshI am trying get rolling average of an Account (i.e. average of prior 8 OR 12 quarters  ). i am New to Onestream and really finding hard to find function etc. any help is appreciated.

Originally posted by Marouane TalbiHow to write a UD conditional rule that would map the UD based on the target account : 1. For target accounts under the EBIT hierarchy, the UD should be mapped to "NO_UD" 2. For the remaining accounts, the target UD should be mapped according to the mapping of the transformation rule table.

Originally posted by Charlotte Mikes i created a report from xfgetcells. is that uploadable into a new cubeview?

Originally posted by Carien ClassensOur client has a requirement to manage ownership data on a monthly basis in multiple structures. Is there a solution to load ownership data with the use of excel? Something similar to: (XFGetRelationshipProperty("Entity";$A12;$B12;"PercentConsolidation";"Actual";C$2) Thank you

Originally posted by Darryl GerrowWe have a number of cube views that we automate delivery to Excel using Books, but would like to know if there is a way to set the Excel Freeze Pane settings in the cube view itself so that users don't have to set it when they receive the Book?

Originally posted by Felipe Alcorta We have quite a bit of entities across many currencies.  Is there a way to incorporate into a CV the associated currency (found in the currency setting of the member props) for a specific entity?

Originally posted by Bob Nelson When using an If statement inside of a loop the reference guide only shows example of = and <>.  Are there other conditional statements that are supported by an If statement in report books.  Specifically I am looking for "contains" a certain text string or "does not contain" a certain text string.  I'm also open to using a Right command to parse the Loop variable as in if Right(loop variable, 4) <> "_USD".     Thank you,

Originally posted by Armando OrtizHi community, Does anyone knows if there is a limit on the number of lines that can be submitted to OS from an Excel sheet and what is that limit? Thanks in advance for your valuable help.

Originally posted by Kimberly Reasonerwe have several employees who receive inventory reports with XFGET Cells, that do not have a license.  When they open of course they are getting #Value.     Is there a setting that can be used so that everyone can see the data, without wasting time saving it off line for several people.  thanks,   

Originally posted by Lawrence ManekinHi, Working on a POC for a client.  To get data in quickly, I uploaded an Excel document so I can run a pivot off of it.  The Excel is in the public folder. I'm using this syntax {Application}{Documents/Public/GLtransrevfields.xlsx}{Sheet1}{MyRange}{True}{True}{}   but it keeps telling me that it's invalid.  I have tried calling out the specific application name as well, but no luck. Any suggestions would be appreciated. -Larry

Originally posted by Retha DuPlessis Can you please confirm if there is a report that list all the users?

Originally posted by Bart DeHaas I have a cubeview that is run in a reporting book. I have created a Cubeviewer extender rule to change some formatting. For example, to put a different logo on the report based on the entity. It works fine. On the report there is also a header line and I can adjust the header line height by the following code  ElseIf uiItem.UIItemType = XFReportUIItemType.PageHeaderLabelBar ThenuiItem.Height = 1 I also wanted to change the color to the company color. But it does not do it, I used uiItem.Bordercolor. But it keeps it black (See below picture, what I am looking for). Does somebody know how to do this?

Originally posted by Cheryl NastaWhen multiple QuickView files are open, but only one is connected to the Add-In, users have experienced long refresh times when refreshing the one sheet in the active file. Is this common and is the best practice to only have one file open at a time?  What contributes to the latency in refresh if the other files are not connected?

Originally posted by Matt Brown Is it possible to add number formatting to data in cubeviews depending on the scaling selected from a delimited list? I've tried adding the number formatting to the delimited list e.g. "3, NumberFormat = 0.00" but the system won't recognize the exact formatting. Although it does recognize other formatting such as Bold or Italics.

Originally posted by Nick Bolinger10/16/2019 Customer has users who will only be working with Quick Views in Spreadsheet and not the Excel add-in. Can they set custom cell styling like they can in Excel? In 5.1 and 5.2 there's the same cell styles toolbar and it says you can set your own... but where?

Originally posted by Rahat Fatma Hi,  I am using bound list parameters which query the table to bring the year, but default value remains blank even though I have set it to be a particular year. Is there was way to make the default value for bound parameters to actually work    

Originally posted by Christopher AyotteI'm building a report in studio and have a need to create a parameter that will capture the User Name of who is running the report. I know I can do this IN the report using Page Info control box. But I need to capture it as a parameter so that I can use the parameter as means to filter a SQL dataset query.   I've done this many time using SSRS, but I can't seem to find a way to do this in OneStream Studio Designer. Any suggestions?

Originally posted by Kimberly Reasoner We have SG&A monthly Performance Reports set up in Books, All emails and packages are set up .  opening the PDFs under documents / Books they look great.   When I run the package and email the group of PDF's I have a distorted document and all you see is the LOGO on the report.  Is this a setting in OS somewhere.