-
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…