Reporting

Has anyone come across a simple way to incorporate user input values with a Quick View?  Our users very much prefer the Excel Add-In with Quick Views and tend not to like the predefined nature of cube views.  This has been one of the main sources of frustration expressed since we switched from Hyperion to OneStream about 1.5 years ago. Here is a simple example with the Time dimension of what was frequently done with Hyperion Smart View. An Excel file has 10 tabs, one named Input.  On the Input tab the user enters a Time member in a cell.  The other nine tabs link to that Time cell.  With Smart View the user only had to change one cell no matter how many other tabs there were.  With Quick Views the user has to change the T# value in every Quick View in the file. I know this is a simple example, and if it was always for month-end, something like T#Global could be used, but they wish to be able to set the values for any number of dimensions and only have to s

Hi All,   Thanks in advance for the help on this. I am looking for configure the Report Title in a cube to to be aligned left rather than center. In the screenshot below I would like "Consolidated Balance Sheet" to be aligned with Subtitle 1: Left - "Test".    Here is the current syntax I have to move this but it looks like it moving the title left on center rather than aligning it left.   'Move page header left If uiItem.UIItemType = XFReportUIItemType.PageHeaderLabelTitle uiItem.Visible = True uiItem.Left = args.Report.CurrentPageInfo.LeftPosition End If   This formula is within the Custom Report Task rules. Cheers, Amar

I may have found a bug in OneStream. I build a small CV - 10 by 3 columns with a row that has column override calling a small Dynamic Calc formula. I'm getting this error message, in System> Error log,  when I run a cubeview. Has anyone seen this error message before.. If you can give me a clue to narrow down, that's fine as well.  Unable to initialize XF App Server Metrics Thread on application server APP01. Access to the registry key 'Global' is denied. ---------------------------------------- Description: Unable to initialize XF App Server Metrics Thread on application server APP01. Error Time: 4/12/2022 4:57:02 PM Error Level: Error Tier: AppServer App Server: APP01 App Server XF Version: 6.1.1.11424 App Server OS Version: Microsoft Windows Server 2012 R2 Standard (6.3.9600.0) Session ID: 00000000-0000-0000-0000-000000000000 Error Log ID: 7053dc3d-9ea3-4da1-b144-d91a4bc70328 Total Memory: 34,359,201,792 (32.00 GB) Memory In Use: 2,713,128,960 (2.53 GB) Private Memory I

We are trying to calculate the variance between two Scenarios using an UD8 member. In Essbase, the calculation below works just fine, but in OneS it returns an error. Any improvement to the formula is appreciated.  

Hi I'm struggling to add lines to show Gross Margin % ((Total income less product related costs)/Total income)*100), overhead as a percentage of total income etc. I've tried using Getdatacell referencing the rows but clearly am doing something incorrectly since I get red cells. The formula I have used is GetDataCell(((CVR(Rev_Total)-CVR(RevRelCosts_Total))/CVR(Rev_Total))*100):Name(Gross Margin) where Rev_Total is A#[Total Income] and RevRelCosts_Total is A#[Total Revenue Related Costs]. I'd be grateful for any advice. Thanks

Hi All,   Does anyone know of a formatting string that will allow us to edit the textcolor of writeable cells in a cube view? I could split out the columns so that we have locked and writeable cells seperately and then we edit the textcolor of all the rows, but what I am looking for is almost a "WriteableBackGroundColor = White", but for TextColor.   I tried using "WriteableTextColor" (a string I tried to derive), but it unfortunately doesn't do anything

Hello - Is there a way to have a Ud8 dynamic calc sum up certain entities based on a text field? I am trying to tag a text field on certain entities and have a dynamic calc aggregate the entities based on what that text is. Example:  entity 1 - text 1 "abc" entity 2 - text 1 "abc" entity 3 - text 1 "def" I want the value of entity 1 + entity 2   Thank you!  

Hi,Does anybody know what is the "ColumnDisplayType" parameter under the Column Format, part of the SQL Table Editor ?I am keen to know how to use it, as I can't find any information on this.Screenshot of the mentioned field below : Regards, 

Hello,I would like to know if it is possible to format only one word or part of a word in a dashboard label :- How can we make only one word in bold in a label, and not just the complete sentence ?- Could we use conditional formating in order to format only a specific word (for instance, a user login) ? Many thanks,

Wondering if anyone has encountered the issue? It's a simple PDF report book with straight forward column set, but there are slight misalignments between numbers. Ideally, looking for right side justification. Thank you

Hi All,   I'm trying to display prior 6 months in my cube view. For e.g. if my WF time is 2021, I want the CV to show last six months in 2020 (Jun - Dec) and so on. I tried using half year member filter, but it didn't work as it should. Any suggestions will be appreciated.   Thank you, Mustafa

