-
Maintaining same Font across Application
Hello friends Im looking for a way to standardise fonts across the board capsules, is there a way i can do same Rgds Khaleelah
-
Save issue
Dear Friends, On below screen , im trying to save the last completion date when status is updated and Finalised Date when Final is updated The two dates are cubes with same dimensions. A procedure with two dataflows has been written to save the dates as shown below. However, when updating the Final Column, the Last…
-
B14 - where is the option in a data view to select another database
Hi, I have a screen that is configured for multiple databases. In the selectors, I can select which database to use. However, I don't see the option in the data views. How can I select another database? Thanks RJ
-
Flex grid calculation
Hello, I am using the flex grid as below, the Var % is calculated as (78081-75790)/78081 * 100. This is calculated well on each line. However , when i am grouping and aggregating value, the variance is being summed up which is incorrect. It should have taken (10,498,902 - 11,700,011)/ 10,498,902 * 100 = 10 %, on the screen…
-
Screen Layout Design
Greetings everyone, I have this layout design I have not been able to realize. My report has many columns. Grouped and Summed by two columns(print/Cost) Any idea/resource on how to achieve this layout will be appreciated. Thanks
-
[Procedure] - empty all cubes in one times
Hello, Is there a way to empty all cubes in only one step into a procedure?
-
Layout with columns different period of time selected
Hello, I would like to have a layout with same entity with different period selected. Example column 1 with quantity period January December 2023 column 2 with quantity period January June 2023 Best regards, Gabriele
-
Template
Dear, Is it possible to create template which have selectors? Example below has been implemented on a screen. These are interactive selectors with capsule procedures. Now i need to use same on other screens. Is there a possibility to do so. Thanks
-
Hierarchy order
Does the order of the entities matter in a hierarchy?In below example, given sub brand is above Brand, does it affect selectors on screen if i select Brand before sub brand?
-
Gauge
Hello Everybody! Is it possible to put conditional formatting on a gauge? I would like to be able to go from red when we are close to 0 to green when we are close to 100%
-
Selector with only valid entity member but without the setting "show only active members"
Hi I have the following Issue on several entities. here explained with cost center and profit center as i think most of people know these. We have a cost center report with a selector on Profit centers and one on cost centers. Now if i select a profit center, all cost centers are available, even the ones not connected to…
-
Nexel won't write back to cubes on the web?
Hi, I have a layout using Nexel (with Allow Write Inplace highlighted) that commits data into a cube using a single rule. This works great in the client. However, on the web, it does not commit data to the cube when a "Save Data Entry" action is performed. Additionally, unlike in the client, the web does not even have the…
-
Nexel when transitioning to Web Capsules
Hi, I'm having an issue with existing Nexel layouts transitioning capsules from Client to Web (now on Board 10.7) - every time the procedure is ran (which includes 'Save data entry' step) Nexel doesn't save to the cube anymore (it only contains the values we prepopulate the cube with to give us a base). My current work…
-
@datetime not working
Dear, In below algorithm, @datetime returns invalid algorithm any idea abt this issue Thank you
-
Excel - SetSelection
Hello, I am trying to use the SetSelection formula in Excel to control multiple layouts (Board v9). The following formula works: =SetSelection("Finance","Year=2018") but when I try and change the entity to Fiscal Year it fails. I thought it might be because Fiscal Year is technically a custom time entity or because there…
-
Move file to archive directory
Dear, Is it possible to move a file after it has been read by a datareader to an archive folder. Is there a command that can be used in procedure to execute a copy command etc. Thank you
-
One to many Issue
Hello, Given that board recommends only many to one relationship / hierarchy. Consider one to many below Example Item ——— Company Company member 1 is parent to Item number 1 Company member 2 is also parent to item number 1 (Relational DB representation below) Item Company 1 1 1 2 So this scenario is not possible in board.…
-
Labels in Charts
Hi all, has anybody an idea to get this readable? Even when I take out TOTAL it is still not readable. Thanks
-
equivalent of join/where conditions in Board
Hi, Wanted to know if there is any equivalent for where conditions in board. Example let say i want to update a field in a conventional query (simplified for understanding) update table1 set field1value = table2.field1value where table1.feldname1 = table2.fieldname1 in board i cannot do a select on each cell of a cube and…
-
Drill Down popup
Hello, Can a drill down popup be configured to show totals found on the main screen dataview . like a summary of the information found on the main dataview for the user not to lose focus on the main information Thanks
-
Level 300 Part 2, Module 307
Hi Support, I have started Part 2 307, but I don't have access to Subscription Hub, and the other 2 accounts do not have access to the platform. Please help. Thanks.
-
Setting time range and time entity relationships
Once a year, I plan a task to extend the time range by one year. I tried extending it by a year, which resulted in unexpected changes to the time entity relationships. In the example below, the number of child entities Month for FY=2023 should remain 12, but has become 3. Before the time change After the time change I have…
-
With the new version of Board, doesn't give me the auto-save password option anymore.
After a new install of my laptop + new version of Board I no longer get the auto-save password option anymore. I'm using google chrome, everyone else with the team uses Okta, but I'm using username and password to login.
-
Level 200, Step 14 in Upload Sales Planning data
Can you please help? I could follow till step #3 in #14 It is not very clear to me from step 4 Create and add the two Data View objects below within the tab object and further steps.
-
Nexel crossview : Copy all rows from dataview A to dataview B ?
Hello Do you know if it is possible to paste value from dataview A to dataview B using Nexel Crossview ? Just copy / paste all values row by row. I'm trying to use this formula but with no sucess : =[#A;@a;*;Range.Vertical] =[#A;@a;*;*] Also should I use single formula or deep formula ? thanks julien
-
DATAGRIDVIEW TOTAL COLUMN WITH ENTITIES
Hello, What is the best way to have the total (yellow part) of the column MONTANTSAISIE? small precision: this is an entity data and not a cube one.
-
Data View text - not able to use Delete keyboard button
Hi, is there a reason why only the backspace of the keyboard to delete text a dataview with data entry enabled?
-
Rename Row Total as Grand Total
Is there a way to rename the rows totals showing up in data view as "Grand Total". The way I know is to add an algorithm, use rt(block) and rename it as Grand Total, but is there a way without adding a new algorithm block?
-
Dynamic Selection on Time Period Question
Hi, I have a question regarding report selectors. When you go to the selector and select a time period say "weeks" you are able to click "Dynamic selection" button. This option allows you to show "Enable Dynamic selection" on current date or based on cube with option of period, year to date, previous period and offset.…
-
Level 200 Modul 203
When is time to add the "Temporary cubes" seems like the system doesn't find anything so it keeps loading… So I can't set up the procedure.
