-
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…
-
Filter in Data layout
I have added a filter in data layout and the main value should be 1. Even though in 2 of the members of the entity (whose codes are used as filters) values are here but these members are not visible when in playmode but are visible in dataview when in design mode. Any resolution to this issue.
-
Smart Import errors, add a 'download error list' button
Smart Import - as a user, I click the upload, select an Excel file. A dialogue box appears with errors: I have a list of errors. I need to fix those errors in my Excel file. I open the Excel file, find E2, for example. I see what needs to be fixed… but I don't know the correct data I should enter. I have to go back to my…
-
Level 204 : Can't see any data for Italy Units | Sales
BUILD THE SALES DATA MODEL : Run Data Reader to load sales data into empty TEMP Cubes I followed the previous instruction and selected the "UK_Sales data" file + RUN. Then, when I open my Capsule Screen, i can see data for UK. (see below) After creating the selector buttons, and selecting "ITALY" in PLAY MODE, i can't see…
-
Validation rule smart import
Hi everyone, is it possible to set a validation rule in the smart import object that validates my data only if the column total (column F) is equal to 1? I tried different syntax but I'm always receiving syntax errors, can you help me? Thanks in advance for the support! Andrea
-
Add a few Substitution formulas
Add a few Substitution formulas: Substitution formulas @computername equivalent to %computername% Substitution formulas @userrole matching the user role Substitution formulas @userdisplayname matching the user display name Substitution formulas @timestamp matching %timestamp% that is culture insensitive (unlike @datetime)…
-
Total Calculation algorythm / nexel
Hi all, anyone an idea how i can fix the total / grand total calculation? You can see that i calculate the average per country however the calculation doesn't work on the Grand total line. the expanded view looks like that 42 isn't recognized as a number. any ideas? thanks maik
-
When a DB is loading in RAM, Board platform is freezing
Hello, When database "X" is loading in ram, then users have to wait for the end of DB load to access data on that DB ⇒ OK normal behavior. However, it also impacting other users that are working on DB "Y" already loaded in RAM. Users of DB "Y" are also stuck and can no longer access the data. They also have to wait for the…
-
Setting Up Version-Based Security for Drill-Downs
I am working on Board and have created a cube with two versions: one that includes an 'Employee' dimension, and the other without it (version 0 being the base with the 'Employee' dimension). In our Board screens, we have the ability to filter by 'Employees' and drill down to see the list of employees. However, some users…
-
Question Related to Data Integration
I have some question related to Board I hope that i will be able to get help for this, it would be really appreciated Here is the question : 1. Is it possible to board to import data with an insert update mode ( where there is a difference in the cell it will be updated , but if there is none it will be left as it is, and…
-
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…
-
B.E.A.M Forecasting Feature
Hello, I'm using board 12.6 version. Currently working on a project that requires some predictive Analysis. In my Data Model designer space, I can't find the B.E.A.M Forecasting tile. Is this tile unavailable for board 12.6 version? Does anyone have another approach that I can look into to perform predictive analysis?…
-
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…
-
Monthly Customer News Update - January 2025
As we welcome the new year, we would like to extend ourheartfelt gratitude for your continued support and trust in our products andour people. We look forward to serving you with even more dedication andexcellence in 2025. May the year ahead bring you joy, prosperity, and countlessopportunities. We're excited to share the…
-
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…
-
CLOUD DATA PIPELINE PORTAL
Dear , I am asked to use provided credentials on first login to the CLOUD DATA PIPELINE PORTAL. However when using the credentials shown on the screen, the login fails. Even using my board credentials , authentication fails Any idea please Rgds
-
Master Layout - Select dependancies
My idea: In the same way you can choose which dataview synchronize with an other for scrollbars : it would be nice if when enabling master layout you could set for every object which dataview is the master. And therefor also enable multiple master object Use case : My customer has a screen split in two visible section,…
-
Add a way to maintain Master Layout selection after procedure ran and refreshed data in the screen
Currently, when you have a Master Layout in your screen and the have data entry enable in either the master dataview or a slave dataview, you will only keep the Master Layout selection if you use a default "Save data entry". If any procedure is required to do some calculation and therefor you need to refresh some…
-
Datareader - Option to Log row where validation condition isn't satisfy
The idea Add an option to have the discarded line from the data source saved in a log file when the validation condition isn't satisfy Use case : Sometime, you now the row is in error and discard it as to not mess up the entity but it would be preferable to have a simple way to show the error to the end-user to ensure the…
-
Data View Layout
Hi everyone, hope you're all well! I was hoping someone could show me how I would go about creating a variance value between each individual month for and entire calendar year ? I have created an algorithm block for Net Investment and then created a 2nd block using the same algorithm to set it as the prior month value,…
-
Dynamically select the Last 12 months based on the Pager value
Hello, I am trying to find a way to select dynamically the LTM for a bar graph in a screen that has a Month pager. I created LTM Flag cubes and a procedure based on the example made by @Sudeep Palkar and modified it to work with months but no success. Please how can I make the procedure that sets the flag work? I am…
-
Ability to pass selection as variables to SQL data readers to optimise query performance
What is your idea? Ability to pass the selection as variables to SQL data readers to optimise query performance What specific problem are you trying to find a solution to, or what new scenario would this idea respond to? When using SQL data readers, we usually write SQL queries that cover all members of entities in the…
-
Module 210 - Data not showing on Expense Planning Screen for the UK
Hello, I can see this was an issue for previous users but the steps in those discussions have not worked for me. After configuring the layout for the table, and applying the toolbar selectors, no data pulls through when I choose the UK. However, it works fine when I select Italy. My data procedure was adjusted as advised…
-
Allow New Objects To Be Transported Via Capsule Package When Folder Security Is Enabled
Currently, if folder security is enabled on environments, the capsule transporter (capsule package) process will fail on execution when transporting new objects. It will still fail even with god-like permissions and write access to all capsules via folder security. This is a result of the system not recognizing the new…
-
Badge of the Month: September
Summer is in the rearview mirror and with that comes the push to end the second half of the year strong! Thanks to our many August badge earners for their contributions, @Nico Weber, @Crystal Zhao, @Rishabh Shahi, @Zayaan Wasif, @Mindy Waltz, and @Miran Saric. As always, the Community is better because of your…
-
How to use period by period recursion
1. Abstract This article will highlight the advantages of seamlessly incorporating a native functionality, like the “Period by Period recursion” function, within a business context. It illustrates how this integration simplifies tasks, boosts scalability, and optimizes maintenance, providing practical insights for its…
-
Conditional Formatting on Bar Graph
Hello, I may have missed something here but is it possible to apply conditional formatting on a Bar Cartesian so that all bars that have positive values will be green and negative values red? As of now, I can only format the graph background by using the Color Alert, and Visible and color blocks in Object Settings.
-
Enable direct entry of the row number in the ETL Data Reader
Hello, Would it be possible to enable direct entry of the row number in the ETL Data Reader? This feature would provide a quick way to check our data and formulas, especially for large data sources (e.g., in my case, I have 200,000 rows).
-
Announcing the 2025 Q1 Community Captains!
We're thrilled to announce the 2025 Q1 Community Captains! As we move forward into a new year with new challenges and opportunities, our Captains will help lead the way through active knowledge sharing and engagement in our growing Board Community. These new members join an amazing group of returning Captains,…
-
2025 January Badge of Impact
Happy new year from the Community team! Let’s kick off the new year by building on our momentum. This year, we’re introducing a refreshed name that better highlights your contributions: the monthly Badge of Impact. The goal remains the same--share your insights to elevate the Community and learn from others. Stay tuned,…