Reporting

After processing the Cube, suppression options for Cube Views in the Analysis Tab disappear. When opening Cube Views in a month where the Cubes are not processed, the suppression setting is still there. Is there a way to solve this, so the suppression setting is always visible? Suppression setting visible (Before processing Cube)Suppression setting not visible (after processing Cube)

Integrating emojis into OneStream workflows, like :memo: for forms and :crystal_ball: for forecasts, enhances clarity and user engagement. Simple to set up, just copy and paste your chosen emoji into workflow titles for an instant visual upgrade. Interested in setting this up in OneStream? Dive into the world of emojis and elevate your interface today! :rocket:

Hi, I have a button that runs a dashboard extender business rule. Between the 4 server options available, which one should I choose when, and should I even care about choosing the right one (i.e. when does it make a difference)? Thank you      

Hello, we use the Addin to retrieve data from OneStream to Excel and we work with quite large files. There are several groupings in the excel file and as soon as you collapse and reexpand a grouped section all cells with OneStream-formulas change to #Name or #Value and we have to refresh the workbook again, which is very annoying and time consuming! Same behavior when you just simply add a line within the structure. Does anyone have the same experience in Excel with the OneStream Excel Addin?   Regards Martin

Has anyone pushed files from OneStream FileShare to a company SharePoint site? Is the best approach using Microsoft's SharePoint client object model (CSOM) to upload to subfolder in SharePoint (I assume that OneStream support would have to load the Microsoft.SharePoint.Client DLLs to your system)? Or would it be to use SharePoint's REST API Endpoints to make the connection and post the files to a subfolder? Can anyone provide examples or snippets of either approach?

Hello Team - I am working on a cube view where I would want the resulting values (variance amount) to sort with the highest value first. Wondering if anyone else has attempted this. Thanks, Ritesh

Hi, How can I filter accounts by the plug account property just like I can filter by other account properties such as text? I am creating a CubeView and I need to show a series of accounts that have in common "x" plug account, but I am not able to filter accounts by the plug account property. Regards,

Apologies if this question has been answered elsewhere - I have been searching for a while but didn't find anything that solves my problem.I have a cube view with a single column whose member filter is T#|CVTime|.BaseIt displays 12 columns, which is great - one for each period of our fiscal year. For example, if CVTime is 2025 then the cells of each column going left to right will have their POV Time as 2025M1, 2025M2, ... 2025M12. Wonderful!However, on a single row within the cube view, I want to instead display values from the previous fiscal year using a column override for that row.  In other words I want the POV Time for the cells in that row to be 2024M1, 2025M2, etc.Seems straightforward but the two seemingly obvious options I tried do not do the trick:T#YearPrior1(|CVYear|).Base  (yields 2024 for each column.) T#YearPrior1(|CVYear|.Base) (yields 2025M1, 2025M2, ... 2025M12)   - I don't know if it matters but it's not clear to me if that's how the syntax

I have built out an extensible document in PowerPoint that extracts a set at dashboards out of OneStream. I have charts displaying data for the current month, and previous two months.  I am having trouble using a variable to label the two previous months. For the current month, I just use the |CVTimeDesc| variables and it labels it correctly. But I can't seem to find a variable that works to display the prior period months description. Something along the lines of |CVTimePriorDesc|... Any help appreciated. Thanks!

Is there a way to format 'NoData' cells so that when the report exports to excel it shows a dash or 0, instead of the cell being blank?

For years now if you had a combo box on a dashboard (use View as the example, where a user can select MTD/QTD/YTD) the user's selection would be saved. This would mean that even if the default for the View Parameter was YTD, if the user picked MTD it would stay on MTD the next time they came back to the dashboard.  I have been noticing in V8.1 this is no longer the case. When I come back to the dashboard, it is always set to the Default YTD, even though I left it on MTD. Am I just missing a new toggle somewhere that I need to flip on so that it saves my selections? Has anyone else noticed this behavior? Thanks!

Dear Community, Is it possible to merge cell in rows and display our heading in center of it? My heading should be populated in center based on user selection of time. In first image it is in left but I need it in center.   

