Reporting

Good morning All, How do I make build this dynamic calculation for my Monthly Rate KPI CV?  It takes the new month and divides it by the previous trailing month (e.g. Jan-21/Dec-20, Feb-21/Jan-21....)   Here is the code I wrote: Dim RentalRevenue As Decimal = api.Data.GetDataCell("A#NetIncome:U4#[Rental Revenue]").CellAmount Dim RentalRevenueTrailing1Mo As Decimal = api.Data.GetDataCell("A#NetIncome:U4#[Rental Revenue].Prior1").CellAmount Return RentalRevenue/RentalRevenueTrailing1Mo   Any ideas will be appreciated. Thank you.   Best, Mustafa A  

Hi, I am working on a huge report (via Cubeview) with over 3 million rows with data, and i am unable to export to Excel nor PDF. Error message siad that the maximum row allowed is 1 million rows. Does anybody have an idea to increase the number of rows please? Thank you very much Khanh  

Hi All, How do I make my Cube View display prior2 year (2020), but only the last six months. Any suggestions will be appreciated. Thank you!  

How do I make the entity column to align left? Excel has it's own formatting, but it changes back every time I refresh my workbook.  I'm using an excel-add-in.  Wondering if there is any alignment setting, that could be changed in OneStream.   Any ideas? Thank you!

Hi, We have built a cubeview in OneStream. Now we are having a requirement to get input/comment from user and store it back in OneStream. Is there any KB article or something to refer? Please suggest how to achieve this.   Thanks  & Regards, Madesh K

Hi, I have two question in one:1. I'm trying to add a variance column in a Pivot in BI Viewer for amounts that are split by 2 scenario's, actuals and budget. What is the most practical way to do this? I thought I would add a variance in my cube view used in the cube view md adapter but this is not picked up by BI Viewer.2. Can I sort this variance column by the amount value?

There is a new column-store storage engine for reporting out of Onestream called "Analytic Blend". I have been examining the related documentation, and hoping to find an API that would allow this engine to return data for ad-hoc queries. We have custom processes that require CPM data from onestream. These processes would greatly benefit from the ability to retrieve query results from Analytic Blend.  Is there any technical documentation that would help software developers to interact with that column-store data? I have the "BI Blend Design and Reference Guide" for XF 6.3.0, but no other resources beyond that.   That document primarily describes how to prepare the Blend output database. But it doesn't describe how client applications might use the results. Can I assume this is because the because the database is standard Microsoft technology, (ie. that it only requires standard SQL knowledge/skills)? Can I assume that querying data from this Blend database would be fully suppo

Hi, in the getting started with BI viewer I see they make use of a date field, which enables you to drill down to quarters/months etc. How do you create such a field (I guess I have to something with the time dimension which contains my years and months). I'm struggling with finding an expression that works...

Hi everyone, Quick question re Dashboards. When you use a parameter in a Cube View there is an option to display the Member Filter using a "Member Dialog" Parameter Type.  This shows you the results in a hierarchy that can be expanded or collapsed.   When building an interactive dashboard I need to present the user with a large number of members to select from.  The Combo Box option isn't particularly easy to browse through as it simply lists the members (albeit this can be indented with a BR to imply the hierarchichal relationships).  Is there a way of replicating the Member Dialog Parameter Type in a Dashboard component? Regards,Lee    

I am building a cube view with two rows and 12 columns. Assume POV=2021M12:   The first row is A#Sales and in the second row I want the variance of the sales from row one this month minus the sales last month. (Think POV minus POVPrior1)   In the Column I have one Column with T#POV.AllPriorInYear.   The problem is that the formula in my month over month isn't smart enough to populate 12 cells of variances.    I know I could do 12 separate columns and use CVC, but that isn't a great option to me for other reasons. Anyone have any ideas on how to do this?

So I currently have this cube view: Is it possible to configure the cube view so that the headers for the second member expansion (for UD2) start expanded, while the other row headers stay collapsed? Ideally it would look like this: I have tried using the following header format: However, this doesn't work, presumably because RowExpansionMode is a "Entire Cube View" setting. Is there a setting I'm missing, or would it be possible with an extender rule?

