Reporting

Hello,  Can the Excel format be set on the cube view so that the header font can be underlined, for example?  New Product Analysis instead of adding a guideline for the entire header cell?

how can i retrieve the WF (year-1) M12 in CV column?  example: WF year: 2023, 2024, 2025 CV column time parameter: 2022M12, 2023M12, 2024M12

Howdy,When using Guided Reporting, the Selector List Labels are not being positioned correctly. As shown below, the label is positioned on top of the next parameter (to the right) instead of the parameter it's associated with. Has anyone experienced this before and have a solution?  Additional information:Occurs in every report when viewing in Guided ReportingGlobal Selector List Labels are aligned as expected  Thanks in advanceMantis   

We are looking to turn some of our existing cube views into report books to loop through entities. Right now we use an XFBR string (referencing Brapi.Workflow.Metadata.GetParent) instead of a parameter to determine the entity. Is it possible to create a report that loops through the entities with the XFBR string or would we have to duplicate the cube views and use a parameter instead? 

I have a Cube View with three Account dimension columns - Net_Rev, Std_Cost, and a CVC calculated division column to calculate Std_Margin (Std_Cost/Net_Rev). Rows are a UD dimension representing the Product.  In my Dashboard, I have a Cube View MD Data Adapter using this Cube View as the data. When I add a BI Viewer Pivot Grid, I want to display the same three columns - Net_Rev, Std_Cost, and the calculated column. I see CalcScript in the Pivot Grid's Data Source dimensions. How do I use it in the Pivot Grid to display the calculation that the Cube View was doing for that third column?I thought I might reference it in the Value filter along with the two Accounts, but it doesn't appear as a column in the Pivot Grid. 

I am trying to get a dashboard to have a particular scrolling behavior that I am not sure how to do if it is even possible.  A simple example of the ideal is below.  In this ideal dashboard the dashboard will scroll horizontally only.  The inner dashboard will individually scroll vertically.  I can not seem to get the outer dashboard to only scroll horizontally, and when it does that outer horizontal scroll turns off it appears the inner vertical scrolls.  I think I am asking for too much but was hoping to get some confirmation.  Thanks.  

Hi Everyone,We recently received a request from the client to set up a default value in the combo box for the cube view. The cells are set with type Annotations and has a dropdown of options to be selected. The client wants to default the dropdown as PctBudget until and unless it is changed.Is there a configurable setting that can be used to achieve that? I used the default value/members under parameters but it didn't help the cause.Thanks in advance!PragyanshuJackLacavaHenning 

Hi, I wanted to check if there are any ways where we can set the members for each dimensions in the quick view by default as per our need so that the user doesnot have to update eachmember everytime while creating new quick view. Currently it is pointing to None for UDs, can we set any specific member to default?

Hi all,  I'm encountering an error with one user who is attempting to export a report to Excel. The download process is functioning correctly, and the file is being saved in the OnStream temporary folder. However, the issue arises as OneStream is unable to open the file automatically. It appears to be an issue related to permissions on the user's laptop. Could not find a way to fix it, any ideas? Thanks.  

Hi all,  I'm currently facing a challenge and do not seem to be able to get this to work. I have a CV displaying (amongst other things) a Dynamic Calc-Account (in Column) across Entities (in Rows), where entities have various currency. I want to be able to display the currency in the cell (with setting on CV cell format (ShowCurrency = True) I tried in essence the following in the business rule that calculates the value: Dim currencyID As Integer = api.Pov.Cons.MemberId Dim value As Decimal = 120.10 Dim result As DataCell = New DataCell(New DataCellPk(), value, New DataCellStatus(DataCellExistenceType.IsDerivedData, DataCellStorageType.Calculation)) Dim resultEx As New DataCellEx(result, "", currencyID, AccountTypeId.Asset) Return resultEx But that is not working unfortunately. Does anyone have an idea on how to get this working? Thanks Markus

