-
On-the-fly Calculations: Pros and Cons
1. Abstract The term “on-the-fly calculation” refers to all the calculations executed directly at the layout level, meaning that the result is not physically stored in a Cube. This directly affects drill-down functionality and has advantages in terms of reducing the overall size. 2. Context During the development phase the…
-
Allow for filtering in dataviews to work alongside aggregated functions such as 'distinct count'
Hi! Currently I believe that all filters in a data view are disregarded when a cube in the data view has the aggregation function - 'distinct count' enabled. We have found a work around (as we were using this to find averages), however this functionality would still be very useful in the future and in other use cases.…
-
how to trigger a procedure from dataview cell based on another datablock
Hello, I know from the Board manual https://www.boardmanual.com/board14/capsules/screens/objects/data-view/using-a-dataview.htm#data-view-drill-anywhere that i can trigger a procedure from a dataview single cell. Drill-Procedure If a Drill-Procedure has been configured on the Data View, select a cell and click the Drill…
-
if-condition in a data entry reverse algorithm
Hi ALL, I would like to write in data entry a value in a column algorithm in the block c and based on the value of the block d I would like block a or block b to become equal to block c. To do this, I enabled data entry on blocks a, b and c. The algorithm in c is "if(d=0,a,b)", and tried entering as reverse algorithm…
-
How use an algorithm picture on parents aggregation
Hello, I would like to use my algorithme picture on parents aggregation, When I use it it's working on children but not on parents. Have you a solution to display the picture on parents ? Best, Shanèse Rouabah
-
Procedure - DataFlow - Algorithm of dataflow (c=a*b) should show the headings of source blocks
When editing the blocks of a DataFlow LayOut, it's possible to set headings to each blocks. When saving the DataFlow, the heading of the target is displayed in the algorithm / detail, but not the heading of the sources. It could be usefull to have the headings set in LayOut for sources as well.
-
Latest Value Per Month
I have a cube by Employee, Cost Center and Day. I would like to populate a cube which is by Employee, Cost Center and Month with the latest value (as close to the last day of the month as possible) for each Employee, Cost Center combination as shown by screenshot. Doing an extract reload unfortunately does not work as…
-
Hardcode 'down total' formula to prevent it from referring to another block.
Hi, I've been having an issue where my 'Sales Mix (%)' calculation refers to a moving block from the layout, instead of maintaining the 'down total' function. To calculate 'Sales Mix (%)', I am using the algorithm: (Sales/Down Total (Sales))*100 or c/dt(c)% in the below example. The issue I am having is that the data view…
-
IF THEN ELSE
In the if-then-else step in procedure, A feature can be added where we can compare the value of two cubes instead of just numbers. It might save lot of efforts.😀
-
Excel AddIn Documentation
Hi Boardies We are currently trying to solve it with the use of VBA since no native solution came to our minds and we want to automatize it as much as possible. The problem is following: A single table (lets say, country, year, period (BoP, A, EoP)) grouped by countries on one screen. From the Excel sheet the table should…
-
Is it possible to add a "+" symbol in front of positive values?
Using the image above as an example, is it possible to add a "+" value in front of the 89.0% without writing it as an text algorithm in the data view? (as this is requested in multiple views) I understand it's possible to add a prefix in block formatting however that wouldn't recognise a value as <>0 so it would place a"+"…
-
Feature to add a "+" symbol in front of positive values only.
Currently this can only be achieved by using text algorithms, which can be very time consuming and difficult to manage across multiple screens/objects. Using the image below as an example, can we add a feature to add a "+" value in front of the 89.0% without writing it as an text algorithm in the data view? I understand…
-
Option for logical/automated selection of Procedure on a DataView/other button
Giving developers the option to set-up a selection criterium (Algorithm) which runs one of multiple saved Procedures in the background. (see screenshot) That is to be seen as an addition to the manual selection of the Procedure by the user currently available.
-
Algorithms admitted in Data Readers or dataflows
Hello, It would be very interesting to have lists 📑 of all the formulas, operations and algorithms that we can use in dataflows on the one hand, and in the ETL of datareaders on the other hand. Do these lists exist, and could you please provide them? Thank you very much.
-
Saving Time Function Forecast in a cube
Hi everyone. I'm interested in using the Forecast function in a cube that contains information about the sales amount until the past month, in order to obtain a prediction for the following ones. Currently I'm applying this Forecast function inside a dataview, the problem is that it takes too long to load the page. Is it…
-
Forecast Screen - Show total of an algorithm switching between two cube slices
Hi, I'm currently building a forecast screen. The requirements specify the following use case: the user selects a month and yeear months up to (excluding) the selected month show the actual value months including and after the selected year show the reference value (e.g. budget or estimate) In addition, the previous year's…