Reporting

Source:   Migrated from Champions Hi! This is my first time posting but we’ve had multiple users trying to copy tabs that have quickviews to another file while keeping the connection instead of rebuilding. Is this possible? Thanks!

Source:   Migrated from Champions Hi, is there a way to create ranking within cube view? for e.g. Ranking Top 20 branches based on branch Profit. I think it would involve writing a BR but not sure. Any ideas will be greatly appreciated. Thanks

Source:   Migrated from Champions How can I create a cover page in an XLbook (first tab in the excel book)? I have tried uploading .xlsx and .xfdoc.xlsx single tab excel files into File Explorer under Application Database and System Database. The cover pages don’t appear when the XLbook renders. This does work for PDFbooks.

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 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.

Originally posted by Paul BerryI'm trying to run some code when a user saves a table using the SQL table editor.   However I'm not able to see anything happen. My setup is as shown in the attached.    

Originally posted by Mark Houghton Hi, I am trying to build a cubeview which will have one row of data which is the movement between two parameter driven periods. At present I have fixed it for testing purposes to be S#Actual:WF and S#Actual:T#WFPRIOR12. The syntax for the 'movement' I have used is GetDataCell(BWDiff(S#Actual,S#Actual:T#WFPRIOR12)):Name("B/W Diff on Yr values") Most of my columns reference single account codes. These ALL give me the correct result. However, where I have used a formula to calculate the sum of a range of account codes then it will not return the movement value. If I make it a 3 row cubeview, one each for current yr, prior yr and movement, then my values for the 'sum of range of accounts' is returning the correct values for current and prior year but returns blank for the movement. What is wrong with my syntax ? I tried switching rows and columns but that did not give me a different result either.  Can someone suggest a better method OTHER than

Originally posted by Leyton de LangeHi All, I am using view member "VarianceExplanation" in a cube view for comments, and I have a question around how many characters can be used in the cell and also if there is a way to wrap text.  The plan is to use this cube view in a dashboard. Thanks in advance          

Originally posted by Jeff BorycI have cube views in an Excel document. When I am trying to create formulas to certain sections of the spreadsheet, it references table names. This makes it extremely cumbersome to build anything out because each cell needs to be setup individually. Turning off Excel references to tables does not fix the issue. I can delete the name references, but that makes the cube view un-refreshable. This pretty much makes cube views in Excel a non usable function. How do I fix this???