I know I can have a different scenario where I can combine actuals and forecast each month with data management job and I can use AllPriorYInearInclusive for Actual columns and AllNextInYearInclusive for Forecast to do this when i want just months. But I want to also have quarters summing 3 months potentially actuals and forecast together if date selected is in middle of quarter. And YTD columns summing actuals and forecast.   Below is example of what i want to achieve. Is there CubeView Extender i can build to make this happen. For Quarter and YTD columns i can just use getdatacell(CVR(Col1)+CVR(Col3)+CVR(Col5)... etc. but i would like to somehow switch actuals to forecast for all future months of WFTime, TimePOV or Parameter selection.

Hello:   Has anyone had any success with grouping columns in a cube view in a report linked to excel, or grouping them as they export? Of course in the data explorer version you can use the tree function and toggle the row expansion mode to get the intended effect, and in rows you have the excel outline settings you can play with. However, there doesn't seem to be a way to manage this using settings. And obviously if you format the cube view when linked them refreshed the column grouping goes away.   Interested to hear and thanks!

I’m trying to create a text box component that can be added to a BI Viewer and easily updated by end users directly in OnePlace. The goal is for the users to be able to edit the text without having to modify anything in the underlying application or configuration. Here’s what I’ve attempted so far: Created a string parameter intended to store the text. Tried adding a dashboard parameter control (such as a text box) linked to that parameter. Embedded it into the BI Viewer view. However, this approach didn’t yield the desired result. The text either doesn’t update as expected, or isn’t visible to the user in the way I intended. Has anyone successfully implemented a user-editable text box that can be directly manipulated by end users in OnePlace and reflected in a BI Viewer component? Any guidance, best practices, or examples would be greatly appreciated! Thanks in advance for your help.

Hi AllDoes anyone know how to add a carriage return in Annotation text (if it's possible)? We have a Cube View with an annotation member that displays data. Currently the annotation text can take up most of the screen on some rows and it would be really useful to be able to enter a carriage return. I have tried Environment.NewLine, vbCrLf, \r\n, <br>

Is it possible to create a Roadmap inside of OneStream? If so, I am looking for some guidance on how that can be accomplished and how difficult it would be to maintain and update the roadmap when needed. 

Hi, I'm trying to build a getdataset rule for the first time in ws assembly. I ran into this compile error while setting up service factory, any idea why? Thank you.  

Hi, I am using an XFGetCell Formula which references the POV for Time. I would like to use a formula to pull in the period prior to the POV in the same worksheet and keep it dynamic based on the POV.  Any suggestions? If it's not possible to do in the formula, I will need to create a UD8 to return the prior period time.  Does anyone have a ready-made formula for this?  I would greatly appreciate it! Thanks!         Thanks!

Need assistance building this logic in for two conditional statements to return a value. The logic reads if one row is greater than 0.20 and another row is greater than 0.20, then 0 is the cell value. If not, then 1 is the cell value. Please let me know if I can provide any additional details. 

Dear all, Could you please advise how to show Text field of Entity member in cube view instead of Entity Name. For example, I have: Entity member with Name A, it has Text1 field Country 1, Entity member with Name B, it has Text1 field Country 2 Entity member with Name C, it has Text1 field Country 2 I would like to show in cube view in rows figures on Country 1 and Country 2 (so I need to aggregate figures of Entity B and C in this row). Could you please advise is it possible? If it isn't possible to aggregate figures, could you please advise if I can simply show three rows Country 1, Country 2, Country 2 in cube view instead of Names.

Hello, it's probably simple question to solve, but I wasn't able to find a solution.Is it possible to display the dimensions (master data) of the query in the cube views?e.g. columns, CV should generate a table with the following: Account | Amount | Cost Centre Number | Cost Centre Name | Profit Centre | Profit Centre Name |... and so on. I have tried it via UD (where the information is located), but I only get the amounts, but not the elements/master data/dimension or description. What am I doing wrong? Thank you!  

Are there any out box reports available to show constraints by dimension?

Hi, We have installed NRR and are able to upload documents. However, adding a cube view using the syntax is not working. Despite searching related articles and trying different syntax variations, the cube still fails to render:Syntax 1:{DOCVARIABLE"{XF}{Application}{CubeViewReport}{Abseentism_Rep}""IncludeReportMargins=False" "IncludeReportHeader=False""IncludeReportFooter=False" "IncludePageHeader=True""IncludePageFooter=True""}Syntax 2:"{XF}{Application}{CubeViewReport}{Abseentism_Rep}"We are on V8.2.2, does anyone have any tips? 

Dear all, Could you please advise is it possible to combine several cube views into single Excel file and download it from the application? If so, could you please advise how to do that.

Originally posted by Arthur Shedd

Hi all,We have built a excel report which includes multiple xfget formulas. However, an #Value error shown in the cell after refresh (refresh sheet/refresh workbook both are not working). I have also checked that the dimensions have been entered correctly in the formula.May I know is there any solution to address this issue?Thank you.Best,Jacky