Reporting

I keep receiving this error when attempting to run my dashboard that has a BI viewer component attached to it. I made a bi viewer component and assigned a cubeview MD data adapter to it. created my BI viewer and everything works fine. However, when I assign it to my dashboard I get this error. I've tried attaching other cubeviews to the data adapter and making other BI viewers but I keep getting the same error. Has anyone else run into this issue?    

Hello All, Any ideas how I can remove these "0's" from the background in the Cubeviews? Is there any property that will make it disabled?

Hello all, I need to create a dashboard based on a cube view where I have accounts on rows, and MTD and YTD view in columns for actual, actual vs budget, actual vs PY. The request is to have in the dashboard the report with the rows displayed between the MTD and YTD view columns.  Is there any way I could achieve this in OneStream? Thank you! Adina      

  Hi, I am trying to use Cube View (already added in Data Adapter as Cube View MD) within the Report Designer of the Report component. However, I am unable to see the row-wise values for Entity and Account, and the column-wise UD8 for Text consolidation. I have checked various Data Adapters and Report components in different MarketPlace solutions but have not found a similar case. There also appears to be a lack of comprehensive video tutorials or study materials on using the Report component. Could you please assist me with this? Thanks

I have a column where I'm using a GetDataCell formula and I want my Time Row Header to show a date different than that of the Pov.  I've had a solution that uses a Business Rule but wanted to see if an out-of-the-box solution is available. 

Hello I am trying to create a type of dashboard that will contain multiple reports. I want that whatever report has data, only that should appear and report with no data should get suppressed along with its rows and columns too whenver I execute a dashboard? Can this also be achieved via a Cubeview? Please suggest?

Is there a way to view application Workflow Status reports in excel rather than having to use a dashboard in the application that shows if an entity is certified/locked or not? Something that is easily refreshable so that you don't have to leave the current workflow you're in to view all entities workflow status? 

Hi, I have a book, with different report, but 2 of them are excel spreadsheets with cubeviews inside. They work, but after created and attached i am getting this error if i want to open it again and do any change.   Error in DXCustomFunctionsHelper.GetSpreadsheetDataProvider(). The spreadsheetDataProvider is not available using the Workbook's Tag property. It works in the book.... Any idea? Anyone?   Thanks JJ  

Hi all, I have the same question as AndeaF (https://community.onestreamsoftware.com/t5/Reporting/Conditional-formatting-based-on-the-value-of-other-rows-and/td-p/20227) Is the below solution post by OneStream still the only workaround for the question? I am trying to compare the variance of prior year and current year data and want to return a specific number format based on the two numbers. Thank you.  

       

Dear community, I need to display numbers in columns in cubeview. Is that possible?  Please refer below image for better understanding. TIA

Hi All, How can I show Cell Detail Classification in the report ? Thanks

Does anyone know how to use VBA code to save offline copy?  I know VBA support the following, but anything for save offline copy? RefreshXFFunctions()  RefreshXFFunctionsForActiveWorksheet() RefreshQuickViews() RefreshQuickViewsForActiveWorksheet() RefreshCubeViews() RefreshCubeViewsForActiveWorkSheet() ShowParametersDlg() ShowParametersDlgForActiveWorksheet() Thanks

Hi All, I am trying to display percentage values for the different continents in a BI Viewer component with a Choropleth Map. The display of the values works, but I would like to see only one label per continent, as is the case with South America, for example, and not for each individual country, as is the case with Africa and the other continents. Is there a way to change the labeling to only once per continent?

We currently have a cube view built out to compare specific GL account values from quarter to quarter. Some of these values needs to be translated using using FX rates. We have AverageRate and ClosingRate, but when assigning the Currency in the Cube view it seems to default to AverageRate, but the requirement is to be using ClosingRate values.  Is this best way to do this through an XFBR rule? Help is greatly appreciated, thanks!

Hi, I'm a new-ish user to OneStream and the QuickViews.  Is there a way to prevent a dimension from repeating when you refresh - for example, I want monthly (periodic) columns with a specific UD#7 variable - we will call it A.  Then, I want YTD with a different UD#7 member, B for YTD view.  Whenever I refresh the QuickView, OneStream will give me both A and B for all periodic and YTD data.  Is there a way around this? I don't want YTD with UD#7 member A or Periodic with UD#7 member B but not sure what I need to change for the ad-hoc build.  Thank you!

Hello there, As intuitive as it seems, I'm trying to pass bound parameters from a CView to a DM Sequence. Upon selecting a CView cell, I click on a 1st button to open a dialog window (at this stage, bound params are resolved). But, within this dialog, once I click on 2nd button that launches my DM Sequence that uses the previously resolved params; I retrieve " |!mySelectedAccount!| " instead of the needed value. Button Configuration: DM Step Configuration: Solution Attempts: Since I am able to retrieve the bound params on the 1st button click, I tried storing them to a 'Literal Parameter' that uses an XFBR to string.join values, but when I try retrieving the literal param value i get " XFBR(BR,Function, Account=|!mySelectedAccount!|, Entity= ... " instead of resolving the XFBR ( Which is normal ?) I tried using "Globals" but I get the same result ... literal value instead of resolved value

Hi all, Currently I have a cube view with GetDataCell formula for ad hoc calculation, may I know is there any rounding off function in the GetDataCell formula? For example, we would like to have a formula like Round(A#100) - Round(A#200). Thanks a lot for any possible solutions.

Hi all, I have created cube view wherein I have used E#Test.Base in Member Filter 1  (Test have 2 children A and B). I need A and B in Member Filter 2 to act as param value in the Dashboard XFBR String. How can I achieve this ? Thanks  

Hi All , I was trying to build a dashboard with a Index or a guided List like below. For the below dashboard these are the steps I took :  a. Created A Delimited Parameter  with all the reports  b. Created an embedded dashboard with the value of this parameter  c. Created a List Box with the delimited parameter.  So on the Main dashboard when one click on any of the values on the list , the Dashboard opens on the right.  Although it works , I noticed that the performance of the dashboard is quite bad compared to if I create the same dashboard with tabs .  Both the dashboards are using the same underlying cube view then why is there a difference in Performance ?  Is there something wrong with my approach ?  Tabbed dashboard   Regards, Saurav

We have developed cube view for BS level commentary to avoid the business excel and email conversation on close process.But we need suggestion on threshold setup to commentary column to allow users to input. Ex: If Var% > 10% only users allow to enter commentary else   not.

I am working with text editors and found that when I try to undo something I keep getting the "Object reference not set to an instance of an object." error. Does anyone know if this has been fixed in newer versions (currently using 7.4.2 for this) or if there is a way to fix this within the application?

How to create a form with dynamic cost buckets (columns) that change every year for different entities in OneStream ?

Hi Team, I wanted to double check if origin Import can be used within XFSetCell. It gives me error and my assumption is we can only use origin Forms.  It's strange that this field is not predefined and we can type there "import": Many thanks!  

I created a parameter to specify the dimensions that I want to pull into a Word document.  I want to format the data cells to show a "-" and not a zero but I cannot get that to work.   I tried : NumberFormat =[#,##0;(#,##0);-] NumberFormat =[#,##0;(#,##0);” – “] It only shows an empty space and not a -