Reporting

Hello, Is there a way to aggregate the result of an expansion within a member filter?  For example, I have multiple entities that are Australian.  I would like to aggregate the balances of all of those entities into a single row.  I'm using the attached syntax which produces the entire list, but I would like all the results to be aggregated into one line item without all the underlying detail.  Does anyone know of a solution? Thanks, Sean

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 Fairly new to OS and i am looking for a solution/workaround on MemberName and Description in POV. To explain further, in Quick View when any dimensions is in POV (See attached Pic)  then OS only shows the MembersName not Description. I need to see Description there as my naming convention for UD is Code - Description. Having code to be viewed in POV is tough to track and know what code means.  Thanks in Advance...Sandeep S    

I am trying to build a cube view where the client can insert suppressed row members for account, ud3, and entity with ud3 having 2000+ members. I can't figure out how to work the suppression so it only shows the top row and allows the user to enter in the suppressed rows without having all combinations visible through expansion. Currently it is showing all possible combinations or no combinations. Thanks in advance for the help!

I want to add a dotted line to differentiate between scenarios. In this example - we are reporting actuals and forecast -- Any ideas?    Thank you, Mustafa  

This is my first time creating a book. I'm working on creating a book that presents an income statement by location. The ideal outcome is that the IS is displaying location at the top and each subsequent page displays a child location member.  I have my loop setup as a member filter that references the location dimension as shown below. My change parameter is setup to change the POV.  When I preview the book it's still showing location at TOP for all the pages instead of showing TOP and then each location base member. Any suggestions on how to fix this or any literature would be appreciated.   Thanks.

Hi Community ! Is there a way to get the culture of the user, by using a retrieve function like XFGetCell? Basically, I have to retrieve the user culture in an Excel file in order to define Titles and other periferical elements in the spreadsheet. Regards,

how can i get 2 columns on a quick view to be shown as %? 

Please see this post from Adam. Posting on his behalf. I also want to know the answer to this.  

GOALExport cube view to Excel with Landscape printing orientation. METHODThere is a cube view setting on the Advanced tab, labeled as Landscape = True/False. I have set that setting to Landscape = True. RESULTAfter exporting to Excel, the cube view fails to take on a landscape orientation, instead being portrait orientation. Does anyone know how to set the Excel orientation within the cube view?

I'm trying to figure out how to build an expression that pulls "Avg Fleet" numbers and plot a bar chat on an existing pane. I've asked a similar question in this post - I was able to make the syntax work. However I still can not isolate just Avg Fleet. I would appreciate any suggestions on what I should fix.    I've been fairly new to Dashboard building that I need help to my bearings. Co

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

How do I generate reports in a loop for each member (branches) and send it to single excel file? I have a cube view report which I'm trying to run for multiple entities member (100+ locations). Any idea will be appreciated.

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.  

Hello!  I received a request to add a maximum and minimum line to a cube view. The cube view shows entities in columns and a variety of accounts in the rows (not together in a hierarchy, so no .base or .children, just a list separated by commas).  Max/min aren't available in the "getdatacell expressions" area so I emailed support to see if it's possible and they directed me to a ranking BR in GS. I loaded the BR, added a row to my CV and updated the pull but still am getting no data. Honestly, I don't think this BR and pull are the solution for what I'm trying to do but I don't know of any other way.  Do any of you have samples of pulling something similar? Were you able to get a max and min in a CV via CV math or some other way?  Appreciate any help I can get - thanks!  Here's the KB article provided for reference:    And the GS CV is in CVs > XFR Member filters (E) Member list using business rule > XFR Member List (C) Ranked Entity Sales.&nbs

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

As the title mentions - I have these months (Apr, May, Jun) that we haven't reported any numbers. How can I suppress the values within Cube view? I want this to be dynamic that if current reporting month is April 2022, then suppress all the future months from then onwards (show zero or blank).     

Hi, We have a requirement to get the Text fields for 5 columns. So, getting these we have used the "Data Attachment Members in the View Dimension: Annotation, Assumptions, AuditComment, Footnote and VarianceExplanation" and able to get the required text with using Member formulas. Could you please let us know if there are any performance/other impacts with using more cell text options use in Cube views. Thanks, Madesh

I have seen a few posts related to this topic but have yet to find any concrete answers.     We are looking for a way to sum members when going to the base level with a where clause without seeing all base members.  For example, we would like to get a sum of all of our Value Added Products.  Our UD4 dimension lists our products and we stipulate whether they are Value Added or not by putting "VAS" on Text Field 1 of the base member within UD4.  Ideally, we could compare our Total Sales at a top level with our Value Added Sales without seeing each individual products.  We are looking to report on all of our Value Added Products without seeing each base member.  We have tried a few business rules and other suggested avenues but we are not seeing the results we had hoped for.  If anyone has any insights on this that would be greatly appreciated. 

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

Hey All,I'm trying to add a column (bar) chart on top of this line chart. But I want it to reference and add a dollar based stats account (e.g. Avg Fleet Total) bar chart. I noticed there is a way to add a second axis on the right - so wondering if I can have two charts on the same pane.  Appreciate the help folks. Thank you!  

Hi,We have created one Cube view with using "True (but determine sparse rows using other columns)" option under Allow Sparse Row Suppression in Column level and gave "True" under Allow Sparse Row suppress in Cube View properties level as we have used Nested members in Rows with Parent.Base member combinations in Member filter level. When we run the report, it suppresses the rows as per other column even though formula column is having data also. Ex: Cube view created with 2 columns1st column with Account12nd column with calculation GetDataCell(A#Account2 + A#Account3)Row is getting suppressed if Accout1 doesn’t have data even though Account3 is having data also. If we remove above suppression options report throwing an error as exceeding the rows limit since hierarchies are big. Could you please let me know if there any option we can use to show the data at 2nd column level in above scenario

Hi,  We have created a cube view report with nested dimensions in row. Our requirement is to add header for each dimension. Attached the screenshot for reference. Could you please let us  know how to add the header in this case. Thanks & Regards, Madesh K

Originally posted by Ashok AmreshWe are loading data using SQL connector business rule and it works fine manually. looking for a way to load it automatically using a extender business rule and then calling from DM step. has any one done this? can you share sample code if possible?