Reporting

Hi,   I'm trying to setup a variance account under UD8 that will calculate the variance between the current year last 12 months and the prior year last 12 moths. Any suggestions on how to write this formula? Thanks.

Hello All, Need assistance in getting the USD Override amounts to populate Local Currency Parents in USD values.  The USD Parents are working correctly when data is retrieved in Local or USD. Example Local Curr Entity CNY (rate .800) - 2000, USD Override - 3000 USD Parent Entity (USD) - 3000 Local Currency Parent (CNY) -  CNY - 2000, USD - 1600

Hi all, I've created 6 separate cube views to replicate a pdf report that we send out monthly to the Board. The CV's themselves are not too big - say 10-15 columns by about 15 rows. In the report, we previously combine the 6 tables into 1 pdf across 2 pages - normally a cut and paste job from Excel.  Now that I have built the cube views, is there a way to combine all of these onto one or 2 pages in a Report Book? I have created a book now with them, but the CV reports print to separate pages. Because of this, they only take up 1/4 of the page, so there is a lot of white space and would then push the report out from 2 pages to 6 pages - not ideal to present to the board.  Alternatively, is there a dashboard layout where you can combine and export multiple CV's on the same page? My current dashboards are in the Tab layout with the CVs separated by tabs.  I know an easier option would be to create a large cube view and separate the reports with blank rows, but this isn't po

Hello, I need to create an advanced chart which shows two data bars, each bar is taken from a different cube view. I have tried to add the two Data Adapters which are each based on its own cube view, but the chart is displaying only data from the first cube. Is this possible by using the cube views data adapters or is it needed to create a business rule or something else?   Thank you.

Hi Everyone, In our system - Profit Center is in the Entity Dim and Cost Center is in UD1. Only specific Cost Center(s) are valid per profit center, and this mapping is stored in a SQL table in the system.   The need is to be able to enter data for 1 specific account, against all valid CC and PC combinations.  In Cube Views - if we have Entity.Base in rows, is it possible to get the valid UD1 in the row using the mapping table?

Hi, How to get 4 quarters data in one year like Q1+Q2+Q3+Q4= 2023?  what is the use of Scenario View-SV in View Dimension?   Can anyone help me with above questions?   Thanks in advance.

Hello, The customer reporting format includes data from both cubes that are currently set up in the application. How can I create a cube view that results from a combination of the two cubes? Thanks!

Hello All, I am trying to use the Global Time to pull reporting columns using the UD8 dimensionality but the values will not return.   Dim ScenarioMth As String = api.Pov.Scenario.NameDim gbTimeName As String = BRApi.Workflow.General.GetGlobalTime(si)Dim objTimeMemberSubComponents As TimeMemberSubComponents = BRApi.Finance.Time.GetSubComponentsFromName(si, gbTimeName)Dim gbMonth As String = objTimeMemberSubComponents.Month.ToString If gbMonth.Length < 2 ThengbMonth = "0" & gbMonthEnd If Select Case gbMonth Case 1If ScenarioMth = "FCST" ThenReturn api.Data.GetDataCell("U8#None")ElseReturn api.Data.GetDataCell("S#FCST12:U8#None")End If End Select

Originally posted by Jill Balke I am looking to do a conditional formatting that would return a result based on a cube view showing both a variance dollar amount of over $4m and over 5% which are in two different columns of my cube view, and I haven't been able to figure out how to look at data in more than one column for conditional formatting yet.  Would this be possible?

Hello, I have a calculated column in a cube view, using CVC referencing another column.    This works and is showing the number from the other column.    Rows are a dynamic member expansion. I would like for the calculated column to only show a value in rows that have a specific member name. So I'd like to add conditions to the CVC  Any ideas?

Hi, Grateful for help. I am trying to expand a member in the Account dimension. I want to expand all children that are base members.A#MyMember.Children.Where(HasChildren = False)Above is the formula I am using, but it doesn't work. If I enter False, then all accounts are shown (even calulated members/parents) and if I enter True then all rows are suppressed, I get no result at all.

In this Cube View I'm building there are multiple columns - some of them amounts and some percentages. I tried to put the percentage and decimal formatting for those respective columns in the column cell format. However, that formatting is being overridden by the row formatting. I'm trying to get the cell formatting to do no decimals and no percentage signs for the cells that don't need it and decimals and percentages for cells that need it. Please provide some guidance! I attached a screenshot below:  

