-
Selection Options in Procedures
1. Abstract Board technology allows different types of select, static, or dynamic queries. In particular, in procedures, it’s possible to choose between three methods that can seem very similar: Selection (fixed) Select Entity based on Cube Dynamic selection (from the “Select” step) Although they can give the same result…
-
Dataflow common mistakes and best practices
1. Abstract The dataflow is the main action to perform calculations between cubes, it is used in all the processes of the application, therefore it is very important to know how to set up a dataflow in the best possible way, to obtain the correct results with the best performances. 2. Context In this article, we will first…
-
Moving Data
1. Abstract Often customers’ requirements are to copy data from one element to another. Typical examples are copy processes from one version to another or to copy data from an existing reference product to a newly created product as an initialization. The calculation logic in those examples is the same and can be applied…
-
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.
-
Copy of BLOB Cubes in DataFlows
Hi All, at the moment it is not possible to copy blob Cubes in dataflows. It would be great when a simple copy of BLOB Cubes in DataFlow would be possible. It also would be great if the target BLOB Cube could have some more or leass dimensions than the source BLOB Cube. Regards, FabFro
-
Make visible "by row" and "show all" option in Dataflow
As you might have noticed, dataflow behave differently if you create the layout directly or you copy it from and existing report having sometihing by row and flag show all set. Would be nice to have it visible directly in dataflow configuration instead of setting/viewing it only when you copy and paste back to a report. I…
-
Culture-sensitivity with @datetime in Smart Import
Hi, I have a bit of trouble with culture and the formula @datetime. I have a cube that is populated 2 ways: either the user uses a smart import object to fill other cubes, and then the datetime information arrives into this timestamp cube using a formula. Or, if the users don't want to input anything, they can click a…
-
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…
-
Dataflows : c=a*b versus c=join(a*b)
Hi everyone, I see in an application developed by consultants here, that some dataflows are using a c=join(a*b) formula, and I can't find the difference with "c=a*b" when I test on my dataflows. In some cases, "JOIN" appears in the db log as the algorithm, and some other time it's HBMP. Does anyone knows what is the…
-
Temporary Cube vs Staging Cubes
1. Abstract When developers create a simple or complex procedure, they need to know that they have an advanced feature to ease their job by keeping the database simple and lean. This feature is the temporary Cubes. 2. Context Since B11’s introduction, developers can leverage the temporary Cube to store data temporarily and…
-
Data Transformation
1. Abstract The data transformation process can be done in three different ways: 1. with SQL transformations directly in the data source or in the Data Reader Object 2. with the out-of-the-box Board ETL function 3. after the data has been imported into Board by using the dataflow engine. The type and number of data sources…
-
Data flow from Parent to Child Entity Not Working
Hi Everyone, I am faced with a problem regarding allocation of a value from a parent to a child entity which does not seem to work. Hope that someone can provide me with some insights. I am trying to flow data from a parent entity called Product Group to a child entity called Product. Relationship: Product ---- Product…
-
BOARD 11.1 - Dataflow not working
Dear all, we are migrating a database from 10.3 to 11.1 but dataflow do not work. We start to check this dataflow Net Sales (A) + Credit Notes (B) = Sales (C) A and B has these entities: Day, Document No, Order, Item C has these entities: Day, Customer, Order, Item Document No and Customer are into a relationship. All…
-
Previous Period Stock + Today's Movement = Today's Stock
Hi All, I have a question which I've asked some others about offline and haven't found an answer too, so I thought I'd try the community. I have a 'Stock' cube (by day) and a 'Movement' cube (also by day) - dimension of each are identical, and there is sparsity (64bit) To calculate today's (closing) stock the dataflow was…
-
Copying data from one year to another year
Hi Community, I have a requirement in which I have to give the flexibility to the user to select any year (reference) and move the data to another year (target). Any suggestion !!!!
-
Save data in ROLAP cube with DataFlow
I get the concept of data being stored in the DBMS vs database through rolap cubes. I have a dense cube linked and the table exist (can we override the default table name with something that is more meaning full to our organization?). Then I define a dataview with this cube and enable data entry. The list of ALL entity…
-
Difference between algorithm and Dataflow
Hi, i have a question about dataflows and algorithms Why does the applied algorithm returns different values for the following two cases? 1) as a result of a Dataview algorithm 2) as a result of a dataflow procedure I am performing a simple c=(a*b) dataflow process Thanks,
-
How to build an efficient dataflow to transform YTD values in Monthly values ?
Hi Board experts, Everything is in the title, we are working on a computation engine that works both with monthly and Year-to-date values. In a dataflow we currently do the operation to convert a monthly cube in a YTD value cube, but what would be the most efficient way to do the reverse ? How would you set it up to obtain…
-
What is Open Sparsity?
I've seen a few cases now where checking the Open Sparsity option on a dataflow does the trick to ensure data makes it to the destination cube correctly. I was hoping someone could help articulate when and why this should be used, or avoided? As I understand it, the opensparsity option removes any assumptions about where…
-
Dataflow resulting in small digit differences
Hello, i have an unexpected behaviour with a Dataflow. Performing a simple calculation, C = A + B, a double cube is somehow getting tiny amounts. All cubes are Double type. Representing the information in a dataview, all rows only have numbers with 2 decimal places: yet the subtotal shows very small digits differences…
-
Custom ETL functions
There are a wealth of etl functions available in the ETL Function Reference, but I would like the ability to write additional custom functions which I can reference in layouts and dataflows. As as an example, I would like to define variations on the lending calculations (PMT, IPMT, FV, NPV) that use our custom business…
-
Can substitution variables be used in a dataflow?
I have a data reader that is reading data from a database. I have included it in a database process. I would like to add a data flow step in my process to save the @datetime to a text cube. We can then display the correct time that this process last run on appropriate screens to let users know when the load was last run. I…
-
Dataflow execution methods: high performance in depth
BOARD Dataflow calculation methods The execution time of a single BOARD Data Flow can depend on many factors, like the size of the dataset, selections applied, sparsities etc... However, one very important element to be considered is the type of the algorithm that the BOARD engine adopts to perform the calculation. BOARD…