-
Best practices how to show many columns in dataview (>10 columns with a hundred thousands data rows)
Hi all, I want to know the best practices how to show many columns in dataview with approximately >10 columns with a hundred thousands data rows in a dataview. Because I am stressfull a lot about limitation error rows limit issues. I have read many references from other forums/discussions about this one, and overall of…
-
Aggregate functions for Board Cubes
Hi, if you display a Board cube in a DataView and group it by an entity, then a sum is always formed for the values from the cube. Is there also a way to form an AVG(), MAX() or MIN() on the individual values instead of the sum, so that an average or a maximum value is obtained from the individual cube values? I would like…
-
Calculate Mix including Subtotals
Hi there, how can I calculate percentage mix including subtotals? At the moment it is calculated by group. The algorythm formula GT doesn't work since I have Years in the columns and it does the math for the sum of all years. However I need it by year. Thanks maik
-
Sorting in Data view with Detail by
Hi can someone shade some light into sorting logic with "Detail by" activated? a - is on the first spot and Detail by Year is activated - However it isn't shown in the preview When I move it to spot - b - I can see Occ TY by Year - However now the order of the other columns is screwed. Any idea how to fix this? Thanks Maik
-
Maximum Data Blocks within a Data View
This takes me back to excel days. I'm currently at FD with data blocks and I'm blocked from adding any more in. Is there an upper limit? Has anyone had this same issue or never gotten to this many blocks? Build is in B14.2. I'm trying to add algorithms in not additional data blocks. Doing this with right-click add rather…
-
Issues with 'Detail by' sorting feature
This issue has popped up in the layout editor after I added an entity in the configure drill down. The data is tying out correctly for all my data blocks, the only issue now is when I try to drill down on a specific P&L line. The drill down shows every member in the entity rather than the specific line I am trying to drill…
-
Board 14 - Confusing design tooltip border in layout
Hi, When hovering over tooltips in a layout, a confusing triangle shape appears. This shape can be misinterpreted as indicating additional information about a specific field (e.g., 'Measure Type' in the attached screenshot), which is not its function. Can the triangle shape be removed?
-
Dynamic Visibility of a cube / data block in a data view
Hi, is there any possibility to steer the visibility of a cube / data block in a data view? I want to achieve that I can steer on an admin scree, if a certain cube/data block is visible in a data view on another screen. I know that you can steer the dynamic visibility of the whole data view, but I need it for a certain…
-
Loop function doesn't work
Hi all, I'm trying to do a loop calculation, but for some strange reason some of the numbers don't add up the cube has 2 dim (month and Drivers in blue) the first member of Drivers (baseline) has only the value in the first month, while for driver "a" "b" "c" i can data entry after the first month my goal is to copy the…
-
Skipped rows of Cube value of 0
Hi guys, I have some issues that have skipped rows of Cube value of 0 but in Data Reader ETL is displayed well. I have unchecked Hide zeros and checked differentiate zero and null. Anyone have some ideas or solutions about this one? Thanks previously
-
Blob Cubes (Custom) Upload and Download Functionality
I'm creating a screen within our business planning capsule that will be a single data view object intended to store various file types that offer supplemental information over what's provided in the business plan. I would like for the file inputs to be heterogenous, so that I don't have to create a cube specific to the…
-
Suggestions for Chart and Data View Enhancements
Hi Team, Here are a few suggestions for improvements in the Charts and Data Views: Additionally, when the "Auto-Range" feature is enabled for the axis, the value range adjusts correctly, but in some cases, markers get cropped. It would be helpful to either adjust the auto-range logic to ensure markers remain fully visible…
-
Column Entity Always Show the Total Members and Not Display the Actual Value in Dataview
I want to know the causes of why my Part Number column entity always show the total members and not display the actual value? Did I have some mistakes in mapping my cubes? FYI : Cube (Mixing Ratio)→ Have 3 entities mapped into it (Part Number, Plant FG, Supplier/Cost Center) And here captures of my settings in Layout…
-
Block showing only sum total
Hi everyone, Is it possible for a block in data view to only display the sum total? I've tried using the algorithm rt(j) but the variance total is incorrect, i.e. I want the total variance to be -7,425.5k, not 325,424.6k. If I take away 'Detail by Month' in block j, the variance calculation is wrong. In essence, how can I…
-
How to find maximum value of cube or entity in Layout Editor?
Hi guys, I have no idea about how to find maximum value or calculate this formula inside Layout Editor Dataview : "Max of Price In IDR (Current Month) = MAX(Price In IDR) WHERE BOM Period = Current Month" I will appreciate your helps for this case. Thanks.
-
Algorithms
Hi, is there a possibility / syntax to refer a algorithm block (using the formula “rt(x)” or “dt(x)”) to only one or more certain columns and not to every(!) column of the entity that is set in the column axis? Can somehow specific entity members be adressed? I want to achieve that there are different color alerts for…
-
Entity Editor
Dear all, I would like to have an entity editor and a data view - where I enter assignments between the members of two entities using the data entry function - on the same screen. The entity members that are created in the entity editor should also appear on this data view. However, the problem is that only the members…
-
Show/Hide Column Dataview like drill down rows?
I want to know that how can I show/hide column Dataview like drill down rows like this picture below. Anyone have an idea?
-
Data entry on if-function with inverse algorithm
Hello, I have no values in the column HR (Forecast) in some months. I would like to pre-populate these cells with a small number (here, for example, 5) in a new column to enable the cells to be filled by manual data entry. I have used an If function to fill the column: h= if(g=0,5,g). How can I create an inverse algorithm…
-
How to rename or alias header title column Dataview for entities located in axes not in data block?
I want to ask about how to rename or alias header title column Dataview? Because I have no found of solutions about it inside official documentation. Thank you previously.
-
What is the best-practice approach for data entry on multiple years per tab?
Scenario: (Board 12.6) Screen selection 18 months: (October 2025 - March 2027) 3 tabs (2025 / 2026 / 2027), in each of which only the corresponding months should be ready for input Is there an alternative to an algorithm that multiplies the data by a month cube and stores the data input inversely? Cube A (Month): 2025: 1…
-
Numbered Axis
Is there a way to number the axis similar to an excel spreadsheet? Maybe I am missing something, but I cannot find any details on this in the reference manual or on here.
-
Ability to present the dimension flagged in a cube as an output on a block
This may be a bit more challenging but if there was an ability to present the name of the member flagged rather than showing the value of 1 when a cube has more than 2 dimensions. Eg asset 1 is mapped to jan, when asset is in the rows, have an option where i can select "month" as an output in the block settings, similar to…
-
Pacer vs. Selector
Hi there, I have a screen in which I have a pacer which is filtering months. I created a procedure that should apply the filtered month to the next screen. However it doesn't do it. Therefore am I correct that you need to have a selector always when you want to screen selections in a procedure? Thanks, Maik
-
29th shows values when YCV PY is used
In reference of ticket 142328 I would like Board to display values on the 29th Feb. when the functions YCV and PY are used and values are existing until then in the previous year. Right now this empty. The same also applies for custom time entities where this behavior can be observed. Expectation here: PY YTD should show 1…
-
Enable "Flatten groups level" option for End Users in Data Views
Make the "Flatten groups level" option available to end users via a dropdown menu to select the starting entity for flattening.
-
Substitution variable for chart objects
Hi, There is a limitation in current setup which restricts use of Substitution variables like @Selection, @Months in chart objects. The same works with data view. Can you please enable this for chart objects as well
-
Single selection in a Data View - can we have a new Radio Button appearance similar to Checkbox?
Hi Team, There is a requirement where the customer wants to ensure only one checkbox is being selected in certain Data Views when we change the appearance to a checkbox - something like a Radio button behavior. Currently the alternatives for this is by introducing a validation rule or do it via procedure, but would be good…
-
How to use Nexel to select custom time periods
*NEW - includes video demonstration. Build Along with Board Follow along as we bring this step-by-step guide to life. Quick reference: 4:32 - Custom time period selector 7:23 - Create members 8:38 - Create the cube 10:09 - Create Nexel layout > complete Nexel process begins here 1. Abstract While conducting reporting, the…