Hi All, We have a technical blocker for one of the report in our planning application. This report has UD2, UD3 and account as parameters. On the dashboard, this report appears fine when user seamlessly selects the parameters from the interface. There is some dependency between these user selection options which is handled through XFBR rule. For a specific UD3 member, a certain list of UD2 members will appear for selection, for another UD3 member a different set of UD2 members will show up and so on. We have the same report available as an offline report having the same cube view connection. In the spreadsheet, this dependence is causing a blocker and parameter pop up for UD2 appears blank showing no options for user to select values. Kindly guide us on how this dependence of parameters can be handled in the spreadsheet having the same cube view connection.

Hi everyone,   I have some blank rows in my reports, and I wondered if I could make them smaller than the default row height. In the cube view report, there is no option for setting the row height, so I considered setting the font size to 1. However, this doesn't change anything. In the reporting options, you can set the row height. However, setting it to 1 doesn't seem to do anything. No luck either with the font size. Question boils down to: Is there a minimum row height? Any answers are much appreciated. Thanks! Floris   

Hi, Is it possible to bring in two Scenarios in a QTD column that are not Quarterly periods like M5 or M7 or M10.For example if I use Q1 by default it will be March period and for Q2 it will be June. But if the user wants to pull in data for M5, In Q2 column can we retrieve two months Actual (M4 & M5) plus One Month Forecast (M6)? Or if the user wants to retrieve data for M4,  can we retrieve one month Actual (M4) plus Forecast (M5 and M6) for Q2 period. Please advise if there is any function to retrieve this in Quarterly Periods or if we need to create a business rule for each quarter. ThanksSamuel

Hi all: I would like to reference the Cube View name in a Business Rule as part of the Cube View structure.  My current assessment is that this is not possible but thought I would check with the community to see if I've missed anything. The goal is to manage all our Column Shares and Linked Drill Downs in a centralized repository which allows us to utilize common parameters on all reports.  This greatly simplifies both report writing and maintenance of these features across a wide swath of reports where the same column shares and linked drill downs are used. I have the custom tables, prototype business rules, and parameters all working with a hardcoded cube view name. The next step would be to make it dynamic by referencing the cube view name itself.  Again, it doesn't look like this is possible but wanted to check if anyone has an idea for making this work.  My assumption is that this functionality would work in a dashboard where we have more control with load even

Running a report and the company's logo is appearing on the left top corner and I would like to hide that, just not sure how.

Does anyone know how to keep the OS Excel Add-in from crashing when you activate the solver add-in? I can't seem to get these two to work at the same time. Has anyone else experienced this?

Hi All, I am creating a cube view with a 'Current Year' column and a 'Prior Year' column based on the POV (this company has an August close fiscal year).  These columns work if I am viewing full year over full year, but if I want to view Feb 2022 YTD vs Feb 2021 YTD, it does not work for the prior year.  The values returned for 2021 only show the full year.  Is there a way to dynamically pull 2021 YTD data based on POV? Attached is a snapshot of what I currently have tried. Any help would be greatly appreciated. Thanks, Damaris

Hello Team, Do you have an update on possibility to have a direct connection to fetch data from OneStream SQL database. Thanks.    

In Microsoft Excel, the Percentile and Percentile.Inclusive functions use the R-7 Methodology, Percentile.Exc uses the R-6 Methodology for Quantiles.   These functions exist in the OneStream Spreadsheet tool, does anyone know if they are the same as Excel?

Hi,    I am trying to allow users to calculate cube view in a workflow on an icon (see picture attached) within the cube view, but when they right click on the cell, calculation is disabled. Please let me know if someone knows solution for this

Hi everyone, I don't find a lot of documentation about the vDataRecordAll view. Is there a reason as to why this is not easily available? How hard is to get the JOINS to the main tables, so we can see the dimension name, dimension value, etc? Or even a relationship diagram.     Thx Raf    

I have some quickviews that have duplicated rows and I can not get them to delete.  I have tried all the supress row options and nothing seems to remove duplicates.  If I supress zero data, all the rows go away.  If I high light rows I want to delete and delete them, as soon as I refresh they all come back. 

Dear community, I am trying to implement a CAGR calculation as shown in this link : https://blog.hubspot.com/marketing/cagr-formula-excel I have 3 years of data in a cube view, hence my calc should be : (end value / beg value) ^ (1/3) - 1   However, OneStrea does not recognize this "^" which is a pity. What are the alternative to define an exponential value in the cube view ? What I currently have : GetDataCell( (CVC(end_value) / CVC(beg_value) ) ^ (1-3) -1 ):NAME(CAGR)   Many thanks for your input on this