-
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
1. Abstract While conducting reporting, the essential requirement often arises to compare data across various time periods. This article introduces a method that enables users to choose a specific custom timeframe directly on the screen. Using a designated cube, users can dynamically select pre-defined custom periods. 2.…
-
Disable export of all layouts including the layouts for labels from Export data to Xlsx
Hi team, The "Export to xlsx" option at screen level export all layouts including the layouts behind a label. As this option is available to all users, it creates a security flaw where users can see all the cubes where they have been restricted using cube visibility. Can we either, Disable this feature for "User" licenses…
-
Quick layout : option to include automatically all relevant dimensions
Pain point: currently, configuring the quick layout function requires activating it on the layout, then adding all relevant entities. When a new entity is added to the data model, we need to go in all relevant reports, and add it manually in the quick layout setup. It takes times and it means very often we have consistency…
-
Expanding a column for a drilled Data View
Hi all, after drilling in the main Data View, I'm left with another Data View that has an "collapsed" column (screenshots below) If i manually expand the column and then save, once i go out the layout the column remain half hidden. I don't seem to find any option in the settings to expand the first column. How can i make…
-
Grouping of (data)blocks
Hi all, It would be a great enhancement if we could group blocks of a data view (headers). For example, blocks A to D could be related to MTD (Month-to-Date) and blocks F to I could be related to YTD (Year-to-Date) → instead of using static labels, or enriching the block headers with the Prefix MTD/YTD. This would be very…
-
Dynamic Color Alert
Hi All, I am seeking a solution for an issue I am currently facing. Specifically, I require a dynamic color alert, but it appears that I need to select the number to link to the color. Unfortunately, I am unsure of the maximum number that should be used. Kind regards, Andrea
-
Dynamic Visibility of Data Blocks (Hide When No Data is Present)?
I have a data view object that is storing 5 different report types in 5 different cubes. The rows are dimensioned by fiscal year and month and there is no dimension on column, meaning that the 5 columns are the 5 data blocks in the layout. I would like to hide data blocks (Legal Income Statement & Legal Balance Sheet in…
-
Refresh Data Procedure Step should also work for the Flexgrid object
With the Flexgrid Object it is possible to show many rows, columns, groups etc. Therefore it is designed to create tables showing large amount of data. In almost every case it is necessary to scroll or to close enhanced groupings: Unfortunately the scrolling position and the grouping is lost, as soon as the screen is…
-
NEXEL + CROSSVIEW + COUNTIF not working?
Hi all, On the row "0" of the second layout, I tried a deepest entity formula Nexel: =COUNTIF([#Data;@a;*;Range.Vertical],"=A") but can't make it count how many "A" lies on the first layout. I've also tried: =COUNTIF([#Data;@a;*;Range.Vertical],"A") =COUNTIF([#Data;@a;*;*;Range.Vertical],"A") And many others, but can't…
-
Module 213 - No data for Italy GBP on Profit and Loss Statement screen ?
Hello, I am triple-checking all the steps of module 213 and I still don't understand why I've got no data showing up on the Profit and Loss Statement screen on the GBP tab with country selector on "Italy", while I do have data for the UK GBP and for the Italy/UK LC tab. This is Italy GBP : This is UK GBP : This is what I'm…
-
Multiple "Detailed by" in Data view
Is it possible to use two ore more "detailed by" in an data view? It would like to report not only the average revenue / gross add per month by tarifcluster but by tarifcluster and a second or third entity.
-
How to autofit/autosize column width to width of object?
I have a simple dataview object where the size of the table itself is not as wide as the dataview object. Is there a configuration setting to autofit the column width/table width to the width of the data view objects?
-
Inclusion of specific period in exported data views
It would be very useful to include in exported data view precise period that was selected by user - for example specific year in 5 year forecast. Currently after report is exported it is not possible to see what selections were applied if user won't manually add them.
-
Add in "Layout settings" an option for the user to select how to display entity members.
Hello @Product Management Team , I would like to share an idea from a customer that could be helpful for dataviews. I don't think I found another article with the same precise request. Functional requirement and known limitation : Let the "User" visualize the entity members "by row" (or "by column") with a different…