-
Selection by a cube
Hi, I have a screen selection by a cube. When I do another selection on the same hierarchy / relationship it removes the cube selection. Hotel is part of a country I select through a cube all active hotels. When I now select only some countries it shows inactive and active hotels because the cube selection has been…
-
Advanced Smart Import
1. ABSTRACT The Smart Import object facilitates the upload of data (master data, transactional data) to Board. Before, Dataviews with line number entities or CSV blob cubes with export/import procedures were required to upload the data. In addition, a complex check logic (if implemented at all) was required to detect wrong…
-
Level 200 part 204
Hello, when I go to Select the "Initialize Budget" label in play mode on the "Sales Planning" Screen to run the Procedure to initialize the budget, the Variance and Variance % columns are not valued in 0 and I don't understand why. I attach the "Sales Planning" screen, the related Selectors and procedure . Thankyou for…
-
Level300_Module304: Functional test, Question no 3, Values fall apart starting Aug '23
Hi, I noticed that there is a mismatch between the P&L structure in trainings environment and the board academy module 304 functional test. The question is And this is the screenshot which you should meet: Values are matching Jan to Jul '23 but fall apart after. I have checked and the Total income is fine for the whole…
-
In RTF cubes table boarder not working
Hi team, We’re facing an issue with extracting specific RTF data in table format — the table borders aren’t being captured, even when we paste the content. Will the latest version include support for extracting tables (with borders) from RTF cubes? or any workaround?
-
dataview algorithm block: how to set summary mode to 'no total'?
Hello, I am wondering how to hide the total value in a dataview for a block of type algorithm. This is actually possible for a block of type cube: but i don't see it for a block of type algorithm: Do i oversee some options in the block settings within the layout window ? as a workaround, i play with foreground and…
-
Level 200: Module 216: I am not able to scroll down and view the net income, total expenses
I have got all the functional test right but at the end I am not able to view the Net income, Total Expenses and other details. Is there any wrong in my P and L rules, I have attached my P and L rule also
-
Flexgrid Headers
How can we remove these annoying aggregation functions indication from the Flexgrid Headers? It makes it impossible to fit columns to the needed width without making the header unreadable. I would also be fine with the possibility to wrap the header text. Moreover, the possibility to use @Selection in the header has…
-
Year-End Value While Retaining Month Drilldown
Good afternoon, I am trying to create a graph that displays the year-end value. At the same time, I want to maintain the ability to drill down by month and see all the preceding monthly values. Does anyone know a method to achieve this in the graph? Thank you.
-
Flex Grid header colors
G'morning all, Previously, I was able to have different background colors on a Flex Grid header so that text input to the filter box in each column is visible (first screenshot). Now, the header background is only one color which isn't helpful when a user inputs text to filter. Yes, I have matched all colors between the…
-
Waterfall Chart
Hi Team, I have created a waterfall chart as shown below. The end user would like to display both the values and the percentages. However, I haven’t found any settings that allow both to be shown simultaneously. I attempted to use the Tooltip feature to display the percentages, but that didn’t work either. Is there a way…
-
Struggle to understand NEXEL
Hi BOARD Team, After reading through the manual, I still cannot understand how NEXEL reference works. In our production system: Active cell is 5.6. Formula is =[@b;-1;*]/AVERAGEIF([@b;-5;*]:[@b;-5;+12],">0"). My understanding: [@b;-1;*] pointing to 7,162. Is it correct? [@b;-5;*]:[@b;-5;+12] pointing to Demand layer for 12…
-
Best practices how to show many columns in dataview (>10 columns with a hundred thousands data rows)
Hi all, I want to know the best practices how to show many columns in dataview with approximately >10 columns with a hundred thousands data rows in a dataview. Because I am stressfull a lot about limitation error rows limit issues. I have read many references from other forums/discussions about this one, and overall of…
-
Representation of a diagram
Hello everyone I have the following initial situation (see also the attachment): I want to create a chart in which I have to expand a cube after an entity, but not the other cubes. I solve this via detail by on the cube in the layout. However, the problem is that I want the values of this expanded cube to be displayed…
-
Issues with 'Detail by' sorting feature
This issue has popped up in the layout editor after I added an entity in the configure drill down. The data is tying out correctly for all my data blocks, the only issue now is when I try to drill down on a specific P&L line. The drill down shows every member in the entity rather than the specific line I am trying to drill…
-
Question about Label
Hi all, I'm trying to figure out how to cancel the label's animation. I'm using the label to partially cover an image by adjusting its opacity, but whenever my cursor hovers over the label, it lights up based on the label's color. before and after do we have other Object to use it or some setting for the label? thanks 😀
-
Account Set up
Hello Community! My boss/Board expert just left, and I have a simple question for your experts out there! Where can I go to see how an account is calculated in the P&L? Thank you for your help!
-
Loop function doesn't work
Hi all, I'm trying to do a loop calculation, but for some strange reason some of the numbers don't add up the cube has 2 dim (month and Drivers in blue) the first member of Drivers (baseline) has only the value in the first month, while for driver "a" "b" "c" i can data entry after the first month my goal is to copy the…
-
Suggested value in Excel Add-in
Hi ! Is it possible to show suggested value feature to user when using excel add in ? Also can I put data validation check in excel add in?