Is it possible to use a variable or dynamic selection on the the index?  For example, I would like it to vary based on the cubeview time, e.g. - an index of 1:(SubPeriodNum). See example below.

HI all, For our reports @Mars we would like to show a complete blue header bar f(rom the left to right), including the column header titles, like below: I've been playing around with the CV extender options but I havent got any further than below. It keeps aligning the titles at the wrong position, left or right. Does someone have a nice example of an extender rule who solved this?   Thanks alot!   Regards,Jorrit

Is there a way to pass the Required Input Parameters for a book into a loop?  For example if the users picks 2024M3 for time I want to be able to produce a report for that period as well as a report for -3 months and -12 months.  I can get T#POV, T#PovPrior3, T#POVPrior12 to work but I would like to use the input time instead.  

Hi Team, 2 users having the same access and same Cube view POV . One of the users is unable to see a total UD1 column while other can see it. Has anyone come across this before?

Hi All,  I 'm trying to build a cube view report, it has numerous rows in it, However I need only TOP10 results. Could you please help me how do I select only Top10 results based on the total value? Assume that it is sales related information, Report has the details about all location sales. However, I would like to see only TOP10 location results (Based on the total sales)It would be helpful if anyone could assist on this ASAP. Thanks, Bharath

Hello Experts,Is it possible to use Combo Box and let users select value from the list in Cube View Rows (Headers) just like how we do in Excel. I see an option called Cell Type which has Combo Box but when i try it, doesn't work for some reason. Thanks in advance for the suggestions.  

I have a dashboard with a Label component that uses a Cube View as the data adapter. Here's how it's set up: The Cube View (CV) employs an XFBR in the account POV to retrieve one account number. Therefore, I've assigned XFBR(BRName, Function_Name, Account =[|!Param_Account!|]). The XFBR utilizes a Member List parameter from the same dashboard, where I've set the parameter's default value. The error occurs when I open the dashboard. The Label value attempts to run the Cube View, triggering the XFBR rule. However, it fails to capture the default value of the parameter, resulting in an error. My assumption is that the XFBR is unable to transmit the default parameter value. The workaround is to directly open the Cube View section and modify the account POV field to only include |!Param_Account!|, then run it once. This action somehow prompts the system to store the parameter value for that user. Subsequently, when the user runs it from the dashboard, the error is resolved. Do you ha

Has the syntax for Navigation Action changed to include workspace name in .v8? We have buttons that open up cubeviews that have been working fine in the past, but now don't work since we upgraded to .v8.1.  Others actions like open up workflow or other dashboards work fine. Just DataExplorer that's not working. TIA    

Hi All, I'm trying to create conditional formatting based on the scale. I would like to have the number format without decimals when the scale is set to 3 or above and vice versa when the scale is set to zero. Do you have any idea?FYI - The scale is a parameter that the end-user can select in the cube view.  Thanks, Davide

Hi All, Our external auditors are requesting an audit report showing all the changes applied to the cubeviews. I researched in the "application reports" but could not find anything that fits the requirements. Do any of you have insights or know of any potential workarounds?Thank you, Davide

Hi all, In a case we'd like to have a CV with 3 columns using different intercompany groups (group 1, group 2, group 3), for a particular account (1 row). Do you know how this can be done? I could do a member list but this would show the detail of every I#(partner x) for all the combinations but I'd like to show only the totals of each IC group. Thank you. Best regards, Carlos 

I have the following in Rows: Trying to exclude one account Goodwill from OI_EX_O. Member Expansion 1 - Primary Dimension Type UD1 / Member Filter / GetDataCell(A#FINS57:U1#OI_EX_O - CVR(GoodwillImp)):Name(OIE_Operating).   Columns are shared. The calculation for Variance$ and Variance% is not working for this particular row:   Shared Columns:        

Hi all  What would be the best way to create an intersection of two hierarchies within the same UD? For example, assume these are Profit Centres in UD1.    I would like to be able to create a cube view where by I could choose a node from hierarchy 2 and it will display the members (and the relevant subtotals) using hierarchy 1. i.e. if you choose 2022 you get the following: Thanks, Mark