Reporting

Team   Is there a way we can add long text like comments to the cells through Forms?  Am trying to build a cube view with data and comments to it which is visible on view rather than adding it as "note" or "attachments". Please see the sample image below on the requirement.      

Statement: You can do a direct cash flow in OneStream. Question Credit:  Peter Fugere Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week.   * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Is there any way to do a GetDataCell in a Cube View or Quick View where the members are dynamic/based on some criteria?  The formula below doesn't work, but hopefully give you an idea of what I wish did work.   GetDataCell(SUM(E#TopEntityMember.Base.Where(Text5 = 'Germany'))):Name(GermanySum)   I know you can add specific members together in the GetDataCell, but I'd like to be able to have one row that shows the sum, which is based on a property value that can be changed or be able to use it as a member filter and not have to display it in the grid.

Hi, I am building cube views that should be accessible by several users based on the workflow they are affected to.   These cube views are the same, but each workflow has its own entity. Therefore, the same cube view will be available through several workflow, and the entity (or entity selection) should change based on entity affected to each workflow profile.   I'm probably missing something, but the problem is that there are no (known) parameters that would simply give me the list of entities attached to the current workflow profile... what would be the best way to achieve this ?   Regards,

I'm working with a BI Viewer and working out how to sort the dates within the Time data set. Is their an API that allows to call the data adapter used within a dashboard? Currently the dates on the X-Axis are disorganized and are being sorted based on M1x, M2x which causes October (M10) to precede after January (M1). 

I am creating a dashboard that compares two different scenarios (one of which is the prompted scenario). I want the header of the chart to display the description of the member instead of the name (i.e., "Forecast 3+9" instead of "FORECAST_3_9." If I input the prompt name into the description field ("|!Prompt_Scenario!|") it will return the name. Is there any way to update this to populate the description instead?

I am trying to build a dashboard with a button that opens a scenario dimension page so that super users can easily set up and use a gaming hybrid scenarios.  Is there an XFPage option to open a dimension page?

Hello, Backstory: We have some forecast cube views we embed in our Forecast workflows. These cube views also display under the cube view folder. The cube views are set to the workflow POV and I realized this means users can open the cube view in the cube view folder and if their  POV is Actuals, they can then load to Actuals. I want to prevent this.  I updated the cube view folder security to Admins and then no one could access the forms.  Question: Is there a way to remove specific cube views from the cube views folder, but still allow users to access them in a workflow?  Regards, Ronnie

Originally posted by Kris Waggoner I have a cube view that has a nested dimension in the rows.  By default, the nested dimension is collapsed and the user has to expand it.  Is there a way to have the nested dimensions expanded by default?  There is a setting for this in the pivot table in BI Viewer, but I don't see how to do this in cube view

Statement: You can copy and paste dashboard components within a dashboard maintenance unit or to a completely different dashboard maintenance unit Question Credit: Chris Bielinski   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases   Want more Fact or Fiction? We’ll be hosting a LIVE game show at SPLASH San Antonio! You can volunteer to participate or you’re welcome to attend. Secure you spot today by contacting Press@OneStreamSoftware.com. We hope to see you there!

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?