Cube View: When trying to sum a column that contains T#POV.AllPriorInYear the return is only for the first column reported. Is there a function to sum these in the cube view? I am combining scenarios that can be dynamic and need to sum the results. Same would be true for AllNextInYear.

Hi everyone,  I have a cube view that uses an entity parameter with member filter E#Root.WFProfileEntities for users to select their respective workflow entities when opening the cube view. However, the list of entities depending on the workflow chosen is quite large and the order of entities in the dropdown seems to be random, when I was hoping the order would mirror the entity assignment order in the workflow section. Would anyone have any suggestions on how to organize entity dropdown list as per workflow entity assignment?  Thank you,  Royce 

Dear Community - Is there a way to convert to Basis Points within Cube View? I'm sure there must be a setting. Any help will be appreciated.   Thanks,

Would like to modify the "UPPER" case descriptions in metadata to "Proper Case" in Cube Views. Any formatting options for this?

Hello: Looking for guidance on how to implement an enhanced conditional formatting check.  It's quite simple, apply some formatting based on the account type. Consider the example of a single row CubeView with one account as the member filter: A#A87999.  Formatting should be applied if the account is a Liability type. I have a mostly working XFBR helper that can correctly apply formatting but only if I hardcode in the account reference.  Obviously that won't work for all but the simplest CV as reports are often dynamic with Member Expansions. The mainly working formatting syntax as currently written: If (XFBR(XFBR_FormattingHelper, AccountTypeIsLiability, Account=[A8799])=True) ThenTextColor = RedEnd If How do I make the parameter dynamic?  I've tried the following: ... Account=RowE1MemberName ... Account=|RowE1MemberName| ... Account=[RowE1MemberName] ... Account=[|RowE1MemberName|] None seem to work.  Is there a different way to reference the standard availab

CubeView - Calculate the Variance for multiple columns ( Column-by-Column) Hi there, I am trying to calculate variance Column-by-Column for all time members of Current Year Vs. Prior year and looking for good option for performance optimization. Please find below the details: I have CubeView with 3 columns.   Column 1: T#Year(|!SelectTimeYear!|).TreeDescendantsInclusiveR This gives 19 Columns of current year (year, half year, Quarter and Months) Column 2: T#YearPrior1(|!SelectTimeYear!|).TreeDescendantsInclusiveR This gives 19 Columns of Prior year (year, half year, Quarter and Months) Column 3: Need to generate 19 columns for variance between respective time members form previous members. 2020 vs 2019, 2020H1 vs 2019H1 etc. following are some options I have implemented or have thought of.  I am trying to work Option 3 but don't know how to do it. Option 1: I am able to generate the 19 variance columns using UD8 member but I believe this is impacting the performance o

For columns there is formatting for CVMathOnly, but there is not for rows. What methods are used to be able to use the row as a source value, but not display? Place at bottom and format? Using a live app where the hierarchies are set.

Hello,  Is there a way to format a cube view column for variance explanation to be a certain color/have text in the cell based on the variance column? The attached/below is what we want it to look like. If this is a cube view extender, is there any sample code? The example in Golfstream didn't seem to relate to this.

Is there a way that you can exclude the value of a specific child in the account hierarchy without losing drill down functionality in cube views? For example to exclude bonuses from staff costs.

I'd like to be able to build a Pareto chart in BI Viewer. Is it possible?

Source:   Migrated from Champions Does anyone know if it’s possible to use a hard enter (ctrl + enter or vbcrlf in vba code) in a label?

Jigsaw, one of the partners in South Africa needs to build an Onion Graph for one of our SA customers. Anyone have an idea how to do this?  

I have a report book I've built that loops thru a dimension and creates a tab for every member in a ud hierarchy. I've set book to label the tabs using the CVUD2 and CVUD2Description.  It works quite well except there are some descriptions that have hyphens in them which don't print out. Is there any way to print the hyphen included in some descriptions?

Hello! I'm looking for a solution to the new Quickview feature of splitting up Excel tables into pages, when the number of rows exceeds a certain number. I'd like to show all information in one page still, if possible.