I've been creating cube views and have sometimes found that I may forget to update a row that is part of a reporting segment. This results in the sum of the rows not equaling the total row for the reporting segment. Does anyone have any suggestions on how I can create a row in the cube view that validates that the rows of a reporting segment equal the total row? I would want this row to be invisible and to have a condition that it would only display if there was a variance. I'd be looking for something like this: Row 1: $100 Row 2: $100 Row 3: Total = 200 Variance = 0  

Is it possible to use data from attributes and attribute values in a cube view row or column filter?

Is there a way to use functions as parameters in an XFGetCell formula? I want to retrieve values for the previous month to compare to the actual month.  It would be nice to use something like T#MonthPrior1([actual month]) instead of using some excel functionality to calculate 2022M1 and use that.     

How do I set up drill down for relational sources in BI Viewer?

Good morning All, How do I make build this dynamic calculation for my Monthly Rate KPI CV?  It takes the new month and divides it by the previous trailing month (e.g. Jan-21/Dec-20, Feb-21/Jan-21....)   Here is the code I wrote: Dim RentalRevenue As Decimal = api.Data.GetDataCell("A#NetIncome:U4#[Rental Revenue]").CellAmount Dim RentalRevenueTrailing1Mo As Decimal = api.Data.GetDataCell("A#NetIncome:U4#[Rental Revenue].Prior1").CellAmount Return RentalRevenue/RentalRevenueTrailing1Mo   Any ideas will be appreciated. Thank you.   Best, Mustafa A  

Hi, I am working on a huge report (via Cubeview) with over 3 million rows with data, and i am unable to export to Excel nor PDF. Error message siad that the maximum row allowed is 1 million rows. Does anybody have an idea to increase the number of rows please? Thank you very much Khanh  

Hi All, How do I make my Cube View display prior2 year (2020), but only the last six months. Any suggestions will be appreciated. Thank you!  

How do I make the entity column to align left? Excel has it's own formatting, but it changes back every time I refresh my workbook.  I'm using an excel-add-in.  Wondering if there is any alignment setting, that could be changed in OneStream.   Any ideas? Thank you!

Hi, We have built a cubeview in OneStream. Now we are having a requirement to get input/comment from user and store it back in OneStream. Is there any KB article or something to refer? Please suggest how to achieve this.   Thanks  & Regards, Madesh K

Hi, I have two question in one:1. I'm trying to add a variance column in a Pivot in BI Viewer for amounts that are split by 2 scenario's, actuals and budget. What is the most practical way to do this? I thought I would add a variance in my cube view used in the cube view md adapter but this is not picked up by BI Viewer.2. Can I sort this variance column by the amount value?

There is a new column-store storage engine for reporting out of Onestream called "Analytic Blend". I have been examining the related documentation, and hoping to find an API that would allow this engine to return data for ad-hoc queries. We have custom processes that require CPM data from onestream. These processes would greatly benefit from the ability to retrieve query results from Analytic Blend.  Is there any technical documentation that would help software developers to interact with that column-store data? I have the "BI Blend Design and Reference Guide" for XF 6.3.0, but no other resources beyond that.   That document primarily describes how to prepare the Blend output database. But it doesn't describe how client applications might use the results. Can I assume this is because the because the database is standard Microsoft technology, (ie. that it only requires standard SQL knowledge/skills)? Can I assume that querying data from this Blend database would be fully suppo

Hi, in the getting started with BI viewer I see they make use of a date field, which enables you to drill down to quarters/months etc. How do you create such a field (I guess I have to something with the time dimension which contains my years and months). I'm struggling with finding an expression that works...

Hi everyone, Quick question re Dashboards. When you use a parameter in a Cube View there is an option to display the Member Filter using a "Member Dialog" Parameter Type.  This shows you the results in a hierarchy that can be expanded or collapsed.   When building an interactive dashboard I need to present the user with a large number of members to select from.  The Combo Box option isn't particularly easy to browse through as it simply lists the members (albeit this can be indented with a BR to imply the hierarchichal relationships).  Is there a way of replicating the Member Dialog Parameter Type in a Dashboard component? Regards,Lee    

I am building a cube view with two rows and 12 columns. Assume POV=2021M12:   The first row is A#Sales and in the second row I want the variance of the sales from row one this month minus the sales last month. (Think POV minus POVPrior1)   In the Column I have one Column with T#POV.AllPriorInYear.   The problem is that the formula in my month over month isn't smart enough to populate 12 cells of variances.    I know I could do 12 separate columns and use CVC, but that isn't a great option to me for other reasons. Anyone have any ideas on how to do this?