-
Level 300, Module 305 - Functional Q1, GBP not visible
There was an error rendering this rich post.
-
Cube Variances: Myth or Legend?
Hi Board Community, In Board 12, I see the Cube Variance options under Cube → Variances (e.g., LastDataFlow, LastDataRead, Minute, Day, etc.). From my understanding, enabling something like LastDataFlow should make Board automatically store a snapshot of a cube’s data before each Dataflow execution that writes to it,…
-
Board Impact Analysis: A Powerful Developer Tool
Author: Bart Scott, Board Developer at CFO Solutions LLC and Community Captain Board Impact Analysis is a very powerful tool that can be used to assess impacts of proposed changes as well as help in debugging, when used properly. There are two different areas you can utilize the Impact Analysis within Board. Only Developer…
-
level 200 - module 203 - Build a Screen to visualize the loaded actuals data
Hello, I am having a challenge with previewing data after completing the steps below My preview returns empty. with just product in the first row and total in the second. No other data is present. I suspect that I may have missed a step in the set up of the temp cube, but I struggling to find what it is based on 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
-
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…
-
YoY Growth
I am creating an application where I have to show YoY growth of every expense present in dataview. What's the best approach I can perform to add YoY growth percent below every expense without adding that member in the entity already used. Attaching the screenshot for the reference.
-
YoY Growth Calculation
I want to calculate the YoY growth of every expense mentioned in the cube and want to show it in the dataview. attached the screenshot of the view I want to show in the screen.
-
Cubes
Let's suppose I have a cube with dimensions month, scenario, version, competency and another cube with dimensions month, scenario, version, los, location. The end cube in which I am storing the value also has location at it's dimension. LOS and competency entities are in relation LOS being the parent and competency being…
-
copy "date" type cube into a "text" type cube
Hi All, I’m looking for the correct formula to use in this dataflow: Cube D is a "date" type cube. Cube E is a "text" type cube. Don't worry for The selection I’m unable to find the correct formula in the IF Statement to paste the value into the text cube (TEXT(D),"DD/MM/YYYY"). As a result, the output of the dataflow is…
-
Can we change data through dataflow using RDB cubes?
Hi All, Thanks for reading my message. I'm developing one dataflow, using RDB and MDB cubes, and I'm not able to change or update data into my RDB cubes. However, I can make changes using a direct data entry. Is it possible to use dataflow to delete, update or create rows into RDB cubes? Thank you.
-
date cube : data entry
Hello everyone, I am facing an issue related to the use of a date cube. In a layout, I have a date cube (structured with only 2 dimensions, including the year) open for input, which allows identifying the start of an allocation on a specific day. The default year displayed is the current year, but I would like to display…
-
Procedure to populate cube
Hi all, i just want to ask how to do the following thing: basically i have Cube A (1 dimension as Entity ) and Cube B ( Month dimension) i want to create a procedure that can use Cube A to populate Cube B based on a month selection. I hope you can help me with this problem. Best regards, Andrea
-
Hide specific rows
Hi BOARD Community, I'm trying to create a cube (which has the following dimension "SPV"; "Month"; "Item" and " Class"). The objective is to re-create the excel table attached below I would like to hide some combination (in rows) because i have to do combination on the exact Entities that i have in the screenshot. With…
-
Extract layout
Hi all, i want to know if it is possible to extract a date cube A (dimension: Entity) on premise: into something like this in a txt or csv file. sv0001 20241107 1 My final goal is to use this file for a data reader to populate a cube B with two dimensions (Entity and Month) with the same values as in the picture. P.S. I…
-
Best practice data import and update CSV
Hello, I'm new to the board world and am having a bit of a hard time finding the right way to import weekly updated data from a .csv file. What would be the correct/best procedure to import the data and update it weekly. I'm really missing the common thread, where should I start? First create the entities or cubes or data…
-
Optimal Management of Temporary Cubes to improve RAM Efficiency in Procedures
In my current Board implementations, I rely on temporary cubes extensively due to their impact on readability and performance management. However, I've noticed they can consume considerable RAM, especially during data-intensive procedures. Given this, I’m wondering: does it make sense to clear the content of temporary…
-
exchange cube on premise
Hi everyone, My colleague and I are currently trying to modify the same data model on our respective PCs on premise. How can we exchange data cubes once we create one? (i don't want to send every time all the database) Thank you!
-
How to store data in cube structure:Microsoft PowerPoint
How to store data in cube structure:Microsoft PowerPoint I was able to create a cube, but I don't know how to input the data. If anyone knows how to do this, could you please tell me? Also, if you know how to use cube structure: Microsoft Excel, please let me know.
-
How to create a variance on one cube detailed by version
Hi, I am trying to create a variance column based on one cube that is detailed by version. The problem that we have is we have data in one cube by different versions. We have to create a report to compare versions together but we must be able to select any versions which means I cannot create a block reference on teh cubes…